O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Piecemeal restore strategies

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required