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

Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment

The data quality must be kept intact and the method to keep up is difficult to maintain for multiple databases and a VLDB environment too. The default response to recover the data from a disaster is to restore it from the backup tape of a file, but in cases where the source media such as a tape is crinkled or the backup file server disk has a problem, the recovery can be expensive. In this case, gigabytes of data might be lost just because of a hardware problem. There are few methods available in SQL Server to recover the data using the database consistency process, which involves a repair of corrupted data stored within the database. ...

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