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.
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.