IBM Support

Hardware and Software Requirements: Version 4.1.4 IBM Spectrum Protect™ Snapshot for SQL Server & 7.1.4 Data Protection for Microsoft SQL Server

Preventive Service Planning


Abstract

This document details the Hardware & Software requirements for IBM Spectrum Protect™ Snapshot for Microsoft SQL Server 4.1.4 and Data Protection for Microsoft SQL Server 7.1.4.

Content


Tip: Beginning with Version 4.1.3, Tivoli Storage FlashCopy® Manager is now IBM Spectrum Protect™ Snapshot. Some applications such as the software fulfillment systems and IBM License Metric Tool use the new product name. However, the software and its product documentation continue to use the Tivoli Storage FlashCopy Manager product name. To learn more about the rebranding transition, see http://www.ibm.com/support/docview.wss?uid=swg21963634.


Tip: Beginning with Version 7.1.3, Tivoli Storage Manager for Databases is now IBM Spectrum Protect™ for Databases. Some applications such as the software fulfillment systems and IBM License Metric Tool use the new product name. However, the software and its product documentation continue to use the Tivoli Storage Manager for Databases product name. To learn more about the rebranding transition, see http://www.ibm.com/support/docview.wss?uid=swg21963634.

The following components share the same hardware and software requirements. The components are:

  • FlashCopy Manager for Microsoft SQL Server 4.1.4 --> which is part of the IBM Spectrum Protect Snapshot 4.1.4 product.
  • Data Protection for Microsoft SQL Server 7.1.4 --> which is part of the IBM Spectrum Protect™ for Databases 7.1.4 product.


This document is divided into linked sections for ease of navigation. You may use the links below to jump to the desired section of the document.

Minimum hardware requirements
Minimum software and operating system requirements
Additional Microsoft prerequisites
Additional components required
Additional requirements for storage of backups in an IBM Spectrum Protect or Tivoli Storage Manager Server

Virtualization support

Where to download IBM Spectrum Protect Snapshot 4.1.4

Links to the Hardware & Software requirements for the other components that are a part of IBM Spectrum Protect Snapshot 4.1.4

Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect Snapshot and its components

Links to the Known Issues and Limitations associated with IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.x and Data Protection for Microsoft SQL Server 7.1.x

Where to download IBM Spectrum Protect for Databases 7.1.4

Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect for Databases and its components



Minimum hardware requirements

The following information describes the minimum hardware and disk space requirements when using IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 or Data Protection for Microsoft SQL Server 7.1.4.


x86 Hardware

The following hardware is supported for the x86 platform:
  • Compatible hardware supported by the operating system and the Microsoft SQL Server


x86 Disk Space

The following disk space is required for the x86 platform:
  • A minimum of 208 MB of disk space for the product and language packs to be installed.
  • At least 1 GB disk space for "Additional Microsoft prerequisites" which will be installed automatically if they are not already installed on the system when starting the Data Protection for Microsoft SQL Server or FlashCopy Manager for Microsoft SQL Server component installation.


TIP: Some of the prerequisites defined in this document may require a system restart. To avoid a system restart, ensure that all of the minimum software requirement prerequisites detailed in the "Additional Microsoft prerequisites" section of this document are installed before starting the IBM Spectrum Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server installation process.

============================================================================


x64 Hardware

The following hardware is supported for the x64 platform:
  • Compatible hardware supported by the operating system and the Microsoft SQL Server


x64 Disk Space

The following disk space is required for the x64 platform:
  • A minimum of 208 MB of disk space for the product and language packs to be installed.
  • At least 2.1 GB disk space for "Additional Microsoft prerequisites" which will be installed automatically if they are not already installed on the system when starting the Data Protection for Microsoft SQL Server or FlashCopy Manager for Microsoft SQL Server component installation.


TIP: Some of the prerequisites defined in this document may require a system restart. To avoid a system restart, ensure that all of the minimum software requirement prerequisites detailed in the "Additional Microsoft prerequisites" section of this document are installed before starting the IBM Spectrum Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server installation process.

============================================================================


Metadata space requirements (IBM Spectrum Protect Snapshot for Microsoft SQL Server only)


In addition to the space that is required for the global product installation, IBM Spectrum Protect Snapshot uses disk space to hold vital product data that is used to track and manage snapshots. By default, the metadata is stored in the 'vss_staging' subdirectory of the IBM Spectrum Protect Snapshot VSS Requestor component's installation directory.

    TIP: The IBM Spectrum Protect Snapshot VSS Requestor component is also known as the IBM Spectrum Protect Backup-Archive Client.

The amount of space required is directly proportional to the number of snapshots that you maintain on the system. Ensure that there is at least 1 megabyte of available free disk space to hold the metadata for each snapshot that you plan to keep on the system.

============================================================================


Minimum software and operating system requirements

The following information describes the minimum operating system and software requirements when using IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 or Data Protection for Microsoft SQL Server 7.1.4.


Operating Systems


x86 Operating Systems

The following operating systems are supported for the x86 platform:
  • 32-bit Windows Server 2008 SP2, and later maintenance levels: Standard, Enterprise, or Datacenter editions

============================================================================


x64 Operating Systems

The following operating systems are supported for the x64 platform:
  • 64-bit Windows Server 2008 SP2, and later maintenance levels: Standard x64, Enterprise x64, or Datacenter x64, editions
  • 64-bit Windows Server 2008 R2 SP1, and later maintenance levels: Standard x64, Enterprise x64, or Datacenter x64, editions
  • 64-bit Windows Server 2012, and later maintenance levels: Essentials, Standard or Datacenter editions
  • 64-bit Windows Server 2012 R2, and later maintenance levels: Essentials, Standard or Data Center editions
  • 64-bit Windows Server 2012 R2, and later maintenance levels: Essentials, Standard or Datacenter editions
  • 64-bit Windows Storage Server 2012, and later maintenance levels: Workgroup or Standard editions.
  • 64-bit Windows Storage Server 2012 R2, and later maintenance levels: Workgroup or Standard editions.
      Note: Windows Storage Server 2012 and 2012 R2 are only supported for functionality that is also available and supported by the IBM Spectrum Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server components on Windows Server 2012 and 2012 R2 Editions.


The following additional operating systems are supported for the x64 platform but only with the Remote Management capabilities of the MMC GUI interface:
  • 64-bit Windows 7 SP1 and later Service Pack maintenance levels: Professional or Ultimate editions
  • 64-bit Windows 8 and later Service Pack maintenance levels: Professional or Enterprise editions
  • 64-bit Windows 8.1 and later Service Pack maintenance levels: Professional or Enterprise editions
  • 64-bit Windows 10 and later Service Pack maintenance levels: Professional or Enterprise editions

Note: Remote management capabilities of the MMC GUI interface are supported in an x64
based (64-bit) platform only.

============================================================================


Operating Environments are supported for both x86 and x64 platforms:
  • Windows Failover Clustering

============================================================================


Applications Supported


x86 Applications

The following application levels are supported for the x86 platform:
  • Microsoft SQL Server 2008 SP3, and later maintenance levels: Standard or Enterprise Editions
  • Microsoft SQL Server 2008 R2 SP2, and later maintenance levels: Standard or Enterprise Editions
  • Microsoft SQL Server 2012, and later maintenance levels: Standard, Business Intelligence, or Enterprise Editions
  • Microsoft SQL Server 2014, and later maintenance levels: Standard. Business Intelligence, or Enterprise Editions

============================================================================


x64 Applications

The following application levels are supported for the x64 platform:
  • Microsoft SQL Server 2008 SP3, and later maintenance levels: Standard x64 or Enterprise x64 Editions
  • Microsoft SQL Server 2008 R2 SP2, and later maintenance levels: Standard, Enterprise, or Data center Editions
  • Microsoft SQL Server 2012, and later maintenance levels: Standard, Business Intelligence, or Enterprise Editions
      Note: SQL Server 2012 on a Server Core installation of Windows Server 2008 R2 SP1 or Windows Server 2012 is supported.
  • Microsoft SQL Server 2014, and later maintenance levels: Standard. Business Intelligence, or Enterprise Editions

============================================================================


Additional Microsoft prerequisites

The following prerequisites from Microsoft are required and must be installed prior to using IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 or Data Protection for Microsoft SQL Server 7.1.4:
    • Windows Powershell 3 or Windows Powershell 4
    • Windows PowerShell 5 when used with Windows 10
    • Windows Management Framework 3 or Windows Management Framework 4
    • Windows Management Framework 5 when used with Windows 10


The following prerequisites from Microsoft are required, and are installed automatically by IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 or Data Protection for Microsoft SQL Server 7.1.4, if not already present on your machine.


TIP: Installation of these prerequisites may require a system restart. To avoid a system restart, ensure that these prerequisites are installed before starting the IBM Spectrum Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server installation process.

    Note: These prerequisites are not automatically installed when you create your own silent installation package to install via msiexec. In that scenario, you must manually ensure that the prerequisites are installed.




32-bit IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4


Note: Please also review the information documented in the preceding section: Additional Microsoft prerequisites



Microsoft SQL Server 2012 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x64)\SQLSysClrTypes.msi

    Note: This item is a prerequisite to using the ReportViewer 2012 Redistributable


Microsoft SQL Server 2014 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi


Microsoft SQL Server 2014 Management Objects

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x86)\SQLSysClrTypes.msi


Windows PowerShell Extensions for SQL Server 2014

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x86)\SharedManagementObjects.msi


---------------------------------------


32-bit Data Protection for Microsoft SQL Server 7.1.4


Note: Please also review the information documented in the preceding section: Additional Microsoft prerequisites



32-bit Microsoft Visual C++ 2012 Redistributable Package

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft Visual C++ 2012 Service Update 1 Runtime Libraries (x86)\vcredist_x86.exe


Microsoft .NET Framework 4.5

Available in the following subdirectory of the installation image (DVD or downloaded image):
.....ISSetupPrerequisites\{72D7E3D1-C9DF-4FA6-9F9B-4E5117AB2919}\dotNetFx45_Full_x86_x64.exe


Microsoft ReportViewer 2012 SP1 Redistributable

Available in the following subdirectory of the installation image (DVD or downloaded image):
... ISSetupPrerequisites\Microsoft ReportViewer 2012 11.1.3010.3\ReportViewer.msi


Microsoft SQL Server 2012 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x64)\SQLSysClrTypes.msi

    Note: This item is a prerequisite to using the ReportViewer 2012 Redistributable


Microsoft SQL Server 2014 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi


Microsoft SQL Server 2014 Management Objects

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x86)\SQLSysClrTypes.msi


Windows PowerShell Extensions for SQL Server 2014

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x86)\SharedManagementObjects.msi


---------------------------------------


64-bit IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4


Note: Please also review the information documented in the preceding section: Additional Microsoft prerequisites



Microsoft SQL Server 2012 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x64)\SQLSysClrTypes.msi

    Note: This item is a prerequisite to using the ReportViewer 2012 Redistributable


Microsoft SQL Server 2014 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi


Microsoft SQL Server 2014 Management Objects

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x86)\SQLSysClrTypes.msi


Windows PowerShell Extensions for SQL Server 2014

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x86)\SharedManagementObjects.msi


---------------------------------------


64-bit Data Protection for Microsoft SQL Server 7.1.4


Note: Please also review the information documented in the preceding section: Additional Microsoft prerequisites



32-bit Microsoft Visual C++ 2012 Redistributable Package

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft Visual C++ 2012 Service Update 1 Runtime Libraries (x86)\vcredist_x86.exe


64-bit Microsoft Visual C++ 2012 Redistributable Package

Available in the following subdirectory of the installation image (DVD or downloaded image):
.....ISSetupPrerequisites\Microsoft Visual C++ 2012 Service Update 1 Runtime Libraries (x64)\vcredist_x64.exe


Microsoft .NET Framework 4.5

Available in the following subdirectory of the installation image (DVD or downloaded image):
.....ISSetupPrerequisites\{72D7E3D1-C9DF-4FA6-9F9B-4E5117AB2919}\dotNetFx45_Full_x86_x64.exe


Microsoft ReportViewer 2012 SP1 Redistributable

Available in the following subdirectory of the installation image (DVD or downloaded image):
... ISSetupPrerequisites\Microsoft ReportViewer 2012 11.1.3010.3\ReportViewer.msi


Microsoft SQL Server 2012 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x64)\SQLSysClrTypes.msi

    Note: This item is a prerequisite to using the ReportViewer 2012 Redistributable


Microsoft SQL Server 2014 System CLR Types

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi


Microsoft SQL Server 2014 Management Objects

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x86)\SQLSysClrTypes.msi


Windows PowerShell Extensions for SQL Server 2014

Available in the following subdirectory of the installation image (DVD or downloaded image):
....ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x86)\SharedManagementObjects.msi

============================================================================


Additional components required


IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 requires the following components:
  • IBM Spectrum Protect Snapshot MMC Snapin and Base System Services 4.1.4
      Note: This is a component included in the IBM Spectrum Protect Snapshot on Windows 4.1.4 package.

  • IBM Spectrum Protect Snapshot VSS Requestor 4.1.4
      Note: This is a component included in the IBM Spectrum Protect Snapshot on Windows 4.1.4 package. It is also known as the IBM Spectrum Protect Backup-Archive Client 7.1.4

============================================================================


Data Protection for Microsoft SQL Server 7.1.4 requires the following component:
  • IBM Spectrum Protect Backup-Archive Client 7.1.4 and later 7.1.x maintenance levels, new releases, and new versions
      TIP: It is a requirement of the IBM Spectrum Protect Backup-Archive Client and the IBM Spectrum Protect API client that they remain in sync to the Version.Release.Modification level when used on the same Windows system.

============================================================================


Additional requirements for storage of backups in an IBM Spectrum Protect or Tivoli Storage Manager Server
  • The IBM Spectrum Protect API Client 7.1.4, and later 7.1.x maintenance levels, new releases, and new versions
      Note: The IBM Spectrum Protect API Version 7.1.4 is included and automatically installed with Data Protection for Microsoft SQL Server 7.1.4.

      Note: The IBM Spectrum Protect API Version 7.1.4 is included and automatically installed with IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4.

      TIP: It is a requirement of the IBM Spectrum Protect Backup-Archive Client and the IBM Spectrum Protect API client that they remain in sync to the Version.Release.Modification level when used on the same Windows system

  • Any Tivoli Storage Manager or IBM Spectrum Protect Server currently in support which is supported by the version of the IBM Spectrum Protect API Client, or IBM Spectrum Protect Backup-Archive Client, used in the environment.



    • TIP: IBM Spectrum Protect Client/API and Server compatibility information is located in the IBM Tivoli Storage Manager Server/Client Compatibility and Upgrade Considerations tech note located here: http://www.ibm.com/support/docview.wss?uid=swg21053218

============================================================================


Virtualization support

Information regarding the virtualization environments supported by IBM Spectrum Protect Snapshot is documented here: http://www.ibm.com/support/docview.wss?uid=swg21433737

Information regarding the virtualization environments supported by IBM Spectrum Protect for Databases: Data Protection for Microsoft SQL Server is documented here:
http://www.ibm.com/support/docview.wss?&uid=swg21239546

============================================================================


Where to download IBM Spectrum Protect Snapshot 4.1.4

The IBM Spectrum Protect Snapshot 4.1.4 download document provides information about how and where to obtain the IBM Spectrum Protect Snapshot for Windows 4.1.4 packages. The information is located at: http://www.ibm.com/support/docview.wss?uid=swg24041139

TIP: The IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.4 component is located in the IBM Spectrum Protect Snapshot 4.1.4 for Windows download image.

============================================================================


Links to the Hardware & Software requirements for the other components that are a part of IBM Spectrum Protect Snapshot 4.1.4

Links to the Hardware & Software requirements for the other components that are part of IBM Spectrum Protect Snapshot 4.1.4 are located at: http://www.ibm.com/support/docview.wss?uid=swg21971752

============================================================================


Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect Snapshot and its components

Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect Snapshot, and its components, are located in the "All Requirements Doc" located at: http://www.ibm.com/support/docview.wss?uid=swg21427692

============================================================================


Links to the Known Issues and Limitations associated with IBM Spectrum Protect Snapshot for Microsoft SQL Server 4.1.x and Data Protection for Microsoft SQL Server 7.1.x

The Known Issues & Limitations tech notes describe known issues and limitations in all 4.1.x levels of IBM Spectrum Protect Snapshot for Microsoft SQL Server and in all 7.1.x levels of IBM Spectrum Protect for Databases: Data Protection for Microsoft SQL Server.

This information is located at: http://www.ibm.com/support/docview.wss?uid=swg21644478

============================================================================

Where to download IBM Spectrum Protect for Databases 7.1.4

The IBM Spectrum Protect for Databases: Data Protection for Microsoft SQL Server download document provides information about how and where to obtain the IBM Spectrum Protect for Databases 7.1.4 packages. The information is located at: http://www.ibm.com/support/docview.wss?uid=swg24041411

TIP: The Data Protection for Microsoft SQL Server 7.1.4 component is located in IBM Spectrum Protect for Databases 7.1.4.

============================================================================

Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect for Databases and its components

Links to the Hardware & Software requirements for other releases of IBM Spectrum Protect for Databases, and its components, are located in the "All Requirements Doc" located at: http://www.ibm.com/support/docview.wss?uid=swg21218747

============================================================================

[{"Product":{"code":"SSERFV","label":"IBM Spectrum Protect Snapshot"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"FlashCopy Manager for Microsoft SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1.4","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for MS SQL","Platform":[{"code":"","label":""}],"Version":"7.1.4","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
01 February 2022

UID

swg21972697

Page Feedback