Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-01 : 00:19:16
|
David writes "I am new to SQL Server and am trying to develop a backup strategy. I am currently working with the standard install database. According to the SQL 7.0 book I have it states to backup master, model & msdb and not to backup tempdb.
My plan is to do complete backups once a week (Sunday night). I also have a daily backup plan that involves the following:
at 10:50pm backup the transaction log for model & msdb
at 10:55pm truncate the transaction logs for model & msdb
at 11:00pm differential backup model & msdb
I am backing up to local disk which gets written to tape on a weekly basis (this is why I only do full backups once a week).
I plan on backing up any application databases on the same routine as model & msdb.
Does this sound like a good backup strategy?
If not, what should I do differently?
Thanks for the help." |
|
|
|
|
|
Backup Strategies