SharePoint backups getting error
So I go into Central Admin > Backup and Restore > Perform a backup…
And I see some errors…
More precisely:
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 ‘\\<Server>\Backup\spbr000200000AD.bak’. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
Hmm.. what I have done is to update the folder permissions on the local share to allow all the service accounts I could find linked to SharePoint.. I hope it works and will update on the results.
<45 minutes go by…>
Didn’t work.. will look for another solution.
Update:
Guess what I got this morning…
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
But wait.. there’s more… I no longer get that message and my backup folder is growing past 20MB
So what is the magic trick.. well none really.. it is just a simple rights issue.. Imagine, getting user account issues with SharePoint … pffff… never.
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 hell, at least it gives me some time to figure out what I am supposed to do.
Adriaan Edit: I found this thread after some more Googling, very helpful as well
Adrian