SQL Server Performance Forum – Threads Archive
copy lo g failedif the SQL agent is started by local system a/c on primary server and the agent on secondary server is started by domain admin, will it affect the log copying ? It is failed to copy log from primary to secondary server
Yes,it will affect the copy process,For log shipping you should run the both server in same SQL Server Service account. Thanks,
MS SQL Server DBA
Primary server will not be able to copy or even see the share on the network, as the associated privileges are not allowed using local system account.
http://sqlserver-qa.net/blogs/tools…r-domain-account-for-sql-server-services.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.