Post reply

LOgshipping Role change

  • February 4, 2010 at 6:14 am

    #156644

    Hi,

    I am new to the sql server 2005 .Can i know how can we change the role if the primary databse is corrupted and crashed,and also how can we change the role from secondary to primary .

    Thanks in advance

    Kareem.

  • February 4, 2010 at 10:13 am

    #1113847

    Perform your final translog backup (if possible)

    Then manually copy the file over to the 2nd server.

    Then connect to secondary server in and run RESTORE LOG using the WITH RECOVERY option.

    If your primary DB isnt available run...

    Restore database DBName with Recovery

  • February 4, 2010 at 3:57 pm

    #1114062

    SQL_Lock is correct you need to restore to

    backup take the final transaction log backup, if that is possible.

    Copy the file over to the secondary server

    and restore it to the recovering database specifying with recovery to bring it on-line.

    You also need to reconfigure your application to point at the secondary server.

    Gethyn Elliswww.gethynellis.com

  • February 4, 2010 at 8:46 pm

    #1114159

    Correct..

    I agree.

    Take a point in time recovery or Tail Log backup for the possible recovery. Copy the last Trans Log file to the secondary server. Restore the final T-Log backup file with Recovery option on the Secondary database.

    To make the secondary LS Server up and running you also have to have Logins restored on the secondary server. It could be done by scripting the Logins on Primary and load on Secondary.

    We also have to check the application level and have to re-direct the application to connect the secondary server.

    Once the Primary server is up and running - you have to re-configure Log Shiiping once again.

    Hope this adds.....

    - Win.

    Cheers,
    - Win.

    " Have a great day "

  • February 6, 2010 at 6:46 am

    #1114990

    Thanks to all...........

    According the followed solutions, we need to reconfigure the log-shipping between Seconday to Primary.

    But it is tidious process....and I have to change all the applications to seconday and primary to seconday.

    Is there any way to configure the Log-shipping as it is...

    Thanks in advance,

    Karim:-)

Viewing 5 posts - 1 through 4 (of 4 total)

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