sharepoint 2010 Backup error !

Question

While the job was execting a backup I received it message !

Object SharePoint_Config failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup directory.

SqlException: Cannot open backup device 'C:\Backup\spbr0000\0000009D.bak'. Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.

would you please help me ?

---

BRUNO SOUZA

Answer 1

If you have a multi-server farm environment, try using an UNC path like \\servername\C$\Backup\spbr0000\0000009D.bak instead of 'C:\Backup\spbr0000\0000009D.bak'

Answer 2

Looks like a permission issue, try giving sql service account write/modify access to the backup folder.

---

Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 3

I have the same problem...

 

I'm running Sharepoint 2010 on two HyperV servers (for easy scaling in future). One for Sharepoint and one for MSSQL

 

Previously I did the backup on the SqlHyperV, but that HyperV ran out of diskspace.

 

Now I'm trying to do the backup on the SP HyperV, but keep getting this error.    The SQLServer is running as network service.

 

Any assistance will be apprectiated!

 

Answer 4

The SQL error comes from SQL Service not being able to access the backup folder. I also encountered this issue and this is how I solved it:

http://it-burns-when-i-sp.blogspot.com/2010/10/sharepoint-backups-getting-error.html

 

Solution:

So here is how to make it work:

SharePoint tries to backup the SP specific databases from your SQL server if it is not on the local machine.. well it tries to back it up wherever it is, just when it is on another machine you get a slight headache.

Make sure the backup folder has rights allowing your SQL server to access that folder.. hmmm.

So in my case I assigned my SP Domain Admin account to the share and hoped for the best.. but it still failed.. then I changed my SQL service account to my SP Domain Admin account and it worked.

SP Server----------------------------SQL Server Service---------------------\\BackupShare

domain\spadmin>>>>>>>>>domain\spadmin>>>>>>>>>>>>>domain\spadmin

I also added the domain account for the SQL Agent Service... just in case

I have a strong feeling that it is not best practice, but ____, at least it gives me some time to figure out what I am supposed to do.

Please let me know if this was helpful.

Adriaan

 

Answer 5

I had this problem too and remedied it with backing up to a drive on the SQL Server, not the SharePoint Server. 

---

Jonathan M Beck