IBM Support

Hardware and Software Requirements: IBM Storage Protect Snapshot for SQL Server 8.1.19 and Data Protection for Microsoft SQL Server 8.1.19

Preventive Service Planning


Abstract

This document details the hardware & software requirements for IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 and Data Protection for Microsoft SQL Server 8.1.19.

Content

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

  • IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 --> which is part of the IBM Storage Protect Snapshot 8.1.19 product.
  • Data Protection for Microsoft SQL Server 8.1.19 --> which is part of the IBM Storage Protect™ for Databases 8.1.19 product.


This document is divided into linked sections for ease of navigation. Use the following links to jump to the section of the document that you require.
 


 

Note: The product now known as IBM Storage Protect was named IBM Spectrum Protect in levels earlier than 8.1.19. To learn more about the brand change, see IBM Spectrum brand change to IBM Storage.



 

Software requirements

The following information describes the minimum operating system and software requirements when you use IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 or Data Protection for Microsoft SQL Server 8.1.19.
 

Operating systems

Table 1. Operating system support on Windows x64.
IBM Storage Protect™ Snapshot for Microsoft SQL Server and Data Protection for Microsoft SQL Server
Operating systems (64-bit) Release 8.1
Latest fix pack 8.1.19
Windows Server 2012*
Essentials, Standard, or Datacenter editions		 ✔
Windows Storage Server 2012
Workgroup or Standard editions		 ✔
Windows Server 2012 R2*
Essentials, Standard, or Datacenter editions		 ✔
Windows Storage Server 2012 R2
Workgroup or Standard editions		 ✔
Windows Server 2016*
Essentials, Standard, or Datacenter editions		 ✔
Windows Server 2019*
Essentials, Standard, or Datacenter editions		 ✔(Beginning with 8.1.7)
Windows Server 2022*
Essentials, Standard, or Datacenter editions		 ✔(Beginning with 8.1.13)

✔ Indicates supported operating system. Later maintenance and modification levels to the operating system version are also supported.
* Both Server (Core) and Server with Desktop experience are supported.

Note:

  • Windows Storage Server 2012 and 2012 R2 are only supported for functions that are also available and supported by the IBM Storage Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server components on Windows Server 2012 and 2012 R2 Editions.
  • When you use Server Core Mode a remote GUI configuration, is required to use all MMC GUI feature or function.

 
 
Table 2. Operating system support on Windows x64 but only with the Remote Management capabilities of the MMC GUI interface:
IBM Storage Protect™ Snapshot for Microsoft SQL Server and Data Protection for Microsoft SQL Server
Operating systems (64-bit) Release 8.1
Latest fix pack 8.1.19
Windows 8.1
Professional or Enterprise editions		 ✔
Windows 10
Professional or Enterprise editions		 ✔
Windows 11
Professional or Enterprise editions		 ✔

✔ Indicates supported operating system. Later service pack maintenance levels to the operating system version are also supported.

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


 

Applications

Table 3. Coverage matrix for supported applications
IBM Storage Protect™ Snapshot for Microsoft SQL Server and Data Protection for Microsoft SQL Server
Application (64-bit) Release 8.1
Latest fix pack 8.1.19
Microsoft SQL Server 2014
Standard. Business Intelligence, or Enterprise editions		 ✔
Microsoft SQL Server 2016
Standard, Enterprise, and Developer editions		 ✔
Microsoft SQL Server 2017
Standard, Enterprise, and Developer editions		 ✔(Beginning with 8.1.4)
Microsoft SQL Server 2019
Standard, Enterprise, and Developer editions		 ✔(Beginning with 8.1.9)
Microsoft SQL Server 2022
Standard, Enterprise, and Developer editions		 ✔(Beginning with 8.1.17.1)

 Indicates supported the application version. Later maintenance and modification levels to the operating system version also supported.


 

More software prerequisites

  • Microsoft prerequisites
    The following prerequisites from Microsoft are required and must be installed before you use IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 or Data Protection for Microsoft SQL Server 8.1.19:
    • 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 Storage Protect Snapshot for Microsoft SQL Server 8.1.19 or Data Protection for Microsoft SQL Server 8.1.19.

    Note: Installation of these prerequisites might require a system restart. To avoid a system restart, ensure that these prerequisites are installed before you start the IBM Storage 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 by using msiexec. In that scenario, you must manually ensure that the prerequisites are installed.
     
  • 64-bit IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19
    Note    : Also, review the information documented in the preceding section: Microsoft prerequisites.
     
    • 32-bit Microsoft Visual C++ 2012 Redistributable Package
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      TIVFCM_WIN\fcm\x64\mmc\8190\enu\ISSetupPrerequisites\{BF2F04CD-3D1F-444e-8960-D08EBD285C3F}
    • 64-bit Microsoft Visual C++ 2012 Redistributable Package
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      ...ISSetupPrerequisites\{3A3AF437-A9CD-472F-9BC9-8EDD7505A02}\vcredist_x64.exe
    • 32-bit Microsoft Visual C++ 2017 Redistributable Package
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\{29AE0051-88F8-4ED7-A6F9-7EA37A6B11A4}\vcredist_x86
    • 64-bit Microsoft Visual C++ 2017 Redistributable Package
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\mmc\8190\nu\ISSetupPrerequisites\{915387C3-E260-4985-861D-E7A891A4F74B}\vcredist_x64.exe
    • Microsoft .NET Framework 4.5 or any higher 4.x version
      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 SQL Server 2012 System CLR Types
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x64)\SQLSysClrTypes.msi
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2012 System CLR Types 11.0.2100.60 (x86)\SQLSysClrTypes.msi
      Note: This item is a prerequisite to using the ReportViewer 2012 Redistributable. This ReportViewer 2012 is delivered with IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.17.
    • MICROSOFT® REPORT VIEWER 2012 RUNTIME
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\Microsoft ReportViewer 2012 11.1.3010.3\ReportViewer.msi
    • MICROSOFT® REPORT VIEWER 2015 RUNTIME
      Available in the following subdirectory of the installation image (downloaded image):
      fcm\x64\mmc\81172\enu\ISSetupPrerequisites\{2A224B02-B9BD-474C-8F85-821ED1A1EB44}\ReportViewer.msi
    • Microsoft SQL Server 2014 System CLR Types
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x86)\SQLSysClrTypes.msi
      Note: This item is a prerequisite to using the ReportViewer 2015 Redistributable. This ReportViewer 2015 is delivered with IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.17.2 and later.
    • Microsoft SQL Server 2014 Management Objects
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x64)\SharedManagementObjects.msi
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x86)\SharedManagementObjects.msi
    • Windows PowerShell Extensions for SQL Server 2014
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      \fcm\x64\sql\8190\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2014 12.0.2000.8 (x64)\PowerShellTools.msi
      \fcm\x64\sql\8190\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2014 12.0.2000.8 (x86)\PowerShellTools.msi
    • Microsoft SQL Server 2016 System CLR Types
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 System CLR Types 13.0.1601.5 (x64)\SQLSysClrTypes.msi
      fcm\x64\mmc\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 System CLR Types 13.0.1601.5 (x86)\SQLSysClrTypes.msi
    • Microsoft SQL Server 2016 Management Objects
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 Management Objects 13.0.1601.5 (x64)\SharedManagementObjects.msi
      fcm\x64\sql\8190\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 Management Objects 13.0.1601.5 (x86)\SharedManagementObjects.msi
    • Windows PowerShell Extensions for SQL Server 2016
      Available in the following subdirectory of the installation image (DVD or downloaded image):
      \fcm\x64\sql\8190\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2016 13.0.1601.5 (x64)\PowerShellTools.msi
      \fcm\x64\sql\8190\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2016 13.0.1601.5 (x86)\PowerShellTools.msi
      Note: The CLR types, Management Objects, and Windows PowerShell Extensions for SQL Server 2017 are the same as for SQL Server 2016.


 

More required components

IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 requires the following components:
 

  • IBM Storage Protect Snapshot MMC Snap-in and Base System Services 8.1.19
    Note: This component is included in the IBM Storage Protect Snapshot on Windows 8.1.19 package.
  • IBM Storage Protect Snapshot VSS Requestor 8.1.19
    Note: This component is included in the IBM Storage Protect Snapshot on Windows 8.1.19 package. It is also known as the IBM Storage Protect backup-archive client 8.1.19.

Data Protection for Microsoft SQL Server 8.1.19 requires the following component:

  • IBM Storage Protect backup-archive client 8.1.19, and later 8.1.x maintenance levels, new releases, and new versions
    Note: It is a requirement of the IBM Storage Protect backup-archive client and the IBM Storage Protect API client that they remain in sync to the Version.Release.Modification level when used on the same Windows system.


 

More software requirements

The following software is required for storage of backups in an IBM Storage Protect Server:

  • The IBM Storage Protect API client 8.1.19, and later 8.1.x maintenance levels, new releases, and new versions
    Note: The IBM Storage Protect API 8.1.19 is included and automatically installed with
    - Data Protection for Microsoft SQL Server 8.1.19.
    - IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19.
    Note: It is a requirement of the IBM Storage Protect backup-archive client and the IBM Storage Protect API client that they remain in sync to the Version.Release.Modification level when used on the same Windows system
  • Any IBM Storage Protect Server currently in support, which is supported by the version of the IBM Storage Protect API Client, or IBM Storage Protect Backup-Archive Client, used in the environment.
    Note: IBM Storage Protect backup-archive client or API and Server compatibility information see: IBM Spectrum Protect Server-Client Compatibility and Upgrade Considerations.


 

Virtualization support

Information regarding the virtualization environments supported by:



 

Hardware requirements

The following information describes the minimum hardware and disk space requirements when you use IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 or Data Protection for Microsoft SQL Server 8.1.19.
 

Table 4. Minimum hardware requirements
Component Minimal requirement
System Compatible hardware supported by the operating system and the Microsoft SQL Server
Disk space
  • A minimum of 208 MB of disk space for the product to be installed.
  • At least 2.1 GB disk space for Microsoft prerequisites, which is installed automatically if they are not already installed on the system when you start the Data Protection for Microsoft SQL Server or IBM Storage Protect Snapshot for Microsoft SQL Server component installation.
    Note: Some of the prerequisites defined in this document might require a system restart. To avoid a system restart, ensure that all of the minimum software requirement prerequisites detailed in the " Microsoft prerequisites " section of this document are installed before you start the IBM Storage Protect Snapshot for Microsoft SQL Server or Data Protection for Microsoft SQL Server installation process.
Metadata space requirements (IBM Storage Protect Snapshot for Microsoft SQL Server only)
In addition to the space that is required for the global product installation, IBM Storage 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 Storage Protect Snapshot VSS Requestor component's installation directory.
Note: The IBM Storage Protect Snapshot VSS Requestor component is also known as the IBM Storage 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.



 

IBM Storage Protect Snapshot

Where to download IBM Storage Protect Snapshot

The IBM Storage Protect Snapshot download document provides information about how and where to obtain the IBM Storage Protect Snapshot 8.1.19 packages, see Download Information: IBM Storage Protect Snapshot 8.1.19.

Note: The IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.19 component is located in the IBM Storage Protect Snapshot 8.1.19 for Windows download image.


 

Hardware and software requirements for other components of IBM Storage Protect Snapshot

The hardware & software requirements for the other components that are part of IBM Storage Protect Snapshot 8.1.19 are located in the website: Hardware and Software Requirements: IBM Storage Protect Snapshot 8.1.19.


 

Hardware and software requirements for other releases of IBM Storage Protect Snapshot

The hardware and software requirements for other releases and fix packs for all IBM Storage Protect Snapshot components are located in the website: Requirements Documents: IBM Storage Protect Snapshot.



 

IBM Storage Protect for Databases

Where to download IBM Storage Protect for Databases

The IBM Storage Protect for Databases download document provides information about how and where to obtain the IBM Storage Protect for Databases 8.1.19 packages, see Download Information: IBM Storage Protect for Databases 8.1.19.

Note: The Data Protection for Microsoft SQL Server 8.1.19 component is located in IBM Storage Protect for Databases 8.1.19.


 

Hardware and Software requirements for other releases of IBM Storage Protect for Databases

The hardware and software requirements for other releases and fix packs for all IBM Storage Protect for Databases components are located in the website: Requirements Documents: IBM Storage Protect for Databases.



 

Known Issues and Limitations

The known issues and limitations in all 8.1.x levels of IBM Storage Protect Snapshot for Microsoft SQL Server and in all 8.1.x levels of IBM Storage Protect for Databases: Data Protection for Microsoft SQL Server are located in the website: Known Issues and Limitations: IBM Storage Protect Snapshot for Microsoft SQL 8.1.x and Data Protection for Microsoft SQL 8.1.x.
 



 

[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSCGRK","label":"IBM Storage Protect for Databases"},"ARM Category":[{"code":"a8m3p000000hAaIAAU","label":"Data Protection-\u003EMicrosoft SQL"},{"code":"a8m3p000000hBXtAAM","label":"Snapshot"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.19","Type":"MASTER"}]

Document Information

Modified date:
15 June 2023

UID

ibm16999627

Page Feedback