Specifications

Appendix A. Acronis Recovery

for MS SQL Server: Best Practices

This section provides instructions for best practices when using Acronis Recovery for MS SQL

Server.

A.1 Protect your server from hardware failure, user

errors and viruses

Scenario

The company is running several internet and intranet applications on several Windows 2000

servers using Microsoft SQL Server as the back end (using different instances). Since all

transactions are stored in the database, any data loss is not acceptable. The database

administrator must provide protection from hardware failure, user errors and virus attacks.

Acronis solution

Use the following components

• Acronis Recovery for MS SQL Server Agent (on all servers with databases)

• Acronis Recovery for MS SQL Server Management Console (on an administrator

workstation, from which you plan to manage tasks)

To schedule periodic backup

1. Install Acronis Recovery for MS SQL Server Management Console on the database

administrator workstation and Acronis Recovery for MS SQL Server Agents on the

server where Microsoft SQL Server instances are located

For every Microsoft SQL Server instance perform the following actions:

2. Connect to the server from the Acronis Recovery for MS SQL Server Management

Console using the appropriate credentials

3. Launch the Create Backup wizard and follow the instructions to create a backup

task: