Shrinking Log file but is showing that it is being blocked by SPID 13 which is CHECKPOINT on the same database.

• supriyakaushik6

  Newbie

  Points: 9

  More actions

  August 1, 2011 at 3:36 am

  #242361

  Hi,

  Today i got an alert of ddisk space.When i tried to shrink the file by DBCC SHRINKFILE() it has shown that it is being locked by SPID 13 Process which shows that CHECKPOINT is running on the same database.

  Please tell me what is this.Why it happens and what to do in this case.

  Regards!!

  🙂

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 1, 2011 at 5:27 am

  #1361447

  Buy more disk

  Extend the current disk on your san

  Delete useless files or data (which is almost never the DB).

  What files were you trying to shrink?

  Do you take regular tlog backups on all your bulk-logged and full dbs?