The availability and recoverability is important for any database as that helps, at any point in time, to restore a database to a specific point-in-time. Also, to restore all file groups in that database to the same point-in-time requires the database design capable of implementing multiple file groups for a database. As the databases become larger and larger, the infrastructure and technology must support the availability strategy. In such cases, restoring an entire multi-terabyte database to a point-in-time could result in big outage. The online page restore feature from SQL Server 2008 R2 will build a best strategy of multiple database files availability in order to host very large databases and minimize the backup time.