Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DBName VARCHAR(64) = 'Pricing'
- 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
- INSERT INTO @ErrorLog
- EXEC master..sp_readerrorlog 0, 1, 'Recovery completed', @DBName
- SELECT TOP 1
- @DBName AS [DBName]
- ,[LogDate]
- ,CASE
- WHEN SUBSTRING([TEXT],10,1) = 'c'
- THEN '100%'
- ELSE SUBSTRING([TEXT], CHARINDEX(') is ', [TEXT]) + 4,CHARINDEX(' complete (', [TEXT]) - CHARINDEX(') is ', [TEXT]) - 4)
- END AS PercentComplete
- ,CASE
- WHEN SUBSTRING([TEXT],10,1) = 'c'
- THEN 0
- ELSE CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0
- END AS MinutesRemaining
- ,CASE
- WHEN SUBSTRING([TEXT],10,1) = 'c'
- THEN 0
- ELSE CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0/60.0
- END AS HoursRemaining
- ,[TEXT]
- FROM @ErrorLog ORDER BY CAST([LogDate] as datetime) DESC, [MinutesRemaining]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement