locked
How to perform full and differential backup in remote storage. RRS feed

  • Question

  • How do i perform full and differential backup in remote storage device. I am getting failure message like "SQL Server service account and the NT AUTHORITY\NETWORK SERVICE service account do not have permission to read or write to the backup folder." I have moved content database from internal database to MS SQL 2005, however Sharepoint_adminContent, sharepoint_confi and wss_search databases are still in internal database. WSS is running in one of the DCs and domain users have access to remote storage device.
    Sunday, February 13, 2011 1:59 PM

Answers

  • Hi Pauzan,

     

    you can try to login with this account and try to access your share \\server\sharefolder and check whether you have access or not.

    • Marked as answer by David HM Monday, February 28, 2011 2:12 AM
    Monday, February 14, 2011 10:51 AM

All replies

  • Hi,

     

    try to change the service account of the sql to domain user and give this user read write on the remote folder.

     

    you can also post your issue in sql forum to give you more help.

     

    Best Regards

    Mina Fouad

    Sunday, February 13, 2011 9:39 PM
  • Mina is correct. the Windows Internal DB by default is set to NT Auth\Network Service and you'll need to change that service account in the Windows Control Panel ->Administration -> Service to a domain account with dbo rights on the traget db. Make sure to restart the service when you make the change and try the change again.
    Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog
    Monday, February 14, 2011 5:51 AM
    Moderator
  • Thanks Mina and Kris,

    Both MS SQL 2005 and windows internal db services are running in domain user (domain\administrator). The user has full access in remote storage drive and dbo roles in all databases.. But still i am getting the same error "SQL Server service account and the NT AUTHORITY\NETWORK SERVICE service account do not have permission to read or write to the backup folder.".

    Thanks in advance.

     

    Monday, February 14, 2011 7:50 AM
  • Hi Pauzan,

     

    you can try to login with this account and try to access your share \\server\sharefolder and check whether you have access or not.

    • Marked as answer by David HM Monday, February 28, 2011 2:12 AM
    Monday, February 14, 2011 10:51 AM
  • Yes, the account has full access in shared folder. I can perform copy, paste and delete in the shared folder with this account.

    I think the problem is with NT AUTHORITY\NETWORK SERVICE account. I wonder why this account is used for backup.

    Monday, February 14, 2011 11:02 AM