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.

I have a Critical Production Database for sql server 2008 which is in Simple Recovery Model Currently. I have to change the Recovery Model back to Full. I have to develop a Strategy to take Full, Differential and Transactional Log Backups. So my questions is: What is the First Step should i take after i change the Recovery Model to Full? How do i set up the Diff Backups and Transactional Backups? What are the Interval time should i take for each backup. Please help.

Thanks.

share

merged by Chopper3 Jun 14 '11 at 12:59

this question was merged with Sql Server 2008 Backup and Restore because it is an exact duplicate of that question.

1  
possible duplicate of Sql Server 2008 Backup and Restore –  squillman Jun 14 '11 at 12:45

Browse other questions tagged or ask your own question.