I'd like to know if the time to restore the database is equal the time using restore validate database. If not, How can I know how much time the restore will spend?


RESTORE VALIDATE reads the backups, but it skips writing the files to the disk. If writing files to the disk during restore is the limiting factor, then it will be faster. Otherwise it will be the same.

Depending on the backup technology in use, this may or may not be a valid method for estimating the time of a real restore. For example, when using tape backups, the placement of backups and the number of currently available drives may vary.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.