O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

Chapter 3. Snapshot Replication

Some time ago, Mr. Young contacted Mr. Old to ask for his advice on what could be the best possible solution to his requirements. Mr. Young works in a large manufacturing company, XY Incorporation, where they have two production boxes, one for developing and the other for testing. They keep only database backup files as the source of recovery in case of any emergency. Now, Mr. Young's boss wanted him to redesign the system architecture so that they don't have to rely on the database backup files for data recovery. The boss also wanted faster report generation. The boss told Mr. Young that would be fine if the reports show data that are few hours old or a day old, but this should be settled in such a way that the ...

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