Hi, Please can someone tell me what commands to issue or point me in the direction of some documentation of how to do a role change when the Primary server goes down or is not accessible to run the first command against. Any help much appreciated. Jamie.
Refer to the Books online under Log shipping --> Role changes topic which explains the theory. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx#EEAA - if you can't find the topic. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi Satya, Thanks very much for that. The document makes a few other things clearer too. Cheers Jamie.
Also review other articles list in this website, which are quite helpful. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
