With each step that has to do with a database I get this error (differing bak file names): [5/15/2012 6:53:08 PM] Warning: [my_SharePoint_Config] Cannot open backup device '\\FILESERVERNAME\SP15Backup\spbr0000\00000125.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally. This was run from the 2010 Central Admin where I was logged in as the Farm account. Notice the failure on file 0125. Obviously there was no privilege problem for the first 0x124 files. Any idea what gives?

Hi mardukes, Please ensure that the following are given the Full Control file share and NTFS permissions for the backup shared folder: The account used by the SQL Server service account. The Windows SharePoint Services Timer V4 (SPTimerV4) account. The logged on account, if you are using Windows PowerShell to perform the backup or restore. If the backup folder is a network share, ensure that all accounts that are listed above have access to both the share and the folder itself. If you are performing a backup or restore operation between two SharePoint farms, services on both farms must have the permissions described above. You can refer to the following link. http://blog.bugrapostaci.com/2011/06/17/sharepoint-2010-backup-folder-configuration/ Thanks, Jack

I'm going to try it again, but I believe I ran it under the Farm Account. That account has full access to the target folder. That account is the login account for the SharePoint 2010 Timer service. That account is DBO of the main content database. Would you agree that I've met your requirements?

Hi mardukes, Are you sure you have the right of \\FILESERVERNAME\SP15Backup\spbr0000\'. Your error is cant open. So, youd better use a local path replace UNC path. Thanks, Jack

Hi, To start central admin right click and select run as administrator and then carry out your operation again. I hope this will help you out.Thanks, Rahul Rashu

Hi mardukes, Are you sure you have the right of \\FILESERVERNAME\SP15Backup\spbr0000\'. Your error is cant open. So, youd better use a local path replace UNC path. Thanks, Jack I think I did mention that it was fine for the first 0x124th files. And the target drive is not local.

Hi markdukes, Yes, your 0x124th file is ok, but your 0x125 is return the error. So, according the current case, it is difficult to fixed the where is the problem. So, I suggest you to use STSADM backup your file. Start->run->,input cmd .Input cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BINInput stsadm -o backup -url http://jack-7716f30e37:2012/personal/Test/ -filename test.bak You can refer to the following link. http://technet.microsoft.com/en-us/library/cc263441(v=office.12).aspx Thanks, Jack

Your original question was, I believe, whether or not I had access. My point was that the other 592 files that arrived answer that question as YES. All the errors I looked at seem to be associated with SQL queries and say access denied. I'm not using stsadm or PowerShell; I'm using the central admin gui. I want to know why it's not working.

Hi mardukes, This is permission problem i said you first. So, first, your farm account is a domain account, please ensure the domain account is in your SQL database, and the permission is enough. Then please ensure your domain account have enough permission to your backup folder. SharePoint tries to backup the SP specific databases from your SQL server if it is not on the local machine.Make sure the backup folder has rights allowing your SQL server to access that folder. Plese refer to the following. SP Server----------------------------SQL Server Service(&SQL Agent Service)---------------------\\BackupShare domain\spadmin-------------------------------domain\spadmin---------------------------------------domain\spadmin After my search, you can refer to the following link. http://it-burns-when-i-sp.blogspot.com/2010/10/sharepoint-backups-getting-error.html http://www.sharepointalex.co.uk/index.php/tag/backup/ Thanks, Jack

Hi mardukes, This is permission problem i said you first. So, first, your farm account is a domain account, please ensure the domain account is in your SQL database, and the permission is enough. Then please ensure your domain account have enough permission to your backup folder. SharePoint tries to backup the SP specific databases from your SQL server if it is not on the local machine.Make sure the backup folder has rights allowing your SQL server to access that folder. Plese refer to the following. SP Server----------------------------SQL Server Service(&SQL Agent Service)---------------------\\BackupShare domain\spadmin-------------------------------domain\spadmin---------------------------------------domain\spadmin After my search, you can refer to the following link. http://it-burns-when-i-sp.blogspot.com/2010/10/sharepoint-backups-getting-error.html http://www.sharepointalex.co.uk/index.php/tag/backup/ Thanks, Jack

I got Microsoft to figure it out and here's what solved the problem. Sharing the folder with the dbo is not enough. We went and looked at the services running on the SQL Server server. We looked at the accounts running each of the SQL services having to do with the SharePoint instance. One had NETWORK SERVICE; one had LOCAL SERVICE and the rest had another domain service account created for the SQL Server server. We added those 3 accounts to Advanced Sharing permission and security full access for the destination folder. As far as I know this is not documented and all MS could offer me was case documentation where the problem was solved previously. It is possible that not all of these accounts are necessary -- perhaps I will experiment.