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 ?
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!
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: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---------------------\\BackupSharedomain\spadmin>>>>>>>>>domain\spadmin>>>>>>>>>>>>>domain\spadmin
I also added the domain account for the SQL Agent Service... just in caseI 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
- 已提議為解答 Adrian Sullivan 2010年10月14日 上午 08:38