I need help in setting up log shipping in sql 2005. Acutally, I know how to set it up, just that I kept getting error when I set the secondary server as standby mode. When setting up in standby mode, it tries to write the .tuf file in c:\windows\system32 when the SQL agent account will not have access to and should not have access to. Right now, I can only setup log shipping in non-recovery mode on the secondary. Any Idea. The link below provide the exact same problem, however no solution.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setup log shipping on sql 2005 to sql 2005 with standby mode
- Thread starter mdwu
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
