O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

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 ...

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