Post reply

How To Brig OUT Database from STANDBY MODE

  • May 6, 2005 at 3:17 am

    #166904

    Hi

     

    I Implimented Logshipping, Original Datbase is LIVE DB,destination DB in STANDBY MODE

    in any case if my main database fails how can bring out STANDBY DB in to LIVE DB

     

    in same issue i have one more dout that is

     

    if suppose Logshipping schedule is running smoothly..if any case network fails for a while...

    after restoring network connection what is the position of DB 

  • May 6, 2005 at 9:00 am

    #557379

    You should make sure to apply all the logs before bringing the log shipped copy of the database live, to make it live is

    RESTORE DATABASE DBNAME WITH RECOVERY

     

    As for logshipping network problems, your main server will still dump the transaction logs to local disk (presuming that's where they are set to), once network connectivity is restored the log shipping server will copy them accross and apply them as usual.


    Shamless self promotion - read my blog http://sirsql.net

  • May 10, 2005 at 11:44 pm

    #557935

    Thanks

    Nicholas Cain,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply