Backup job failed with Operating System error 3 | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Backup job failed with Operating System error 3Hi all, This is Chaitanya, new member on this forum.
I am maintaining a SQL server on which we have about 150 databases which we backup using a maintenance plan.
Since a week the plan is failing to backup two databases with the "Operating System error 3". Using "net helpmsg 3" command I found the explanation of the error which says "Path not found".
For me this is weird as all the databases are being backed up at same location and only two are failing with this error. All the other are backed up properly.
Please find the error log for the maintenance plan as below:
"Executing the query "BACKUP DATABASE [EM_WH_sragrawal ] TO DISK = N’F:…" failed with the following error: "Cannot open backup device ‘F:\\SQLSRV1_Backup\\EM_WH_sragrawal \\EM_WH_sragrawal _backup_2013_08_17_233006_5310280.bak‘. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
A close look at the bolded path in that error message shows a blank space character in two places, both occurring after the database name; ”EM_WH_sragrawal \\EM_WH_sragrawal _backup" . Since these backup paths are dynamically generated according your DB name, I suspect that your database name has a space character in it. A space character would cause problems when incorporated within file path syntax. You may need to rename the affected databases to remove any spacing characters or characters that could interfere with a OS file path syntax.
Welcome to Forums I do agree with Davidfarr , supporting that approach more,you can try to back it up to any proper backup file under the same backup path without spaces , if it still persist please try another path or you can check your ACL permissions for your SQL Services accounts on backup directories because I am sure it happened with me before , some paths are not inheriting the same ACL permissions assigned for SQL Services accounts on the entire of drive Please let me know if any more help is needed here