patternsqlMinor
I just exited SSMS while restoring a UAT database, am I screwed?
Viewed 0 times
ssmswhilejustuatrestoringdatabaseexitedscrewed
Problem
I just flinched and closed out of habit while waiting for the restore to reach 100%. Did I just break everything? Is it possible to view the progress of the restore?
Update: I was in a bit of a panic, so I roped in my team lead. The database was now stuck in the restoring state and that script didn't work so we just dropped it and started over. It went okay.
Was that necessary? In the UI for a restore there is a period of time before the percentage complete is displayed. I had closed the application before that... not sure if that matters.
Update: I was in a bit of a panic, so I roped in my team lead. The database was now stuck in the restoring state and that script didn't work so we just dropped it and started over. It went okay.
Was that necessary? In the UI for a restore there is a period of time before the percentage complete is displayed. I had closed the application before that... not sure if that matters.
Solution
This is baked into sp_Whoisactive as well without needing an ad-hoc script.
It's the percent_complete column, over to the right (removed some superflous columns like sql_text and waitinfo):
It's the percent_complete column, over to the right (removed some superflous columns like sql_text and waitinfo):
Context
StackExchange Database Administrators Q#193742, answer score: 4
Revisions (0)
No revisions yet.