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 |
|
cgunner
Yak Posting Veteran
95 Posts |
 Posted - 2006-01-17 : 08:39:34
|
| I have a very strange problem. I do daily backups of my system databases threw a maintenance plan. When the job runs, it backs up the Master and Model without problem. When it hits Msdb, the job fails with:Database msdb: Verifying Backup...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241: [Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'D:\System DBs\msdb\msdb_db_xxxxxxx.BAK' is incorrectly formed. SQL Server cannot process this media family.[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is terminating abnormally.I can manually run a backup by right DB, all tasks, backup database. It does not give an error and seems to back up the entire database. When the job runs, it errors out and creates a much smaller file. I have also run DBCC Checkdb on the database. It returned no errors. Any suggestions? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-17 : 08:43:07
|
| Are you appending your backups to an existing file? (I don't think Maint Plans can do this, but just thought I would ask)Maybe the disk is physically damaged?Has the location of the backup files (ie. "D:\System DBs\msdb") changed recently? (I've had problems with spaces in the path with some backup commands, Note that I'm not sure that they were system problems, they might have been problems of my making!)Has the system changed recently - Service Pack perhaps?Kristen |
 |
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2006-01-17 : 08:58:05
|
Hi Kristen,I am not appending the backups. We try to keep one previous day on the server just in case. Nothing has changed in regard to SQL or the OS. The drive has 10Gig free. I just thought it is strange that the job fails and a manual backup works.  |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2006-01-17 : 10:54:04
|
| Thanks franco. After looking into things deeper, I found that I had some very large SQL Error logs. I used sp_cycle_errorlog to roll them off and re-ran the job and it worked. My guess, it may have been trying to write to the log and it couldn't. |
|
|
|
hemalshah
Starting Member
1 Post |
Posted - 2008-04-20 : 17:36:37
|
| I also faced a smilar prob on SQL 2005... I cleared the error log and it working with out any issuesThanks,HS. visit me at www.hemalshah.net |
|
|
|
|
|
|
|
|
DB Backup threw a job