SQL Server 2000 backup failed

5 pts.
Tags:
MSDE
SQL Server 2000
SQL Server 2000 Desktop Engine
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:fjs1education_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:fjs1education_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:fjs1education_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:fjs1education_db_200801080954.BAK';

Event Viewer: Application Log:

3041 :
BACKUP failed to complete the command BACKUP DATABASE [education]
TO DISK = N'D:fjs1education_db_200801080917.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Job History:

Message
Executed as user: COUGARSSQLAdmin_juxa. Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998 Logged on to SQL Server 'FRIPP'
as 'COUGARSSQLAdmin_juxa' (trusted) Starting maintenance of database 'education'
on 1/8/2008 9:17:03 AM [1] Database education: Database Backup...
Destination: [D:fjs1education_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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you look in the log folder you should see logs while were created by the SQLMaint Utility. The the newest one for the backup job and see what’s in there. It should give you more info about what caused the failure.

Database backups most likly fail because the disk runs out of space.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,065 pointsBadges:
    report
  • Denny Cherry
    Where the sqlmaint logs able to sheed any light on the problem?
    66,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following