Show TOC

Recovery with MS SQL ServerLocate this document in the navigation structure

Use

To minimize downtime with the SQL Server database, you must make sure that you can quickly recover the database in the event of a failure with loss of production data. This means routinely backing up the database and being able to restore the database after failure. This section concentrates on database restore. For more information, see Database Restore .

Process

  1. You make sure that you have recent database and transaction-log backups. This is absolutely essential if you want an up-to-date restore of the database. For more information, see Backup with MS SQL Server .

  2. You work out how best to restore the database, depending on the failure that has occurred:

    1. Restoring after a disk crash affecting the database or log

    2. Restoring after a disk crash affecting the executables

  3. You regularly test database restore using a test system as similar as possible to your production system.

Result

You can restore your database as quickly and efficiently as possible, so avoiding downtime caused by a failure with data loss.