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.


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.

Browse other questions tagged or ask your own question.