I am trying to shrink a database, but I keep getting an error cannot use the PAGE granularity hint on the table dbo.subreport because locking at the specified Granularity is inhibited. Can someone tell me how to fix this?
Nov 22 '09 at 12:19 PM
Nov 23 '09 at 05:48 AM
Your getting the PAGE hint error when you shrink the database? Can you provide the exact error (copy and pasted) that you get back?
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Nov 22 '09 at 12:19 PM
Seen: 1316 times
Last Updated: Nov 23 '09 at 05:48 AM
Shrinking is not completing in SQL Server
Creating file groups and reclaiming empty space
DBCC SHRINKFILE Error
SQL Server 2005 Locking Escalation Problem?
what is sql server locks and how to audit them?
How should I avoid this deadlock?
Please advise on why this deadlock and slowness problem happens?
SQLCMD Script Is Locking Detached Database Files Objects
DBCC ShrinkFile - better to do lots of little shrinks, or one big shrink?
Shrink file suspended for hours
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.