November 10, 2020 at 8:20 am
Just curious.
I restore databases very often as I am a developer.
Some of them has a size, that means that it takes some time.
I use to backup with the same version as I restore from. I am aware, that if i restore a SQL 2012 with a SQL 2019, the converting takes some time.
But what happens from 100% to succes. it's generally more than 50% of the time used
Best regards
Edvard Korsbæk
November 10, 2020 at 4:54 pm
You could look at enabling some trace flags before the restore to get more detailed information. Most of the articles on doing this mention using trace flags 3004 and 3605 - those are the ones I've usually used. This article explains those and has an example:
When doing a database restore, what actions is the engine taking after it gets past the 100%?
You can also look at using trace flags 3216 and 3605 to get more details.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply