Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are currently evaluating Data Protection Manger 2010 and need advice on the best SQL backup strategy for a 5GB database on SQL Server 2008.

Log shipping is setup on this so synchronization to DPM isn't possible, should more Express Full Backups be taken to compensate?

Also, we would like to have a monthly backup taken off site along with each days transaction log backups. How would this fit in with DPM or should agent jobs do this backup?

share|improve this question

1 Answer 1

Use the WITH COPY_ONLY option for any additional backups you wish to take off site. The option does not interfere with any log shipping schedule or other scheduled backups. Read the full store here

share|improve this answer
    
Thanks. Would the following be advised: DPM takes 2 x Express full backups daily. Log shipping runs every 15 mins and these trn files are stored off site with a daily copy_only backup for recovery scenario where DPM isn't an option –  Paul McCowat Jun 8 '11 at 8:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.