So I tried to use the backup function in Sharepoint Server 2010 (Standard) and it looked pretty straight forward.
Just go to “Central Administration > Backup and Restore”
choose full Farm backup and add the path where to backup, \\SERVERNAME\BACKUPSHARE, and press the backup button.
Wait a minute or two for the preprocessing..
First error:
“This page contains one or more errors. Fix the following before continuing:
Directory\\SERVERNAME\BACKUPSHARE does not exist or the SQL Server service account and the DOMAINNAME\LOGGED-IN-USER service account do not have permission to read or write to the backup folder. Specify a different directory or ensure that the SharePoint Timer service and Microsoft SQL Server service accounts have Full Control permission on both the file share and the underlying folder.”
So the error is because of the wrong security settings in the backup share folder
The soulution is to add the “Sharepoint Service” and “Sharepoint User” accounts to the BACKUPSHARE and give it “modify” rights.
And the backup will proceed
Wait for backup to finish..
Second error:
(not all of the backups (one for each sharepoint “function/setting”) fails, but some do with the following error)
SqlException: Cannot open backup device ‘\\SERVERNAME\BACKUPSHARE\spbr0000\000000C7.bak’. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
The Solution for this error is to give the SQL Server Engine Service account “modify” rights in the BACKUPSHARE
Now the backup will proceed without any further errors.. well.. at least in my case it did 🙂
I have a small installation on an MSSQL Server Express database (soon to be migrated into a new Active Directory Site and proper MSSQL Server 2008 R2) at the moment and this full backup took about 27minutes
Conclusion
In short, the following accounts need modify rights in the backup share folder
- Sharepoint Service account
- Sharepoint User account
- Your Admin account (farm owner)
- SQL Database Engine Service account (running the SQL Server where Sharepoint is installed)
Thanks to Adriaan Sullivan for his post http://it-burns-when-i-sp.blogspot.se/2010/10/sharepoint-backups-getting-error.html And to Tibor Karaszi, SQL Server MVP and the other guys providing the answer at http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/021c7aa5-4a8a-4bbb-8ff0-fe6b03920aae/