Using windows maintenance tools on sql servers – Dell PowerVault DP600 User Manual

Page 62

Advertising
background image

62

Recovering SQL Server Data

Performing General Maintenance on Servers
Running SQL

General maintenance includes tasks such as disk and file maintenance, updating operating

systems and applications, and protecting data by using antivirus software and performing regular

backups. Some special considerations apply when you are performing server maintenance on

SQL Servers that are protected by Data Protection Manager (DPM).

When you need to perform maintenance on a protected server and do not want protection jobs to

continue for the duration of the maintenance, you can use the following procedure to disable the

protection agent.

Note

If you disable a protection agent for a server that is a cluster node, you should disable the

protection agent for every node of the cluster.

To disable a protection agent

1. In DPM Administrator Console, click Management on the navigation bar.

2. On the Agents tab, in the display pane, select the name of the computer with the

protection agent you want to disable.

3. In the Actions pane, click Disable protection agent.

4. In the dialog box, click OK to confirm that you want to proceed.

In This Section

Using Windows Maintenance Tools on SQL Servers

Performing SQL Maintenance Tasks

Applying Operating System Updates on SQL Servers

Running Antivirus Software on SQL Servers

Using Windows Maintenance Tools on SQL Servers

Running Disk Cleanup, Disk Defragmenter, or Chkdsk.exe should have no adverse effect on

performance or data protection.

You should not use other backup applications on a computer running SQL Server that is

protected by DPM.

See Also

Using Windows Maintenance Tools on the DPM Server

Using Windows Maintenance Tools on File Servers and Workstations

Advertising