Library Table of Contents Index Previous Page (Alt-p) Next Page (Alt-n) Comments

Backing up your SQL Server environment

The following topics describe backing up your SQL Server environment:

Backing up your Windows environment  Top

SnapManager, the SQL Server, and the storage systems are dependent on the Windows environment. Before you can use any of the processes in this section, the Windows environment must be completely restored. Therefore, it is important that you back up your Windows environment so that you can restore the same state as part of the recovery process.

To back up your Windows environment, you must complete, at a minimum, the following high-level process.

Step

Action

1

Back up your SQL Server, including your Windows operating system and any applications running concurrently with the SQL Server.

2

Use your backup utility to create and maintain a current emergency repair disk (ERD).

Backing up your SQL Server  Top

To ensure that you back up all the required components on your SQL Server, follow the process outlined in the appropriate Microsoft document.

For Microsoft SQL Server 2000:

For Microsoft SQL Server 2005:

Library Table of Contents Index Previous Page (Alt-p) Next Page (Alt-n) Comments