SonicWALL 6 manual Backing up Microsoft SQL Server

Backing Up Server Applications

Backing up Microsoft SQL Server

Backing up Microsoft SQL Server using SonicWALL CDP allows users to store and retrieve Microsoft SQL Server revisions from an agent machine. Microsoft SQL Server databases are configured for backup using the SonicWALL CDP Agent User Interface.

Note Microsoft SQL Server backup can only be configured using the Agent User Interface.

During SQL Server backup and restore using CDP, the Agent Service directly interfaces with the server through the Open Database Connectivity (ODBC) API, using an SQL-ODBC driver that is installed with SQL Server. By ODBC, the Agent service communicates to the SQL server through transactional SQL commands.

When the SonicWALL CDP Agent Service backs up an SQL database, it instructs SQL to place the data in a certain location in memory. The Agent Service will then process the data one block at a time, compressing it and sending to the appliance.

The Agent Service first needs to connect to the database and authenticate, typically by using Windows user account credentials.

For more information about SQL backup and restore, see the SonicWALL CDP Administrator’s Guide.

This section contains the following subsections:

•“Adding a SQL Server Backup Application Object” section on page 96

•“Scheduling Backups for Microsoft SQL Server” section on page 97

•“Configuring a Backup Task for Microsoft SQL Server Database Backups” section on page 97

•“Verifying Microsoft SQL Server Backup Activity” section on page 99

SonicWALL CDP 6.0 Agent User’s Guide

95