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 |
|
hvdtol
Yak Posting Veteran
50 Posts |
 Posted - 2002-07-12 : 15:25:40
|
| Windows 2000; Sql 7.0I need some advice.I want to make a daily backup from the Master and Msdb database.Both store information about backups. Msdb: history of backup operations and Master: backup devicesI run a daily job which adds a dump device and then perform the backup.My question is: which database to backup first in case either one of them have to be restored? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-13 : 11:27:12
|
| I wouldn't worry about it. Schedule them both in the same job - a maintenance plan would be the easiest - both databases are very small and full backup shouldn't take more than a couple of seconds.HTHJasper Smith |
 |
|
|
|
|
|
Backup order: Msdb and Master