Error in Backup Database “SqlException: Cannot open backup device.. Operating system error 3(The system cannot find the path specified.)”
12/23/2011 • Admin
Category: SharePoint 2010, SharePoint Programming
I got this error the other day while backing up some of the databases. The detailed error was
“Error: Object dbName failed in event OnBackup. For more information, see the error log
located in the backup directory.
SqlException: Cannot open backup device ‘Folder\folder\folder.bak’. Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally……Deleting the file “somethin.xml” and replacing it.”
The command i used was -
stsadm.exe -o backup -directory “C:\SPBackup” -backupmethod full -overwrite -item databasename
The issue here is that the directory path I used “C:\SPBackup” it should be a <UNC path or local drive> .. ya i know that was the mistake .. you found it!
But wait there is more …
Since you need the UNC path to your backup drive you need to Share your folder where your want to keep your backups. Also while sharing add the SQLService account as Co-owner to the shared folder.
These steps would solve your issue. Happy SharePointing!



Recent Forum Posts
Linq to Sharepointby RS on May 18, 2012
comments on the codeby spbsmile on May 18, 2012
connection(add) EditControlBlock and my programby spbsmile on May 18, 2012
Custom master pages used in multiple SharePoint 2010 sitesby ubersteve on May 18, 2012
upload file and click on button but cant upload file into list by using below codeby santhoshreddy on May 18, 2012