Post reply

kind of Transaction log shipping

  • October 19, 2009 at 9:49 pm

    #138780

    Hi all

    I have 2 sql server 2000 servers at 2 different remote locations acting as primary and backup servers. I have a scheduled script which backups the transaction log of primary server and restores at backup server. This process is going good.

    Now my question is, the database at backup server in LOADING state (which is required for restoring transaction log backups), so I cannot do any kind of querying on this database. Is there any way to check whether db is up to date and all tables are in sync with primarydb (like we have snapshot concept in SQL SERVER 2005).

    Thanx in advance..

    Thanks ,

    Shekhar

  • 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 6 posts - 1 through 5 (of 5 total)

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