Verifying the backup configuration .............................................................. 233
Verifying restore ........................................................................................ 235
Configuration and backup problems ............................................................ 238
Restore problems ...................................................................................... 240
3 Data Protector Microsoft SQL Server ZDB integration .......... 243
Introduction .................................................................................................... 243
Integration concepts ........................................................................................ 244
Configuring the integration ............................................................................... 245
Prerequisites ............................................................................................. 245
Before you begin ...................................................................................... 246
Data Protector SQL Server configuration file ................................................. 246
Configuring users ...................................................................................... 247
Configuring SQL Server instances ............................................................... 248
Using the Data Protector GUI ............................................................... 249
Using the Data Protector CLI ................................................................ 251
Changing and checking configuration ......................................................... 252
Using the Data Protector GUI ............................................................... 252
Using the Data Protector CLI ................................................................ 253
Backup .......................................................................................................... 254
Creating ZDB specifications ....................................................................... 254
SQL Server Specific Backup Options ..................................................... 263
Scheduling backups .................................................................................. 265
Scheduling example ........................................................................... 265
Starting backup sessions ............................................................................ 265
Using the Data Protector GUI ............................................................... 266
Using the Data Protector CLI ................................................................ 266
Restore ........................................................................................................... 266
Before you begin ...................................................................................... 267
Standard restore ....................................................................................... 267
Restore options ......................................................................................... 271
Restoring to another SQL Serverinstance or/and another SQL Server ......... 273
Instant recovery ........................................................................................ 274
Monitoring sessions ......................................................................................... 276
Troubleshooting .............................................................................................. 277
Before you begin ...................................................................................... 277
Checks and verifications ............................................................................ 277
Problems .................................................................................................. 278
4 Data Protector Microsoft Exchange Server ZDB integration ... 285
Introduction .................................................................................................... 285
Integration concepts ........................................................................................ 286
Zero downtime backup integration guide 7