Monday, July 13, 2020
Beetle Blog
Query status of shrinkdatabase
By: douglas - Sql Server - 11/26/2012 8:38:33 PM

DBCC shrinkdatabase( database_name ) can take a long time and it doesn't show progress if you run it via SSMS.  To view the percent complete use this query:

SELECT percent_complete, start_time, status, command, estimated_completion_time, cpu_time, total_elapsed_time FROM sys.dm_exec_requests where command = 'DbccFilesCompact'


Last Modified: 11/26/2012 8:38:33 PM

Beetle Blog v0.2.2

Copyright © 1997 - 2020 All rights reserved.