The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.

Uncover the flexibility of custom metrics Keep up to date from anywhere with SQL Monitor, and monitor the most important data for your servers and applications. Download a free trial.