Apr 28 2010
The Shrink Operation Is Blocked
Recently I was shrinking temp DB database files, generally it wont take much time shrink the database however this time it was taking a long time. When checked the SQL server logs found below message. DBCC SHRINKFILE for file <ID> is waiting for the snapshot transaction with timestamp <number>and other snapshot transactions linked to timestamp [...]
Loading ...
