Tag Archives: ms sql

Get progress of ‘Shrink Database’ task on a Microsoft SQL Server

This posting is ~3 years years old. You should keep this in mind. IT is a short living business. This information might be outdated.

Shrinking a big database on a Microsoft SQL Server can take some time. And it’s one of those tasks, where you wont get a status until it’s finished. I really hate this… But this small T-SQL query can help:

Simply open a new query windows, paste the query into the query windows and execute the query. The query outputs the progress in percent and the estimated completion time.