Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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