Post reply

Isolation Level

  • March 11, 2013 at 8:59 am

    #394353

    Hello there,

    I have a db on a standby mode that is restoring from a primary one every 15 minutes. usres are logging on to the stand by db to select information using the nolock hint but the Db still locks and preventing from restoring after.

    What do you think i should do ? Should i change the isolation level to snapshot? Will that help?

    Thank you in advance.

    Riri

  • March 11, 2013 at 9:13 am

    #1595614

    No isolation level will help there. To restore the process needs an exclusive database lock, that means all users out. You can set log shipping to automatically disconnect everyone or wait afaik.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 11, 2013 at 9:27 am

    #1595624

    Thank you very much will disconnect the users before i restore. Thanks once again

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

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