HP Data Protector A.06.11 Quick setup guide

HP Data Protector A.06.11
Integration guide for Microsoft
applications
SQL Server, SharePoint Portal Server, Exchange
Server, and Volume Shadow Copy Service
B6960-90157
Part number: B6960-90157
First edition: September 2009

Legal and notice information
© Copyright 2004, 2009 Hewlett-Packard Development Company, L.P.
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent
with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard
commercial license.
The information contained herein is subject to change without notice. The only warranties for HP products
and services are set forth in the express warranty statements accompanying such products and services.
Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for
technical or editorial errors or omissions contained herein.
Intel®, Itanium®, Pentium®, Intel Inside®, and the Intel Inside logo are trademarks or registered trademarks
of Intel Corporation or its subsidiaries in the United States and other countries.
Microsoft®, Windows®, Windows XP®, and Windows NT® are U.S. registered trademarks of Microsoft
Corporation.
Adobe and Acrobat are trademarks of Adobe Systems Incorporated.
Java is a US trademark of Sun Microsystems, Inc.
Oracle® is a registered US trademark of Oracle Corporation, Redwood City, California.
UNIX® is a registered trademark of The Open Group.
Printed in the US

Contents
Publication history .............................................................. 13
About this guide ................................................................. 15
Intended audience ............................................................................................. 15
Documentation set ............................................................................................. 15
Guides ...................................................................................................... 15
Online Help ............................................................................................... 18
Documentation map .................................................................................... 19
Abbreviations ...................................................................................... 19
Map ................................................................................................... 20
Integrations ......................................................................................... 21
Document conventions and symbols ..................................................................... 23
Data Protector graphical user interface ................................................................. 24
General information .......................................................................................... 25
HP technical support .......................................................................................... 25
Subscription service ........................................................................................... 26
HP websites ...................................................................................................... 26
Documentation feedback .................................................................................... 26
1 Integrating Microsoft SQL Server and Data Protector ............ 27
Introduction ...................................................................................................... 27
Integration concepts .......................................................................................... 28
Parallelism ................................................................................................. 29
Configuring the integration ................................................................................. 30
Prerequisites ............................................................................................... 30
Before you begin ........................................................................................ 31
Data Protector SQL Server configuration file ................................................... 31
Configuring users ........................................................................................ 32
Configuring SQL Server instances ................................................................. 32
Using the Data Protector GUI ................................................................. 33
Using the Data Protector CLI .................................................................. 36
Changing and checking configuration ........................................................... 37
Using the Data Protector GUI ................................................................. 37
Integration guide for Microsoft applications 3

Using the Data Protector CLI .................................................................. 38
Backup ............................................................................................................ 39
Creating backup specifications ..................................................................... 39
SQL Server Specific Backup Options ....................................................... 42
Object specific options .......................................................................... 44
Scheduling backups .................................................................................... 45
Scheduling example ............................................................................. 45
Starting backup sessions .............................................................................. 46
Using the Data Protector GUI ................................................................. 46
Restore ............................................................................................................. 46
Restore methods .......................................................................................... 46
Before you begin ........................................................................................ 47
Restoring using the Data Protector GUI ......................................................... 47
Restore options ........................................................................................... 51
Restoring to another SQL Server instance or/and another SQL Server ......... 53
Restoring using the Data Protector CLI ............................................................ 54
Disaster recovery ........................................................................................ 55
Recovering the master database ............................................................. 56
Recovering user databases .................................................................... 57
Performance tuning ............................................................................................ 58
Monitoring sessions ........................................................................................... 62
Troubleshooting ................................................................................................ 63
Before you begin ........................................................................................ 63
Checks and verifications .............................................................................. 63
Problems .................................................................................................... 64
2 Integrating Microsoft SharePoint Portal Server and Data
Protector ........................................................................... 69
Introduction ...................................................................................................... 69
Integration concepts .......................................................................................... 70
Backup and restore flow .............................................................................. 73
Configuring the integration ................................................................................. 73
Prerequisites ............................................................................................... 74
Before you begin ........................................................................................ 74
Configuring SPS users .................................................................................. 74
Configuring SPS farms ................................................................................. 74
Checking the configuration .......................................................................... 77
Backup ............................................................................................................ 77
Before you begin ........................................................................................ 78
Creating backup specifications ..................................................................... 78
Modifying backup specifications ................................................................... 81
Scheduling backup specifications .................................................................. 81
4

Scheduling example ............................................................................. 81
Previewing backup sessions .......................................................................... 82
Using the Data Protector GUI ................................................................. 82
Using the Data Protector CLI .................................................................. 83
What happens during the preview? ........................................................ 83
Starting backup sessions .............................................................................. 83
Before you begin .................................................................................. 83
Using the Data Protector GUI ................................................................. 83
Using the Data Protector CLI .................................................................. 84
Preparing for disaster recovery ..................................................................... 84
Restore ............................................................................................................. 85
Before you begin ........................................................................................ 85
Considerations ........................................................................................... 85
Restoring using the Data Protector GUI .......................................................... 85
Restoring using the Data Protector CLI ............................................................ 90
Restoring using another device ..................................................................... 92
Using the Data Protector GUI ................................................................. 92
Using the Data Protector CLI .................................................................. 92
Disaster recovery ........................................................................................ 93
Monitoring sessions ........................................................................................... 93
Troubleshooting ................................................................................................. 93
Before you begin ........................................................................................ 94
Checks and verifications .............................................................................. 94
Problems .................................................................................................... 94
3 Integrating Microsoft Exchange Server and Data Protector .... 97
Introduction ...................................................................................................... 97
Integration concepts .......................................................................................... 98
Configuring the integration ................................................................................. 99
Prerequisites ............................................................................................... 99
Limitations ................................................................................................ 100
Before you begin ...................................................................................... 100
Backup .......................................................................................................... 101
Configuring Exchange Server Backup .......................................................... 102
Creating backup specifications ............................................................. 102
Exchange Server specific backup options ............................................... 107
Scheduling backups .................................................................................. 108
Scheduling example ........................................................................... 108
Starting backup sessions ............................................................................ 108
Using the Data Protector GUI ............................................................... 108
Restore ........................................................................................................... 109
Restoring using the GUI ............................................................................. 110
Integration guide for Microsoft applications 5

Restoring to another client .................................................................... 115
Restoring using the CLI ............................................................................... 116
Troubleshooting .............................................................................................. 117
Before you begin ...................................................................................... 117
Checks and verifications ............................................................................ 117
Problems .................................................................................................. 119
4 Integrating Microsoft Exchange Single Mailbox and Data
Protector ......................................................................... 123
Introduction .................................................................................................... 123
Integration concepts ........................................................................................ 124
Configuring the integration ............................................................................... 125
Prerequisites ............................................................................................. 125
Limitations ................................................................................................ 126
Before you begin ...................................................................................... 126
Cluster-aware clients .................................................................................. 126
Configuring Exchange Server users ............................................................. 126
Configuring Exchange servers .................................................................... 126
Checking the configuration ........................................................................ 127
Backup .......................................................................................................... 128
Creating backup specifications ................................................................... 128
Modifying backup specifications ................................................................. 132
Scheduling backup specifications ................................................................ 132
Scheduling example ........................................................................... 132
Previewing backup sessions ........................................................................ 133
Using the Data Protector GUI ............................................................... 133
Using the Data Protector CLI ................................................................ 134
What happens during the preview? ...................................................... 134
Starting backup sessions ............................................................................ 134
Using the Data Protector GUI ............................................................... 134
Using the Data Protector CLI ................................................................ 135
Restore ........................................................................................................... 135
Before you begin ...................................................................................... 135
Restoring using the Data Protector GUI ........................................................ 135
Restoring using the Data Protector CLI .......................................................... 142
Restore examples ................................................................................ 144
Monitoring sessions ......................................................................................... 145
Performance tuning .......................................................................................... 145
Troubleshooting ............................................................................................... 147
Before you begin ...................................................................................... 147
Checks and verifications ............................................................................ 147
Problems .................................................................................................. 148
6

5 Integrating Microsoft Volume Shadow Copy Service with Data
Protector ......................................................................... 153
Introduction .................................................................................................... 153
Volume Shadow Copy Service .................................................................... 153
Integration concepts ........................................................................................ 156
Backup .................................................................................................... 156
Data consistency ................................................................................ 158
Restore .................................................................................................... 158
Restoring components ......................................................................... 158
Restoring files ..................................................................................... 159
VSS database .......................................................................................... 159
Querying the VSSDB .......................................................................... 160
Deleting backup sessions ..................................................................... 160
Microsoft Exchange Server 2007 writer concepts .......................................... 161
Backup ............................................................................................. 161
Restore .............................................................................................. 161
Microsoft Hyper-V VSS writer concepts ......................................................... 162
Prerequisites ...................................................................................... 162
Microsoft SharePoint Services VSS writer concepts ......................................... 162
Prerequisites and limitations .............................................................................. 163
Prerequisites ............................................................................................. 164
Limitations ................................................................................................ 164
Configuring the integration ............................................................................... 164
Microsoft Exchange Server writer specific configuration .................................. 165
Prerequisites ...................................................................................... 165
Writers specifics .............................................................................................. 165
Backing up writers data ................................................................................... 170
Overview ................................................................................................. 170
Creating backup specifications using GUI .................................................... 170
VSS specific backup options ................................................................ 175
Microsoft Exchange Server writer backup specifics .................................. 175
Microsoft Data Protection Manager 2006 writer specifics ........................ 179
Microsoft Hyper-V VSS writer backup specifics ........................................ 181
Microsoft SharePoint Services VSS writer backup specifics ........................ 183
Scheduling the backup .............................................................................. 184
Running an interactive backup .................................................................... 185
Restoring writers data ...................................................................................... 186
Restore procedure ..................................................................................... 186
Restore options ................................................................................... 191
MSDE writer restore specifics ...................................................................... 191
Microsoft Exchange Server writer restore specifics ......................................... 193
Rollforward recovery from the loss of one or more databases ................... 193
Integration guide for Microsoft applications 7

Point-in-time restore after loss of a log file .............................................. 194
Microsoft Exchange Server 2007 writer restore specifics .......................... 195
Microsoft Data Protection Manager 2006 writer restore specifics ..................... 198
Restore the DPM server first .................................................................. 198
Restore the DPM clients directly ............................................................ 201
Microsoft Hyper-V VSS writer restore specifics ............................................... 201
Restore from a physical cluster node ...................................................... 201
Microsoft SharePoint Services VSS writer restore specifics ............................... 202
Monitoring a VSS backup and restore ................................................................ 203
Monitoring current sessions ........................................................................ 203
Viewing previous sessions .......................................................................... 204
Troubleshooting ............................................................................................... 205
Before you begin ...................................................................................... 206
Checks and verifications ............................................................................ 206
Backup problems ...................................................................................... 206
Restore problems ...................................................................................... 208
Glossary ......................................................................... 211
Index .............................................................................. 269
8

Figures
Data Protector graphical user interface ............................................... 251
Data Protector SQL Server integration architecture ................................ 292
Database parallelism = 4, Overall Concurrency = 10 ........................... 303
SQL Server users ............................................................................. 334
Configuring SQL Server .................................................................... 355
Checking configuration .................................................................... 386
Selecting a blank template ................................................................ 407
Selecting backup objects .................................................................. 418
Saving a backup specification ........................................................... 429
Application specific options .............................................................. 4310
Object properties ............................................................................ 4511
Restore objects ................................................................................ 4812
Selecting object specific options ........................................................ 4913
Restore options ................................................................................ 5014
Adjusted local device ....................................................................... 6015
Advanced options ........................................................................... 6116
Block sizes not adjusted .................................................................... 6217
SPS integration architecture ............................................................... 7118
Selecting a front-end Web server system ............................................. 7619
Configuring an SPS farm .................................................................. 7720
Selecting SPS objects ....................................................................... 7921
Application specific options .............................................................. 8022
Scheduling a backup specification ..................................................... 8223
Selecting SPS objects for restore ........................................................ 8624
Integration guide for Microsoft applications 9

Specifying the restore destination for an SQL Server database ............... 8725
Specifying the restore destination for an index server ........................... 8826
SPS restore options .......................................................................... 8927
Data Protector Exchange Server integration architecture ........................ 9928
Path system variable ....................................................................... 10129
Selecting a blank template .............................................................. 10330
Client name and application database ............................................. 10431
Backup objects .............................................................................. 10532
Backup devices ............................................................................. 10633
Application specific options ............................................................ 10734
Unmounting a database ................................................................ 11035
Restore objects .............................................................................. 11236
Selecting a backup version ............................................................. 11337
Restore options .............................................................................. 11538
Exchange Single Mailbox integration architecture .............................. 12439
Configuring the Exchange Server ..................................................... 12740
Selecting a template ...................................................................... 12941
Selecting Exchange items for backup ............................................... 13042
Exchange Single Mailbox specific backup options ............................. 13143
Scheduling a backup specification ................................................... 13344
Selecting Exchange items for restore ................................................ 13645
Version properties .......................................................................... 13746
Advanced properties ...................................................................... 13847
Selecting the destination Exchange Server system .............................. 13948
Restored mailbox and public folders content with the restore to new folder
option selected. ............................................................................. 140
49
Example of backup with concurrency 1 ............................................ 14650
Example of backup with concurrency 2 ............................................ 14651
Specifying the Exchange Server administrator’s mailbox ..................... 15052
10

Actors of the traditional backup model ............................................. 15553
Actors of the Data Protector VSS integration backup model ................. 15554
Local VSS backup .......................................................................... 15855
Selecting Microsoft Exchange Server 2007 CCR copy backup
objects ......................................................................................... 172
56
Selecting Microsoft Hyper–V VSS writer backup objects ...................... 17357
Additional options for Microsoft Exchange Server 2007 in a CCR
environment .................................................................................. 174
58
Selecting Microsoft Exchange Server 2003 storage groups ................. 17759
Selecting a replicated Microsoft Exchange Server 2007 storage
group .......................................................................................... 178
60
Selecting Microsoft Data Protection Manager database and replicas .... 18161
Selecting Microsoft SharePoint Services writer and the corresponding
search writers ................................................................................ 184
62
Scheduling a backup ..................................................................... 18563
Restore objects .............................................................................. 18864
Restore to different location options (Exchange Server 2007 Writer) ..... 19065
MSDE writer ................................................................................. 19266
Selecting Microsoft Exchange Server 2007 stores for rollforward
recovery ....................................................................................... 194
67
Selecting Microsoft Exchange Server 2003 stores for point-in-time
restore ......................................................................................... 195
68
Restoring the Microsoft Data Protection Manager 2006 client .............. 20069
Selecting Microsoft SharePoint Services writer and the corresponding
search writers for restore ................................................................. 203
70
Monitoring a current session ........................................................... 20471
Viewing a previous session ............................................................. 20572
Integration guide for Microsoft applications 11

Tables
Edition history ................................................................................. 131
Document conventions ...................................................................... 232
SQL Server online backup types ........................................................ 273
Legend ........................................................................................... 294
SQL Server backup options ............................................................... 435
Object specific options ..................................................................... 456
SQL Server restore options ................................................................ 517
Backup types .................................................................................. 698
Legend ........................................................................................... 719
SPS objects ..................................................................................... 7210
Backup types .................................................................................. 7811
SPS backup options ......................................................................... 8112
What must be backed up ................................................................. 8413
SPS restore options .......................................................................... 9014
Exchange Server online backup types ................................................ 9715
Legend ........................................................................................... 9916
Application specific options ............................................................ 10717
Exchange Server restore options ...................................................... 11418
Exchange Single Mailbox backup types ........................................... 12319
Exchange Single Mailbox backup types ........................................... 12820
Exchange Single Mailbox specific backup options ............................. 13221
Exchange Single Mailbox restore options .......................................... 14022
Writer description .......................................................................... 16623
VSS specific backup options ............................................................ 17524
12

Publication history
Guide updates may be issued between editions to correct errors or document product
changes. To ensure that you receive updated or new editions, subscribe to the
appropriate product support service. See your HP sales representative for details.
Table 1 Edition history
ProductGuide editionPart number
Data Protector Release A.05.50October 2004B6960-90108
Data Protector Release A.06.00July 2006B6960-96007
Data Protector Release A.06.10November 2008B6960-96041
Data Protector Release A.06.11September 2009B6960-90157
Integration guide for Microsoft applications 13

Publication history14

About this guide
This guide describes how to configure and use Data Protector with Microsoft
applications.
Intended audience
This guide is intended for backup administrators responsible for planning, setting up,
and maintaining network backups. It assumes you are familiar with:
•Basic Data Protector functionality
•Database administration
Conceptual information can be found in the HP Data Protector concepts guide, which
is recommended to fully understand the fundamentals and the model of Data Protector.
Documentation set
Other documents and online Help provide related information.
Guides
Data Protector guides are available in printed format and in PDF format. Install the
PDF files during the Data Protector setup procedure by selecting the English
Documentation & Help component on Windows or the OB2-DOCS component
on UNIX. Once installed, the guides reside in the Data_Protector_home\docs
directory on Windows and in the /opt/omni/doc/C directory on UNIX.
You can find these documents from the Manuals page of the HP Business Support
Center website:
http://www.hp.com/support/manuals
In the Storage section, click Storage Software and then select your product.
•HP Data Protector concepts guide
Integration guide for Microsoft applications 15

This guide describes Data Protector concepts and provides background information
on how Data Protector works. It is intended to be used with the task-oriented
online Help.
•HP Data Protector installation and licensing guide
This guide describes how to install the Data Protector software, taking into account
the operating system and architecture of your environment. This guide also gives
details on how to upgrade Data Protector, as well as how to obtain the proper
licenses for your environment.
•HP Data Protector troubleshooting guide
This guide describes how to troubleshoot problems you may encounter when
using Data Protector.
•HP Data Protector disaster recovery guide
This guide describes how to plan, prepare for, test and perform a disaster
recovery.
•HP Data Protector integration guides
These guides describe how to configure and use Data Protector to back up and
restore various databases and applications. They are intended for backup
administrators or operators. There are four guides:
•HP Data Protector integration guide for Microsoft applications: SQL Server,
SharePoint Portal Server, Exchange Server, and Volume Shadow Copy Service
This guide describes the integrations of Data Protector with the following
Microsoft applications: Microsoft Exchange Server, Microsoft SQL Server, and
Volume Shadow Copy Service.
•HP Data Protector integration guide for Oracle and SAP
This guide describes the integrations of Data Protector with Oracle, SAP R/3,
and SAP DB/MaxDB.
•HP Data Protector integration guide for IBM applications: Informix, DB2, and
Lotus Notes/Domino
This guide describes the integrations of Data Protector with the following IBM
applications: Informix Server, IBM DB2, and Lotus Notes/Domino Server.
•HP Data Protector integration guide for VMware Virtual Infrastructure, Sybase,
Network Node Manager, and Network Data Management Protocol Server
This guide describes the integrations of Data Protector with VMware Virtual
Infrastructure, Sybase, Network Node Manager, Network Data Management
Protocol Server, and Citrix XenServer.
•HP Data Protector integration guide for HP Service Information Portal
About this guide16

This guide describes how to install, configure, and use the integration of Data
Protector with HP Service Information Portal. It is intended for backup
administrators. It discusses how to use the application for Data Protector service
management.
•HP Data Protector integration guide for HP Reporter
This manual describes how to install, configure, and use the integration of Data
Protector with HP Reporter. It is intended for backup administrators. It discusses
how to use the application for Data Protector service management.
•HP Data Protector integration guide for HP Operations Manager for UNIX
This guide describes how to monitor and manage the health and performance of
the Data Protector environment with HP Operations Manager and HP Service
Navigator on UNIX.
•HP Data Protector integration guide for HP Operations Manager for Windows
This guide describes how to monitor and manage the health and performance of
the Data Protector environment with HP Operations Manager and HP Service
Navigator on Windows.
•HP Data Protector integration guide for HP Performance Manager and HP
Performance Agent
This guide provides information about how to monitor and manage the health
and performance of the Data Protector environment with HP Performance Manager
(PM) and HP Performance Agent (PA) on Windows, HP-UX, Solaris, and Linux.
•HP Data Protector zero downtime backup concepts guide
This guide describes Data Protector zero downtime backup and instant recovery
concepts and provides background information on how Data Protector works in
a zero downtime backup environment. It is intended to be used with the
task-oriented HP Data Protector zero downtime backup administrator's guide and
the HP Data Protector zero downtime backup integration guide.
•HP Data Protector zero downtime backup administrator's guide
This guide describes how to configure and use the integration of Data Protector
with HP StorageWorks Virtual Array, HP StorageWorks Enterprise Virtual Array,
EMC Symmetrix Remote Data Facility and TimeFinder, and HP StorageWorks
Disk Array XP. It is intended for backup administrators or operators. It covers the
zero downtime backup, instant recovery, and the restore of filesystems and disk
images.
•HP Data Protector zero downtime backup integration guide
This guide describes how to configure and use Data Protector to perform zero
downtime backup, instant recovery, and standard restore of Oracle, SAP R/3,
Microsoft Exchange Server, and Microsoft SQL Server databases. The guide also
Integration guide for Microsoft applications 17

describes how to configure and use Data Protector to perform backup and restore
using the Microsoft Volume Shadow Copy Service.
•HP Data Protector MPE/iX system user guide
This guide describes how to configure MPE/iX clients and how to back up and
restore MPE/iX data.
•HP Data Protector Media Operations user guide
This guide provides tracking and management of offline storage media. It describes
the tasks of installing and configuring the application, performing daily media
operations and producing reports.
•HP Data Protector product announcements, software notes, and references
This guide gives a description of new features of HP Data Protector A.06.11. It
also provides information on installation requirements, required patches, and
limitations, as well as known issues and workarounds.
•HP Data Protector product announcements, software notes, and references for
integrations to HP Operations Manager, HP Reporter, HP Performance Manager,
HP Performance Agent, and HP Service Information Portal
This guide fulfills a similar function for the listed integrations.
•HP Data Protector Media Operations product announcements, software notes,
and references
This guide fulfills a similar function for Media Operations.
•HP Data Protector command line interface reference
This guide describes the Data Protector command-line interface, command options
and their usage as well as provides some basic command-line examples.
Online Help
Data Protector provides context-sensitive (F1) Help and Help Topics for Windows
and UNIX platforms.
You can access the online Help from the top-level directory on the installation
DVD-ROM without installing Data Protector:
• Windows: Unzip DP_help.zip and open DP_help.chm.
• UNIX: Unpack the zipped tar file DP_help.tar.gz, and access the online Help
system through DP_help.htm.
About this guide18

Documentation map
Abbreviations
Abbreviations in the documentation map that follows are explained below. The guide
titles are all preceded by the words “HP Data Protector”.
GuideAbbreviation
Command line interface referenceCLI
Concepts guideConcepts
Disaster recovery guideDR
Getting started guideGS
Online HelpHelp
Integration guide for IBM applications: Informix, DB2, and Lotus
Notes/Domino
IG-IBM
Integration guide for Microsoft applications: SQL Server, SharePoint
Portal Server, Exchange Server, and Volume Shadow Copy Service
IG-MS
Integration guide for Oracle and SAPIG-O/S
Integration guide for HP Operations Manager for UNIXIG-OMU
Integration guide for HP Operations Manager for WindowsIG-OMW
Integration guide for HP Performance Manager and HP Performance
Agent
IG-PM/PA
Integration guide for HP ReporterIG-Report
Integration guide for HP Service Information PortalIG-SIP
Integration guide for VMware Virtual Infrastructure, Sybase, Network
Node Manager, Network Data Management Protocol Server, and
Citrix XenServer.
IG-Var
Integration guide for Microsoft applications 19

GuideAbbreviation
Installation and licensing guideInstall
Media Operations getting started guideMO GS
Media Operations product announcements, software notes, and
references
MO RN
Media Operations user guideMO UG
MPE/iX system user guideMPE/iX
Product announcements, software notes, and referencesPA
Troubleshooting guideTrouble
ZDB administrator's guideZDB Admin
ZDB concepts guideZDB Concept
ZDB integration guideZDB IG
Map
The following table shows where to find information of different kinds. Shaded squares
are a good place to look first.
About this guide20