Interactive Example of Losing and Restoring a Database
Database backup and restores are the most important tasks performed by a DBA. As such, it is very important to be prepared for the day that you must perform your first real-world backup and restore procedure to restore critical user data. To help you along, walk through an actual backup and restore of a database. This exercise is similar to the restore process described in the previous section and simulates an actual backup and restore that you might perform some day!
CAUTION
The following exercise is one that I have been doing for several years in various DBA workshops and training sessions performed at Trilogy Consulting. The exercise is meant to be interactive, so it requires access to ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
