Recovering Data from Microsoft SQL Server
196
SonicWALL CDP 6.0 Administrator’s Guide
Recovering Data from Microsoft SQL Server
Recovery of data from Microsoft SQL using SonicWALL CDP allows users to retrieve Microsoft
SQL revisions from an agent machine previously configured to backup that data. Microsoft SQL
recovery can be made directly to the SQL database.
Restoring the database can be done in two ways. The database can be either restored to disk
or to application. When restoring the database to disk, the database is downloaded as a set of
files from the SonicWALL CDP Appliance.
Restoring to application, on the other hand, applies the database directly to the same SQL
server.
If an SQL database system fails, the first step is to recover all databases and transaction log
files from the server. These databases contain the latest information, up to the point of failure.
Next, the SQL system should be brought up on the same server or a different server. Having
spare hardware will speed up database recovery.
Each recovered database should be run through a data consistency check (using “DBCC
CHECKDB”) because it is possible that these are corrupted databases and may have been the
reason for failure. If the databases are corrupted, these could either be fixed, which normally
includes data loss, or the latest backed up database (from CDP) could be used instead.
See the following sections:
•
“Recovering SQL Using the Agent User Interface” section on page 196
•
“Additional Information” section on page 199
Recovering SQL Using the Agent User Interface
To restore Microsoft SQL databases using the SonicWALL CDP Agent User Interface, perform
the following steps:
Step 1
In the SonicWALL CDP Agent User Interface, click the
My Backups
tab.
Step 2
In the left pane, click
Applications
. The display expands to show available backup tasks.
Step 3
Click the desired backup task. The available revisions are displayed.
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...
