Activity overview
Latest activity by Nix
Replicating User Accounts
Is it possible to the replicate SQL user accounts and settings to another server when using log shipping to replicate the databases and logs. I notice when I stop replication and try to bring up th...
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.
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...
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...
Restore Permissions for Log Shipping
When the backup job for log shipping runs on the source DB, I seem to have no issues. But when the restore runs on the backup DB, I get error error 890. I setup a new user in AD and gave them sysad...