2010年7月27日 下午 07:56
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 ?
2010年7月27日 下午 08:06
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'
- 已標示為解答 Aaron Han - MSFT 2010年8月7日 上午 02:40
2010年7月27日 下午 09:55Looks 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.
2010年9月6日 下午 01:21
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!
2010年10月14日 上午 08:38
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
2012年8月6日 下午 04:46I had this problem too and remedied it with backing up to a drive on the SQL Server, not the SharePoint Server.
Jonathan M Beck