Post reply

Testing Log Shipping for Disaster Recovery

  • March 17, 2005 at 5:24 pm

    #85641

    I'm implementing SQL 2000 Enterprise Edition Log Shipping on multiple databases for my company's Disaster Recovery initiative and have a delimna.  I want to be able to (on a whim) stop Log Shipping, put the Secondary/Standby Database in multi-user mode so I can perform writes to it, and then re-establish Log Shipping without going through the hassle of the "Changing the Roles" procedures Microsoft provides with Log Shipping.  Has anybody accomplished this?  Sorry if this is a routine question I'm somewhat new to setting up Log Shipping.  Thanks.

  • March 21, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • March 21, 2005 at 11:16 pm

    #548118

    You cannot have a write mode of a Secondary Server in Log Shipping. You can either have a read only mode or standby mode for Secondary server.

    If you need to put the secondary server in the write mode, then you need to restore the database with recovery. This breaks the log shipping chain between the Primary and Secondary servers. You need to re-establish the log shipping if you have recovered the database on the secondary server fully.

    If you could describe your scenario, I would be able to provide a alternate solution.

    --Kishore.

     

  • March 22, 2005 at 7:03 am

    #548175

    Hi there, I think you're getting a little confused as to what log shipping is actually used for, namely keeping a second standby copy of the database in case something goes wrong with the primary one.

    If you want to write information to the database then you would have to do it at the source end.  You can stop log shipping and recover the standby database, making it fully usable; but then you would have to initialise the log shipping process again from scratch.

    Maybe something like merge replication will be better suited to your needs, but then again you'll have all of the pitfalls associated with that technology to work around

  • March 1, 2006 at 8:44 am

    #624013

    Hi everybody,

    We have a DR site about 1000km away from our primary site, so full backups of the databases can' be shipped on WAN (size @ 13gb). Hence I want to take backup on standby server. We have configured log shipping. Is it possible to stop log shipping for some time, open standby database in normal mode, take a backup, again make it standby & start log shipping. Please advice on the situation.

  • March 1, 2006 at 9:16 am

    #624029

    Abhijeet,

    Please do not 'hijack' other people's posts.

    Proper practice:

    1. start your own thread.

    2. do not 'hijack' other threads.

    3. pay attention to when a thread was started...some you have posted to were over 2 years old.

    4. don't post the same question multiple times.

    -SQLBill

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

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