May 2018
Intermediate to advanced
576 pages
30h 25m
English
A physical backup and restore is completely up to you. Copy those files as fast as you like, and in any way you like. Put them back in the same way or a different way.
Logical backup and restore involves moving data out of and into the database. That's typically going to be slower than physical backup and restore. Particularly with a restore, rebuilding indexes and constraints takes time, even when run in parallel. Plan ahead and measure the performance of your backup and restore techniques so that you have a chance when you need your database back in a hurry.