|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server maintenance failsThe 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) |
|||||||||||||||||||||||