As we have SQL Server 2005 and 2008 R2 Production server and using Log Shipping Method. Currently my 4-5 database have to huge and running continuously for reading and writing and they have StandBy method for log shipping and other are having Restoring Mode [No Recovery Mode] and also we have log shipping on every 30 minutes. Please let me know what method is the best method to up secondary server during the failure of Primary Server.
>>This will totally depends on the the issue you got on the primary server (either the Primary server is unaavilable or Primary database is no longer fucitioning due to some reaosn)
or any DR purpose you wish to perform.
And also we need to change the StandBy log shipping Method to No Recovery Mode for all 4-5 database.
>>In order to change the recovery mode from one to one –it is simlar to like reconfiure of logshipping(because in logshipping you have two types of restore mode 1.Standby/readonly 2.Restoring mode(No recovery mode).
Please let me know what willbe happen if we will change the log shipping method during not transaction log backup time-
1.trn- 9.00 PM
2.trn 9.30 PM
If we try to chnage the log shhipping method @ 9.15 PM what will be happen on secondary server- is there any log shipiing will be missed place or our log shipping will be stop. or any other issue will comes after change teh log shipping method ?
>>Can you please elaborate you mean you are going to change the time frequency or you are asking during the change mode of logshipping.
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) —————————————- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.