O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Restoring Data from Backups

You may need to restore data for various reasons. The most critical reason is to restore lost data, which may be a factor in the success or failure of a business. Here are some common scenarios in which you may restore data:

  • To restore data lost or corrupted because of a system failure

  • To restore a database onto a development system for use by application developers while developing and testing new code

  • To restore a database onto a test system to load test your applications or to test the use of certain database features in a controlled environment

  • To restore a database onto a separate server as a read-only database that can be accessed by users to perform queries, such as for reports.

There are several ways to restore data, ...

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