Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup job fails with Error 3013 Expand / Collapse
Author
Message
Posted Tuesday, August 12, 2008 8:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 72, Visits: 251
I have a backup job that takes a full backup of my production database on a daily basis.

It was running fine but all of a sudden, it failed with the following error message.

Message
Executed as user: NT AUTHORITY\SYSTEM. Write on "D:\MSSQL\SQLBackup\Prod_CT.bak" failed: 1(error not found) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

I tried executing the backup statement from the Query analyzer and that also failed with the same message.

I changed the location of the backup file to D:\Prod_CT.bak and tried executing from the query analyzer and it worked fine.

The syntax used for the backup job is as mentioned below.

backup database Ctrack to disk = 'D:\MSSQL\SQLBackup\Prod_CT.bak' with init

Any pointers would be of much help.
Post #551036
Posted Tuesday, August 12, 2008 9:20 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Are you able to take the database backup to the specified location
using enterprise manager manually?

Manu
Post #551111
Posted Wednesday, August 13, 2008 5:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 72, Visits: 251
Manual backup from enterprise manager is also failing with the same error.

This is a SQL Server 2005 instance. Also, the backups were happening fine earlier.
Post #551785
Posted Wednesday, August 13, 2008 12:07 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Please check tis link and let me know whether it helped or not:-

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=291159&SiteID=17


MJ
Post #552160
Posted Thursday, August 14, 2008 4:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 72, Visits: 251
Thank you for your response. Unfortunately, the default backup location is the same in the registry and the account executing the backup has the required permissions in the backup location.

Also, I re-enabled the schedule to execute yesterday night and it has completed successfully.

I am not sure why it failed and fixed itself automatically
Post #552526
Posted Sunday, January 24, 2010 10:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:01 AM
Points: 110, Visits: 709
you can cehck in your sql server log to find out why the backups failed. generally it turns to be an IOerror
Post #852826
Posted Tuesday, January 26, 2010 12:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 9, 2010 5:35 PM
Points: 3, Visits: 149
What is size of database/s? Is your folder compressed?

I had read somewhere, that if your database size increase to 30-40 gb and backup is taken in compressed folder then it will tend to fail with the same error. And if it increases beyond 50 GB it will fail.

Also check if the disk backups jobs are not running at the same time.
Post #853883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse