Home All Groups Group Topic Archive Search About

SQL Server maintenance fails

Author
1 Jul 2006 2:00 AM
aneeshattingal
Hi,

The sql server maintenace job is failing giving the following log. Whenever
i restart the Service it again starts running .. Everyday this is happening
...

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server as
'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Plan1' on 6/28/2006 7:30:03 PM
[1] Database NFDFN: Database Backup...
    Destination: [e:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\db_200606281930.BAK]

    ** Execution Time: 18 hrs, 34 mins, 27 secs **

[2] Database db: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 3204: [Microsoft][ODBC SQL
Server Driver]Unspecified error occurred on SQL Server. Connection may have
been terminated by the server.
[Microsoft][ODBC SQL Server Driver][SQL Server]Operator aborted backup or
restore. See the error messages returned to the console for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
[Microsoft SQL-DMO (ODBC SQLState: HYT00)] Error 0: [Microsoft][ODBC SQL
Server Driver]Timeout expired
End of maintenance plan 'Plan' on 6/29/2006 2:04:58 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

AddThis Social Bookmark Button