log shipping failover

Hi Guys,
in sql server log shipping for fail overing to stand by
server if i need to restore transaction log recovered from
primary server. how i can do that?is it using script or
Enterprise manager?
what is the script used?
pls advice me.
Thanks
Biju
Biju,
the failover process is manual in hte case of log-shipping (as opposed to
clustering).
The main procedure to run is sp_change_secondary_role. This will get hold of
the last log if it can and recover the database.
After that you could consider peripheral data from the system catalog - eg
logins and messages but these should be already there if you have planned in
advance.
You can change DSN values to point your apps towards the new system or you
can alter the computername. If you do this you'll need to update the value
in sysservers (sp_dropserver 'xxx', sp_addserver 'yyy', 'local').
HTH,
Paul Ibison
|||Are you running the log shipping wizard that comes with SQL Server 2000 EE?
If not here is a guide to implementing log shipping.
http://www.sql-server-performance.co...g_shipping.asp
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"biju george" wrote:

> Hi Guys,
> in sql server log shipping for fail overing to stand by
> server if i need to restore transaction log recovered from
> primary server. how i can do that?is it using script or
> Enterprise manager?
> what is the script used?
> pls advice me.
> Thanks
> Biju
>