September 7, 2006 at 3:40 pm
Hello,
We were wondering if the new 2005 Sql Server version will allow users to be attached to a database while database maintenance routines are executing ?
Currently, with the 2000 version, certain maintenance activities (index rebuilds, optimizations, etc) require exclusive access to a given database while the jobs execute.
We heard with the new version (2005) that users can be concurrently attached while these maintenance jobs execute.
Can someone please confirm this for me or where I may find more information pertaining to this ?
Thanks in advance.
Don
September 8, 2006 at 3:28 pm
With Enterprise Edition you can do online index rebuilds and other maintenance without locking up tables. This relies on snapshot isolation, and will eat a lot of tempdb space.
It's a great feature, but it doesn't come cheap.
September 8, 2006 at 3:47 pm
Scott,
Dude, thanks for the informative response. I was checking the Microsoft site and could not find the answer in the online product documentation.
Hope you have a great weekend !
Don
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply