Timeline for Why does database recovery take so long?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 20, 2016 at 9:48 | history | edited | Shanky | CC BY-SA 3.0 |
added 608 characters in body
|
| Jan 20, 2016 at 9:36 | history | edited | Shanky | CC BY-SA 3.0 |
added 693 characters in body
|
| Jan 20, 2016 at 9:22 | vote | accept | dwjv | ||
| Jan 20, 2016 at 9:19 | comment | added | dwjv |
Thanks for the update, I think you're right, although I think the ERRORLOG of 77% complete is more accurate. One other thing, the rollback session (35) is itself blocking another system process from performing CHECKPOINT - I'm guessing that won't cause an issue? You've answered my initial "why is it taking so long" question anyway. Edit - 2012 x64 Standard SP2
|
|
| Jan 20, 2016 at 9:18 | comment | added | Shanky |
Out of curiosity do you have enterprise or standard editionor any other edition. What is outpupt of select @@Version
|
|
| Jan 20, 2016 at 9:16 | history | edited | Shanky | CC BY-SA 3.0 |
ADDED MORE INFORMATION
|
| Jan 20, 2016 at 9:14 | comment | added | dwjv |
Definitely not blocked. select blocking_session_id from sys.dm_exec_requests where session_id=35 returns 0
|
|
| Jan 20, 2016 at 9:09 | history | edited | Shanky | CC BY-SA 3.0 |
edited query
|
| Jan 20, 2016 at 9:08 | comment | added | dwjv | No rows. Updated question with error log as requested. | |
| Jan 20, 2016 at 9:01 | comment | added | Shanky |
Can you run sp_readerrorlog command and look into the logs specific to your database. Please add that into the question. The logs would help me in giving you better response.
|
|
| Jan 20, 2016 at 8:10 | comment | added | dwjv |
Many thanks for the response, I don't suppose it makes any difference but the transaction is not rolling back, the database is recovering (I realise that's what the recovery is doing though). The session I'm tracking on sys.dm_exec_requests is DB_STARTUP.
|
|
| Jan 20, 2016 at 8:07 | history | answered | Shanky | CC BY-SA 3.0 |