HP Application Software Suite for Microsoft SQL instruction

NOTE: Due to an SQL instance limitation, the recommended maximum number of databases for which you can create snapshot backups at the same time is 35.

For more information, see Microsoft KB 943471: http://support.microsoft.com/kb/943471

Features Not Supported

•Microsoft SQL Server offline backup

•VSS backup types “Incremental,” “Differential,” “Copy,” and “Log”

•All backup tools, except for HP Data Protector and Symantec NetBackup

•Access to HP 3PAR Storage System via SSH

•Display of different versions of Microsoft SQL Server from the same Recovery Manager backup server

•Interoperability between Windows Server 2003 and Windows Server 2008

In other words, you cannot mount a virtual copy created under Windows 2003 to a Windows 2008 target host.

•Taking a snapshot of the SQL servers created with the SQL Server Authentication setting.

Recovery Manager for SQL supports SQL servers created with the Windows Authentication setting. If you are running SQL Server, Recovery Manager supports both Windows Authentication mode and SQL Server and Windows Authentication mode.

•Taking a snapshot of a database residing on a network mapped volume

•Virtual copy ownership transferring. For example, you can only remove virtual copies if you created them, and you can only unmount virtual copies if you mounted them.

•Taking a snapshot of an instance or database that resides on dynamic disks

•Mounting snapshots to a Windows host that resides in virtual environment

•Performing a restore in a virtualization environment

•Date customization. Recovery Manager always displays dates in month/day/year format.

•Windows automount feature

Microsoft Volume Shadow Copy Service

Microsoft includes Volume Shadow Copy Service (VSS) in Windows 2003 and Windows 2008 to simplify the enterprise’s storage environment, which provides a framework for creating a point-in-time copy of either a single volume or multiple volumes.

Microsoft Windows Server 2008 VSS works with VSS-aware applications that are used to determine when a volume shadow copy (snapshot) can be made. (A snapshot is a virtual copy: a copy of some data set—for example, a disk volume—at a point in time.) Before making a snapshot, VSS communicates with the operating system and applications to freeze computing tasks, which enables an application-consistent snapshot to be taken. The shadow copy volume is then used for the actual backup. After VSS saves the shadow copy volume on the backup device, it deletes the shadow copy.

Features Not Supported