Restore Permissions for Log Shipping

• 
  I notice that the initial full restore that is done when the log shipping job is created works just fine because it is performed by the SA or whatever user I put in there initially but all the incremental restores after that were performed by the NT AUTHORITY\NETWORK SERVICE user. Why dose it change users and how do I give that user right to do restores to the destination DB?

  Nix July 06, 2011 15:32

  - 0 +
• 
  Does the owner of the SQL Server job that performs the restore have rights to restore transaction logs on that database? Could you please check, using SSMS, who is the owner of the job?
  
  Thanks.

  petey July 06, 2011 23:50

  - 0 +
• 
  It seems to be working now!!! I checked the job and the owner was the AD account that I created for this test but the NT AUTHORITY\NETWORK SERVICE user was still performing the incremental transaction restores. I thought I gave that users sysadmin rights but when I double checked it today I noticed I gave it setupadmin rights instead. After fixing that change things seem to start working. Is it normal to have to give NT AUTHORITY\NETWORK SERVICE user sysadmin rights to do log shipping or am I doing something wrong? I am new to SQL administration so I apologize if this is a dumb question.

  Nix July 07, 2011 08:38

  - 0 +
• 
  What is the account that is used to run the SQL Backup Agent service? You can check via using the Windows Service Manager application.

  petey July 07, 2011 09:01

  - 0 +
• 
  It was the one I created called SQLBackup.

  Nix July 07, 2011 09:03

  - 0 +
• 

  but the NT AUTHORITY\NETWORK SERVICE user was still performing the incremental transaction restores.

  How did you determine this?
  
  Thanks.

  petey July 07, 2011 09:05

  - 0 +
• 
  When I looked at the Activity History for that DB in SQL Backup it would show that user account as the user name that performed the task.

  Nix July 07, 2011 09:07

  - 0 +

Add comment

Please sign in to leave a comment.