March 11, 2013 at 8:59 am
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
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
March 11, 2013 at 9:27 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy