Backup error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Backup error

Hi
i have created one Maintainence plan which do backup.
here is the Error …… [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on ‘D:program FilesMicrosoft SQL ServerMSSQLBACKUPcmsdbabc_db_200404210311.BAK’ failed, status = 112.
See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. And i have enough space on "D" drive,So What is this error. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
Ensure the SQLAgent account has required privileges on the D: drive to perform the operation.
Try to execute the plan manually with your login and check permissions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

See the SQL Server error log for more details.
Also, did you check the Windows Event Viewer logs (application, system, security) to see if there was anything else that might be causing the problem?

]]>