Comments
Sort by recent activity
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. / comments
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.
It was the one I created called SQLBackup. / comments
It was the one I created called SQLBackup.
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? / comments
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 incr...
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. / comments
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 transact...