Post reply

kind of Transaction log shipping

  • October 20, 2009 at 1:31 am

    #1067998

    Just restore the transaction logs "WITH STANDBY" instead of "WITH NORECOVERY" and you will be able to query the secondary database.

    Restores take longer using WITH STANDBY, as SQL Server has to roll back any uncomitted transactions. If you just want to check things out, pause your restore job, restore one log WITH STANDBY, query the secondary database for whatever you want, then re-enable the restore job.

  • October 20, 2009 at 5:45 am

    #1068102

    i am applying log backups with NO RECOVERY

    that WITH STANDBY is not going to break the following restorations???

    Thanks ,

    Shekhar

  • October 20, 2009 at 11:20 am

    #1068365

    Nope, putting the database into STANDBY won't break the log chain... you can switch between the 2 whenever you want.

  • October 20, 2009 at 11:25 am

    #1068368

    thank you very much quick clarification..

    I will try it out and post the update..:-)

    Thanks ,

    Shekhar

  • October 27, 2009 at 1:09 am

    #1071043

    Is there any way to know a perticular transaction log has been restored or not??????:crazy:

    Thanks ,

    Shekhar

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

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