Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

What kind of lock does SQL Server 2008 R2 acquires when doing DBCC SHRINKDATABASE?

What kind of lock does SQL Server 2008 R2 acquires when doing DBCC SHRINKDATABASE?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
1 Solution
 
dmarinenkoCommented:
Table Locking, the same as if Tablock was used.  By the way, shrinking a 2008 database is normally not recommended,
http://msdn.microsoft.com/en-us/library/ms188796.aspx

One reason it isn't recommended
http://www.mssqltips.com/sqlservertip/2055/issues-with-running-dbcc-shrinkfile-on-your-sql-server-data-files/
0
 
thomaszhwangAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now