ACRONIS Recovery MS SQL Server - Upgrade AAS to AAP Spécifications télécharger pdf (Page 86)

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:

a. Select the whole Microsoft SQL Server instance (or all available

instances) as a backup source

b. Select a backup destination

c. Select Full, Differential and Transaction logs backups type

d. Schedule full backups for every month, differential backups for every

week and transaction log backup for every day

1 2 ... 81 82 83 84 85 86 87 88 89 90 91 92 93 94

Pas de commentaire

ACRONIS Recovery MS SQL Server - Upgrade AAS to AAP Spécifications Page 86