April 29, 2008 at 9:33 am
Hi guys
when we do manual Database shrink at normal office hours does it make any issues
or best way to control it
1. Does it lock database and runs the shrink statement.
2. at time of shrink users allowed or not.
3. transactions can be committed.
April 29, 2008 at 9:56 am
Here are my inputs.
1. Does it lock database and runs the shrink statement.
Answer: It does not lock the database, but may lock a table in shrinking a database.
2. at time of shrink users allowed or not.
Answer: Users can access the database.
3. transactions can be committed.
Answer: Yes.
But we must be careful in running shrinking database at peak hours. CPU usage is normally pretty high. If a table size is huge, the locking time will be pretty long.
April 29, 2008 at 11:17 am
tHANKS IT ANSWERS MY QUASTION
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply