Post reply

Log Shipping

  • April 23, 2008 at 7:08 am

    #128918

    Hi,

    Could someone please help me to sort out following issue:-

    I have set up primary and secondary server for log shiopping. Now how to restore database in secondary server. Do I need to write RESTORE command for all trn files (I have set up log shipping for 15 min and after 2 days I have around 100 of trn files ) or do we have any other method to restore databse in secondary server.

    Thanks!

  • April 23, 2008 at 7:36 am

    #806046

    I take it you are using the native logshipping in 2005.

    The wizzard should have allowed you take a backup the database and copy to the secondary server.

    I also assume everything else is place i.e. the retore job has been created and scheduled to run.

    If everything else is in place and just the db is missing you should be able to take a backup of the database.

    copy to the secondary server

    restore leaving the database leaving in a non opertional state - this will allow logs to be applied via restore.

    Hope this helps

    Gethyn Elliswww.gethynellis.com

  • April 23, 2008 at 7:56 am

    #806065

    Thanks ! As what you said was correct.. Log shipping wizard has been set up for coping and restoring and in secondary server My database is in Recovery mode in front of this... Now I just want this database for read and write ...

    As what I understood taht as we have option of restoring in wizard ..it will restore all log automatically so I don't need to restore all trn files with RESTORE command but thing is that my database is in secondary server is in recovery mode (as I haven't chossen stand by mode in log shipping wizard)

    Thanks!

  • April 23, 2008 at 8:25 am

    #806085

    If you want the database for read and write...i.e break th log shipping and your happy that the database is uptodate and correct then you can restore the database with recovery thus bring the database online for read and write.

    Beaware that Logshipping won't work anymore and if you will need to reconfigure to get it working again.

    It is not possible to write to a logshipped database but it is possible to read from it as long as the database is in read-only mode.

    Gethyn Elliswww.gethynellis.com

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

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