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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup error

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
Go to Top of Page
   

- Advertisement -