Backup Strategy

I am currently handling SQL SERVER 2005 with 6 instances each having about 10 databases. The databases range from SIMPLE to FULL recovery models. My first assignment is to present to management a very good backup strategy that would make recovery of the databases to a point in time in case of any eventualities. As part of this strategy should be a storage plan for the backups files. What is the best strategy that I can present to management?
Who is Participating?
ServerGuyScottConnect With a Mentor Commented:
Start here:

Then review this:

I would typically recommend having 3 separate volumes for your SQL environment... a drive for the SQL data we'll call it (D:\) and then a drive for SQL logs (E:\) and a drive for SQL backups (F:\)

Also make sure you are running at-least weekly fully backups of the server itself with nightly incremental backups.

Hope this helps!
Aaron ShiloChief Database ArchitectCommented:

read this great articale on sql server magazine by "Michael Otey"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.