[MSSQL] 복구상태일때 퍼센트와 남는 시간 확인하는 방법

MSSQL 쿼리를 통해서 확인

DECLARE @DBName VARCHAR(64) = 'DB명'
DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))
  
INSERT INTO @ErrorLog
EXEC master..sp_readerrorlog 0, 1, 'Recovery of database', @DBName
  
SELECT TOP 5
     [LogDate]
    ,SUBSTRING([TEXT], CHARINDEX(') is ', [TEXT]) + 4,CHARINDEX(' complete (', [TEXT]) - CHARINDEX(') is ', [TEXT]) - 4) AS PercentComplete
    ,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0 AS MinutesRemaining
    ,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0/60.0 AS HoursRemaining
    ,[TEXT]
  
FROM @ErrorLog ORDER BY [LogDate] DESC

 

쿼리 실행 시 결과값

11 30 2021  7:59PM        96% 6.4 0.106666666666667 Recovery of database 'DB명' (12) is 96% complete (approximately 384 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
11 30 2021  7:58PM        95% 8.35 0.139166666666667 Recovery of database 'DB명' (12) is 95% complete (approximately 501 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.