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 |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2004-12-16 : 04:39:40
|
Hey all, When you backup your sys db's to a device, do you use more syntax to overwrite any other data there of do you just have the following for example ? : BACKUP DATABASE msdb TO backupDevice |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-16 : 06:50:43
|
| To overwrite the existing backups on that device, add WITH INIT to your BACKUP command. Books Online details all of the backup options very thoroughly.I backup my system DB's to 7 different backup files, one for each weekday, which get overwritten (WITH INIT). |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-12-16 : 06:52:58
|
lol you just reminded me of my course, we were banging on about chav's init  thanks thats a great help and a useful tip  |
|
|
|
|
|
|
backup jobs, overwrite?