Filter
Top Products
Backing Up Server Applications
95
SonicWALL CDP 6.0 Agent User’s Guide
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