Performing sql maintenance tasks, Applying operating system updates on sql servers, Running antivirus software on sql servers – Dell PowerVault DP600 User Manual
Page 63: Performing sql server management tasks
63
Using Windows Maintenance Tools on Exchange Servers
Using Windows Maintenance Tools on Windows SharePoint Services Servers
Using Windows Maintenance Tools on Virtual Server
Performing SQL Maintenance Tasks
Coordinate with the SQL Server administrator to ensure that the following tasks are not
scheduled at the same time as the express full backup performed by DPM:
• Check database integrity
• History cleanup
• Maintenance cleanup
• Rebuild index
• Reorganize index
• Shrink database
• Update statistics
Best practices for SQL Server include running a weekly database consistency check (DBCC).
You should continue this practice for databases protected by DPM to avoid backing up a
database with corruption issues.
Applying Operating System Updates on SQL Servers
An important part of computer maintenance is ensuring that operating systems and software are
up to date. Updates—known as "fixes," "patches," "service packs," and "security rollup
packages"—help to protect computers and data.
You can use your preferred method for deploying software updates, such as Automatic Updates
or Windows Server Update Services, on computers running SQL Server that are protected by
DPM. Because some software updates require a computer restart, you should schedule or
perform the updates at times that have the least impact on protection operations.
Running Antivirus Software on SQL Servers
To prevent data corruption of replicas and recovery points, configure the antivirus software to
delete infected files rather than automatically cleaning or quarantining them. Automatic cleaning
and quarantining can result in data corruption because these processes cause the antivirus
software to modify files, making changes that DPM cannot detect. For instructions on configuring
your antivirus software to delete infected files, see the documentation for your antivirus software.
Performing SQL Server Management Tasks
This section provides instructions and guidelines for managing a protected SQL server and
making changes after the initial configuration of Data Protection Manager.