Log Shipping Failover / Failback Question

Hello all,

I'm about to setup Log Shipping in our SQL Server 2000 environment. I will have the primary server, one standby server, and the witness server in this setup. I understand the process of failover and the stored procedures needed to make this happen, but my main question is about failback. Once the standby server has assumed the primary role, will log shipping be automatically configured to start flowing from the new primary server to the old primary server, or will I have to go back and setup log shipping from the new primary server to the old primary server?

Thanks for any help or insight you can provide on this subject!

Eric

After some setup, you can swap roles fairly easily.

BooksOnline has a good section describing this setup:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm

|||

Thanks for the link Kevin! Since this is for SQL Server 2005, does the same hold true for SQL Server 2000? That's the environment that I will be working in.

Eric

|||

I'm sorry. Unfortunately, log shipping changed significantly between SQL 2000 & 2005.

I'm looking for someone who can walk me through the SQL 2000 scenario. There was a wizard that assisted with much of it in Enterprise Edition. Which edition are you running?

|||

I'm also running Enterprise Edition .. specifically 8.00.2187

Eric

|||

You can find a description of doing this in SQL 2000 in the SQL 2000 BooksOnline under

Log Shipping ->role changes

|||

Thanks Kevin! That answers my question.

Eric