SQL Server 2000 backup failed
SQL Server 2000 Desktop Engine, MSDE, SQL Server 2000
can not backup a 2000 db, dbcc checkdb ok. see following:Errorlog:
2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'.
2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
2008-01-08 10:19:18.34 backup BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'C:\fjs1\education_db_200801080954.BAK'
WITH INIT , SKIP , STATS = 10, NOFORMAT;
2008-01-08 10:19:41.17 backup BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'C:\fjs1\education_db_200801080954.BAK'
WITH INIT , SKIP;
2008-01-08 10:27:57.81 backup BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'C:\fjs1\education_db_200801080954.BAK';
Event Viewer: Application Log:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'D:\fjs1\education_db_200801080917.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Job History:
Message
Executed as user: COUGARS\SQLAdmin_juxa. Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998 Logged on to SQL Server 'FRIPP'
as 'COUGARS\SQLAdmin_juxa' (trusted) Starting maintenance of database 'education'
on 1/8/2008 9:17:03 AM [1] Database education: Database Backup...
Destination: [D:\fjs1\education_db_200801080917.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3013: [Microsoft][ODBC SQL Server Driver][SQL Server]
BACKUP DATABASE is terminating abnormally.
End of maintenance for database 'education' on 1/8/2008 9:17:03 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed). Process Exit Code 1. The step failed.
0
