Data Protection for SQL Server requirements

This section provides information on Data Protection for SQL requirements and discusses some of the choices you will need to make during installation. Data Protection for SQL is available in the following packages:

򐂰 Paid in Full

This package contains a license component and is a complete stand-alone release of the product.

򐂰 Program Temporary Fix (PTF)

This package does not contain a license component. It is created to install over a previously installed version of Data Protection for SQL.

2.1.1 Software and operating system requirements

Data Protection for SQL requires the following levels of Tivoli Storage Manager software:

򐂰 Tivoli Storage Manager backup-archive client Version 5.5.0 (or later).

򐂰 Tivoli Storage Manager API Version 5.5.0 (or later).

򐂰 Tivoli Storage Manager server Version 5.4.0 (or later)

Legacy backup and restore software and operating system requirements.

Table 2-1 shows the requirements for legacy backup and restore operations.

Table 2-1 Minimum software and operating system requirements for Legacy Backup and Restore

Basic VSS software and operating system requirements Table 2-2 shows the requirements for basic VSS operations.

Table 2-2 Minimum software and operating system requirements for basic VSS operations Operating system SQL Server VSS Provider TSM for Copy Services Windows 2003 x86 ^a

a. Windows Server 2003 x86: Standard, Enterprise, or DataCenter Edition. All versions must be at Service Pack 1 (or later). Windows Server 2003 R2: Standard, Enterprise, or DataCenter Edition

SQL Server 2000 or 2005^b

b. SQL Server 2005 Standard or Enterprise Edition

None None

Windows 2003 x64^c

c. Windows Server 2003 x64 Standard, Enterprise, or DataCenter x64 Edition. Windows Server 2003 x64 R2: Standard, Enterprise, or DataCenter x64 Edition

None None

Windows 2003 ia64 None None

Operating system SQL Server VSS Provider TSM for Copy Services Windows 2003 x86^a

a. Windows Server 2003 x86: Standard, Enterprise, or DataCenter Edition. All versions must be at Service Pack 1 (or later). Windows Server 2003 R2: Standard, Enterprise, or DataCenter Edition

VSS Off-loaded Backup software and operating system requirements Table 2-3 shows the requirements for VSS Off-loaded backups.

Table 2-3 Minimum software and operating system requirements for VSS Off-loaded Backup

VSS Instant Restore software and operating system requirements Table 2-4 shows the requirements for VSS instant restore operations.

Table 2-4 Minimum software and operating system requirements for VSS Instant Restore operations c. The Microsoft SQL VSS Integration Module is dependent upon the base Data Protection for

SQL product and must be installed to perform any VSS operations

Operating system SQL Server VSS Provider TSM for Copy Services Windows 2003 x86^a

a. Windows Server 2003 x86: Standard, Enterprise, or DataCenter Edition. All versions must be at Service Pack 1 (or later). Windows Server 2003 R2: Standard, Enterprise, or DataCenter Edition

SQL Server 2005^b

b. SQL Server 2005 Standard or Enterprise Edition

Any VSS provider that supports transportable shadow copies ^c

c. The VSS hardware provider must be installed on both machines that are involved in an Off-loaded backup

Microsoft SQL VSS Integration Module Version 5.5.0 ^d

d. The Microsoft SQL VSS Integration Module is dependent upon the base Data Protection for SQL product and must be installed to perform any VSS operations.

Windows 2003 x64^e

e. Windows Server 2003 x64 Standard, Enterprise, or DataCenter x64 Edition. Windows Server 2003 x64 R2: Standard, Enterprise, or DataCenter x64 Edition.

Operating system SQL Server VSS Provider TSM for Copy Services Windows 2003 x86^a

Windows 2003 x64^b

a. Windows Server 2003 x86: Standard, Enterprise, or DataCenter Edition. All versions must be at Service Pack 1 (or later). Windows Server 2003 R2: Standard, Enterprise, or DataCenter Edition

b. Windows Server 2003 x64 Standard, Enterprise, or DataCenter x64 Edition. Windows Server 2003 x64 R2: Standard, Enterprise, or DataCenter x64 Edition.

SQL Server 2005^c

c. SQL Server 2005 Standard or Enterprise Edition On DS storage

d. IBM Subsystem Device Driver (SDD) 1.6.0.2 with Host Attachment Scripts 1.1.0.3. or (later) is required.

On DS storage subsystems:

򐂰 Microsoft SQL VSS Integration Module Version 5.5.0 (or later) ^e

򐂰 Hardware Devices Version 5.5.0 (or later) ^f

򐂰 Hardware Devices Snapshot Integration Module Version 5.5.0 (or later) ^g

2.1.2 Hardware requirements

This section explains the hardware requirements for Data Protection for SQL Server.

Legacy or VSS Backup and Restore hardware requirements

Table 2-5 shows the hardware requirements for Legacy or VSS backup and restore operations.

Table 2-5 Minimum hardware requirements for Legacy or VSS Backup and Restore operations

VSS off-loaded backup hardware requirements

Table 2-6 shows the hardware requirements for VSS off-loaded backup operations.

e. The Microsoft SQL VSS Integration Module is dependent upon the base Data Protection for SQL product and must be installed to perform any VSS operations.

f. The VSS hardware provider must be installed on both machines that are involved in an Off-loaded backup.

g. The Hardware Devices Snapshot Integration Module is dependent upon the base Tivoli Storage Manager backup-archive client product and must be installed to perform VSS Instant Restore operations.

Note: Data Protection for SQL VSS operations are available on any hardware that supports Microsoft VSS requirements. Refer to your VSS provider documentation for required levels. The following list identifies some hardware storage subsystems that were tested with Data Protection for SQL VSS operations:

򐂰 IBM TotalStorage DS6000 and a machine with a processor supported by DS6000 with IBM Common Interface Model (CIM) Agent for DS Open API.

򐂰 IBM TotalStorage DS8000 and a machine with a processor supported by DS8000 with IBM Common Interface Model (CIM) Agent for DS Open API.

򐂰 IBM TotalStorage N3700 with Network Appliance™ (NetApp) SnapDrive Version 3.2 (or later).

򐂰 NetApp fabric-attached storage (NAS) system with NetApp SnapDrive Version 3.2 (or later).

򐂰 IBM TotalStorage SAN Volume Controller Version 2.1.x (or later) or Version 3.1.x.

Contact your hardware storage subsystem vendor for exact details of their support of VSS operations.

Architecture Hardware description Disk Space RAM 32-bit Intel® Pentium® 166

equivalent (or later) processor

20 MB 48 MB (96 MB or greater recommended)

x64 One of the following:

򐂰 Processor that supports

Table 2-6 Minimum hardware requirements for VSS off-loaded backup operations

VSS Instant Restore hardware requirements

Table 2-7 shows the requirements for VSS Instant Restore operations.

Table 2-7 Minimum hardware requirements for VSS Instant Restore operations

For detailed information regarding current hardware product compatibility requirements, see the IBM TotalStorage Web site:

http://www-03.ibm.com/servers/storage

2.2 Back up to Tivoli Storage Manager storage versus back up