SQL Server Performance Forum – Threads Archive

restoring log backup

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

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.

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.

… 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.

]]>