Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup job fails with Error 3013


Backup job fails with Error 3013

Author
Message
Mohammed Imran Ali
Mohammed Imran Ali
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 258
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.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1712 Visits: 8766
Are you able to take the database backup to the specified location
using enterprise manager manually?

Manu
Mohammed Imran Ali
Mohammed Imran Ali
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 258
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.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1712 Visits: 8766
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
Mohammed Imran Ali
Mohammed Imran Ali
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 258
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 automaticallyUnsure
sharon-644450
sharon-644450
SSC-Enthusiastic
SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)SSC-Enthusiastic (110 reputation)

Group: General Forum Members
Points: 110 Visits: 761
you can cehck in your sql server log to find out why the backups failed. generally it turns to be an IOerror
subhashlg26
subhashlg26
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
JasonClark
JasonClark
SSC-Addicted
SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)

Group: General Forum Members
Points: 415 Visits: 810
The Backup job fails Error 3013 can be occur due to network traffic on the server. in such situation you need to change the Time. may it works.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search