September 27, 2007 at 6:10 am
Hi,
Can any one tell me, Step by Step procedure for Log Shipping in SQL 2K. I have tried Log shipping procedure (Written by Purna Gathani
Additional contributions by Richard Waymire, Arvind Krishnan, Rick Gutierrez
Published on May 24, 2001) several times and Log shipping happens in the source server only , not in the destination server.
Also briefly require mentioned below points
The user who configures Log Shipping must be a member of the
sysadmin server role to have permission to modify the
database to log ship.
T.Loganathan
September 28, 2007 at 2:55 am
I have used this white paper by Gathani and found it to be useful and informative. Following the process in this document worked for me.
Do you get an specific errors when configuring log shipping?
Have you setup the shared locations for the log files and given appropriate permissions to the user account that runs SQL Server Agent?
Gethyn Elliswww.gethynellis.com
September 28, 2007 at 3:07 am
Also, Are both your servers Enterprise edition of SQL Server 2000?
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply