SQL Server Performance

copy lo g failed

Discussion in 'SQL Server Log Shipping' started by feann, Apr 12, 2005.

  1. feann New Member

    if 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
  2. prabhabk New Member

    Yes,it will affect the copy process,For log shipping you should run the both server in same SQL Server Service account.

    Thanks,
    Prabhakaran
    MS SQL Server DBA
  3. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.

Share This Page