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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-02-09 : 10:01:11
|
| I have the following backup command which backs up the database to a device.I have specified the 'with init' option but still the backup is being appended to the device instead of overwriting it.backup database test to test_device with init |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-02-09 : 16:25:30
|
| how r u checking that backups are appended and not overwritten? |
 |
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2011-02-10 : 07:03:31
|
| If you want to overwrite all existing backup sets every time, use the FORMAT option. INIT only overwrites existing backup sets if the existing backup sets have expired (provided using the EXPIREDATE and RETAINDAYS options during the original backup) and if the backup name matches.Ray MondRESTORE VERIFYONLY - don't bet your job on it! Learn why here. |
|
|
|
|
|
|
Backup database WITH INIT appending