I have a re acurring problem with a Sql 2000 database, for some unknown reason the temp database explodes and fills up the disk, subsequently on the same partition the user database backup fails because there is no room left.
When this happens the Sql log says the following -
The backup data in 'F:\MSSQL\Backup\dbname' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.
I have to copy the backup files affected to another location and then re run the backup for it to complete.
Are the old backup files still valid? is there a better way round this?