Backup/Restore Shared Services Provider on SharePoint MOSS

Question

Hi,

I'm having serious issues with backing up and restoring a shared services provider.

Using the Central Administration backup I run the backup to s:\

This completes fine.

I then from another SharePoint Server choose to restore a backup and point it to the UNC path \machineipaddress\s$\spbr00DF

I have given everyone full access to s:\ on the source server.

All I get back from SharePoint is this:

Directory \machineipaddress\s$\spbr00DF does not exist or the SQL Server service account and the BI_WEB\Administrator service account do not have permission to read or write to the backup folder. Specify a different directory.

Would appreciate anyones thoughts on this.

reference: http://technet.microsoft.com/en-us/library/cc896556.aspx

All the best

Answer 1

I have exactly the same problem except I'm just trying to do a simple backup of Sharepoint to an unprotected destination folder. The error is bogus. I know for sure the dir exists and any unprivileged process can write to it.

To quote someone on another forum, "I love Sharepoint, but sometimes I want to punch it in the face".

Answer 2

What happens when you specify \\machineipaddress\s$ as the folder for the restore?

Answer 3

I had a similar problem and the issue stemmed from SharePoint using the specified system account to do the restore, even though it says that either the system account or the current user must have access.

We moved SharePoint to a totally new environment recently, and I was so fed up with the included backup/restore system that I ended up just backing up the relevant databases, creating new web applications in the new environment, and attaching the databases to them. You can remove content databases from sites through Central Admin, but you'll need to use stsadm to reattach. This worked flawlessly for me, and may suit your needs.

Answer 4

dear orthod0ks that is exactly the approachI'd like to take - can you give me a simple set of steps to follow

I have the db backed-up (using sql tools) - now I am trying to restore - but am not sure how - since all the sharepoint docs expect you to use their gui -which gives me the dreaded error:

Directory \sqlservername\Backup\Portal_Content_03022009.bak does not exist or the SQL Server service account and the daomain\uname service account do not have permission to read or write to the backup folder. Specify a different directory.

my backup file is on the sql box - and I made a share to the sql backup directory - so I could use a UNC -- maybe I should try copying the .bak file over to the sp box?

I am not even sure the sql backup file will work though...

I remeber seeing a post once on how to detach the old db and reattach the new one - but would really like to have some steps to follow (from an sp point of view) - has anyone seen an article like that?

Answer 5

Hey I'm new here but just wanted to add my two cents.

I was having the same issue and found one of the above users was correct, the error was generated because a system account did not have access to the share.

On our server we got the same error. When we created our Sharepoint sites we selected the Network Service account to run the site. I went to the share and added the Network Service account with Full Control and now the restore works.

Hope this helps someone.