SQL Server Performance

restoring log backup

Discussion in 'SQL Server Log Shipping' started by ravilobo, Oct 19, 2004.

  1. ravilobo New Member

    I have setup log shipping, but my restoring job at the secondary server is not working. If i try restore the logs manually , it works fine.

    Any help is greatly appreciated.
    Thank you.

    I think, therefore I am
  2. satya Moderator

    What was the error when trying to restore using log shipping?
    Ensure the SQL Services account used on secondary server has require privileges to restore log.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. ykchakri New Member

    Also, make sure that the secondary server can access log files on the primary server. I'd prefer to run SQL services on both machines to run under the same NT account.
  4. satya Moderator

    ... or if not different NT accounts with name & password and privileges.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page