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 |
|
KimJ
Starting Member
38 Posts |
 Posted - 2005-02-08 : 09:58:50
|
| Hi -I'm running into some serious issues with a database. Last week, the log file grew to such a size that it took up all the disk space. I ran the statement DUMP TRANSACTION [databasename] WITH NO_LOG, and then shrunk the log file. Now, the database backups are failing, and we are getting the errorThe backup data in 'F:\MSSQL7\BACKUP\databasename' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.What the heck did I do? How can I fix this?!?Thanks in advance, Kim |
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-02-08 : 10:00:03
|
| If this helps, this error message also appears...BACKUP failed to complete the command BACKUP DATABASE [dbname] TO DISK = N'F:\MSSQL7\BACKUP\jobname' WITH INIT , NOUNLOAD , NAME = N'dbname backup', NOSKIP , STATS = 10, NOFORMAT |
 |
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-02-08 : 10:05:46
|
| Also have this:Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. |
|
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-02-08 : 10:51:41
|
| Okay, the microsoft support site says to run BACKUP DATABASE mydatabase TO DISK='C:\MyDatabase.bak' with FORMATdoes anyone know if the 'C:\MyDatabase.bak' should be replaced with the current location the backup file goes to?Scratch that - did some more research and replaced the location with the current backup location. The job failed.I created another backup job with the same parameters as the one that keeps failing, except I changed the location, and the job ran fine.Kim - in over my head |
|
|
|
|
|
|
|
|
backup data incorrectly formatted