SQL Clone
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
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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.
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3066 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
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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.
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3066 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
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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 (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)SSC-Enthusiastic (178 reputation)

Group: General Forum Members
Points: 178 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
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 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
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: 1722 Visits: 1027
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