HP Data Protector 6.2 software integration with HP 3PAR Storage System

26
To create a Microsoft SQL backup specification, use the same procedure as for the file system backup
specification creation. The only difference is in the selection of components to be backed up. In the list
of available writers, under SqlServerWriter, select components that you would like to backup in this
backup specification. You can select either the whole MS SQL instance or specific database (see
Figure 24). Database DB1_3PAR has its data stored on one file system and its transaction logs on the
other:
• file system containing DB1_3PAR database files is mounted on:
C:\mnt\SQL2008R2\DB1\data\
• file system holding transaction logs is mounted on:
C:\mnt\SQL2008R2\DB1\logs\
Figure 24: Select Microsoft SQL Writer components to be backed up
An example of the Microsoft SQL Server backup-session report can be found in Appendix B: Microsoft
SQL Server Backup section.
Microsoft SQL restore from media
Restore to the point-in-time when a VSS-based backup was taken
To restore MS SQL VSS based backup to the point-in-time when VSS based full backup was taken,
follow the same procedure as for file system restore described in the section File System restore from
media. When coming to the point to choose the object to be restored, you must select the
SqlServerWriter component that you want to restore (see
Figure 25). All other options should be set in
the same manner as for the file system restore from media. After restore is done, database will be
recovered to the point in which it was when the full backup was taken. The database will be brought
to an online state. It will be not possible to apply any transaction logs to the database.