Solved

Backup Strategy

Posted on 2011-03-19
2
297 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:mamlaide
2 Comments
 
LVL 3

Accepted Solution

by:
ServerGuyScott earned 500 total points
ID: 35171411
Start here: http://msdn.microsoft.com/en-us/library/ms191239%28SQL.90%29.aspx

Then review this: http://www.mssqltips.com/tip.asp?tip=1229

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!
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35171816
hi

read this great articale on sql server magazine by "Michael Otey"

http://www.sqlmag.com/article/backup-recovery/sql-server-backup-best-practices.aspx
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now