Backup job fails with Error 3013

Question

Post reply

Backup job fails with Error 3013

Mohammed Imran Ali

SSCrazy

Points: 2125
More actions
August 12, 2008 at 8:15 am

#126925

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.
March 21, 2016 at 1:43 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

Are you able to take the database backup to the specified location

using enterprise manager manually?

Manu

Mohammed Imran Ali SSCrazy Points: 2125 More actions · Answer 2

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. SSC-Dedicated Points: 31126 More actions · Answer 3

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 SSCrazy Points: 2125 More actions · Answer 4

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:unsure:

sharon-644450 Default port Points: 1442 More actions · Answer 5

you can cehck in your sql server log to find out why the backups failed. generally it turns to be an IOerror

subhashlg26 SSC Veteran Points: 217 More actions · Answer 6

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.