manual failover steps 4r logshipping

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

manual failover steps 4r logshipping

Author

Topic

phani.m
Starting Member

2 Posts

Posted - 2010-07-28 : 06:36:25

HI..,
i have configured log shipping and then my primary server was crashed,i have to bring my secondary server online now.so wht r the steps to be followed in this case.
can anybody tel me?????

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 12:45:22

Use RESTORE LOG WITH RECOVERY to recover the secondary database. But first RESTORE LOG WITH NORECOVERY all of the transaction log backups that hadn't been applied to the secondary server first so that you've got less data loss.

Hopefully you kept your logins in sync between the two servers. If you need a script for that, here's what I use: http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources