Find Estimate Time of recovery for database after Reboot

,

This Script will  read Estimated Time for recovery from Error Log

DECLARE @DBName VARCHAR(64) = 'DatabaseName'DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))INSERT INTO @ErrorLogEXEC master..sp_readerrorlog 0, 1, 'Recovery of database', @DBNameSELECT 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

Rate

1 (1)

Share

Share

Rate

1 (1)