Log Shipping
I'm fairly certain that this posting should not be in replication, but here goes. I'm not a SQL expert, and I know just enough to keep things running. I'm looking to add some recovery options on top of my current backup to tape rotation for 2 core SQL servers. I setup log shipping and that appears to be working without an issue. I left it in standby mode instead of recovery and I also did a run through on switching the server where the primary db resides. That worked great and on the secondary data was up to date and all looked great.
Now I would like to test this process by taking my primary (test)SQL server down and force the secondary server to have the db available for read/write. Can anyone explain to me the best practies for performing the role change in this scenario?
SQL Server 2000 Enterprise running on Windows 2000 Server
Regards and thanks in advance,
Sean
