We are using SQL Server 2000. There is a maintenance plan to backup three databases on a daily basis (full-backup) and their transactional log every 4 hours.
All the jobs have been running well, however, since last 3 days the transactional log backup job has been failing for one of the three databases. Transactional logs are stored on same location on disk.
I checked to confirm that there is enough space on the disk. Performed DBCC command on the database and that returned 0 errors.
I noticed the following errors:
From SQL server log:
“BACKUP failed to complete the command BACKUP LOG [XXXXXXXXXX] TO DISK = N'H:\XXXXXXXXXXXXXX.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT”
From Database Maintenance Plan History:
“[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241: [Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'H:\XXXXXXXXXXXXXXXX.TRN' is incorrectly formed. SQL Server cannot process this media family. [Microsoft][ODBC SQL
Server Driver][SQL Server]BACKUP LOG is terminating abnormally”
Any help would be greatly appreciated. I've been a developer and now have to take c
View Complete Post