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, ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
