We are going to move some 100+ databases and some of them are 1 TB each. To save time on Friday, we are going to perform restore from sunday's Full backups using with norecovery. And we do this during the week. And Diff restore with recovery on Friday to catch up.
Now I noticed during the week that if a full restore with norecovery fails, it still says "Restoring" ??. One would expect that the database would disappear.
So the question is. How can I double check on thursday let's say, that all databases that are restored from full backups with norecovery, actually are successfully restored so far, when both failed (but initiated successfully) and non failed restores, seems to both show "restoring" state?