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 |
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2007-01-09 : 11:07:47
|
Hi,I am getting following error while I try to backup the DB in a scheduled job. There other DB backuped successfully in same job in different steps.The backup data in 'G:\*********.bak' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.thanks in advance. |
|
Kristen
Test
22859 Posts |
Posted - 2007-01-09 : 12:31:47
|
Disk full?Sounds like you are appending multiple backups to a single file. It would be safer to use separate files for each backup - e.g. incorporating the Date/Time into the name of the backup file.Kristen |
 |
|
|
|
|