Backing up Microsoft SQL Server
161
SonicWALL CDP 6.0 Administrator’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 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 backup and restore using CDP, the Agent Service directly interfaces with the
Microsoft SQL server through the Open Database Connectivity (ODBC) API, using an SQL-
ODBC driver that is installed with SQL. 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 using either
Windows user account credentials or using an SQL account. More details are provided in the
“SQL Authentication” section on page 167
.
This section contains the following subsections:
•
“Adding a SQL Server Backup Application Object” section on page 162
•
“Scheduling Backups for Microsoft SQL” section on page 163
•
“Configuring a Backup Task for Microsoft SQL Database Backups” section on page 163
•
“Verifying SQL Account Configuration” section on page 166
•
“SQL Authentication” section on page 167
Summary of Contents for CDP 6.0
Page 15: ...xiv SonicWALL CDP 6 0 Administrator s Guide...
Page 99: ...Creating a Global Policy 84 SonicWALL CDP 6 0 Administrator s Guide...
Page 215: ...Recovering Data from Microsoft SQL Server 200 SonicWALL CDP 6 0 Administrator s Guide...
Page 229: ...Replacing the Downstream CDP Appliance 214 SonicWALL CDP 6 0 Administrator s Guide...
Page 267: ...Contributors 252 SonicWALL CDP 6 0 Administrator s Guide...