SQL Server 查看收縮進度，備份進度

--查詢當前數據庫備份進度
SELECT
	DB_NAME(er.[database_id]) [DatabaseName],
	er.[command] AS [CommandType],er.[percent_complete],
	er.start_time,CONVERT(DECIMAL(5, 2),
	er.[percent_complete]) AS [Complete_Percent],
	CONVERT(DECIMAL(38, 2),
	er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m],
	CONVERT(DECIMAL(38, 2),
	er.[estimated_completion_time] / 60000.00) AS [EstimatedCompletionTime_m]  
FROM
	sys.dm_exec_requests AS er  
WHERE
	er.[command] in ('RESTORE DATABASE', 'BACKUP DATABASE');
 
 
--查看數據庫收縮進度
SELECT
	DB_NAME(er.[database_id]) [DatabaseName],
	er.[command] AS [CommandType],
	er.[percent_complete],
	er.start_time,CONVERT(DECIMAL(5, 2),
	er.[percent_complete]) AS [Complete_Percent],
	CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m],
	CONVERT(DECIMAL(38, 2), er.[estimated_completion_time] / 60000.00) AS [EstimatedCompletionTime_m] 
FROM
	sys.dm_exec_requests as er 
WHERE
	command in ('DbccFilesCompact', 'AUTOSHRINK', 'SHRINKDATABASE');