hi,
i am playing around with simple log shipper that comes with the resource kit cd of ms sql 2000. i have set up the primary and secondary server. transaction logs are being restored remotely to the secondary server and everything is cool.
will i just continue to backup the tran log from the primary server and restore it to the secondary server. is that all it has to do in log shipping? in the event that the primary server goes down all i have to do to make the secondary server working is to run a restore comman with recovery option on the last tran log that i have right?
i havent done any of this before and i'm not really a dba. its just that i have been given this task and i really dont mind it coz its something new that i can learn.
would appreciate any thoughts/ideas on this.
regards.
ann