Preventive Service Planning
Abstract
This document details the hardware & software requirements for IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 and Data Protection for Microsoft SQL Server 8.1.24.
Content
The following components share hardware and software requirements. The components are:
- IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 --> which is part of the IBM Storage Protect Snapshot 8.1.21 product.
- Data Protection for Microsoft SQL Server 8.1.24 --> which is part of the IBM Storage Protect™ for Databases 8.1.24 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.
- Software requirements
- Hardware requirements
- IBM Storage Protect Snapshot
- IBM Storage Protect for Databases
- Known Issues and Limitations
Note:
- IBM Storage Protect Snapshot and IBM Storage Protect for Databases support for third-party operating systems, applications, services, and hardware depend on the respective vendor. If a third-party product or version moves into extended support, self-service support, or end-of-life, IBM Storage Protect Snapshot and IBM Storage Protect for Databases supports the product or version at the same level as the vendor. See also IBM Support General Guidelines and Limitations - IBM support for software on unsupported operating systems
- The product now known as IBM Storage Protect was named IBM Spectrum Protect in levels earlier than 8.1.21. To learn more about the brand change, see IBM Spectrum brand change to IBM Storage.
The following information describes the minimum operating system and software requirements when you use IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 or Data Protection for Microsoft SQL Server 8.1.24.
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.24 |
||||||
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.
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.24 |
||||||
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.
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.24 |
||||||
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.
- 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.21 or Data Protection for Microsoft SQL Server 8.1.24:- 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
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.24
Note: Also, review the information documented in the preceding section: Microsoft prerequisites.- 32-bit Microsoft Visual C++ 2017 Redistributable Package
Available in the following subdirectory of the installation image (DVD or downloaded image):
fcm\x64\mmc\81240\enu\ISSetupPrerequisites\{29AE0051-88F8-4ED7-A6F9-7EA37A6B11A4}\vc_redist.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\81240\nu\ISSetupPrerequisites\{915387C3-E260-4985-861D-E7A891A4F74B}\vc_redist.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® REPORT VIEWER 2015 RUNTIME
Available in the following subdirectory of the installation image (downloaded image):
fcm\x64\mmc\81240\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\81240\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 System CLR Types 12.0.2000.8 (x64)\SQLSysClrTypes.msi
fcm\x64\mmc\81240\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\81240\enu\ISSetupPrerequisites\Microsoft SQL Server 2014 Management Objects 12.0.2000.8 (x64)\SharedManagementObjects.msi
fcm\x64\sql\81240\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\81240\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2014 12.0.2000.8 (x64)\PowerShellTools.msi
\fcm\x64\sql\81240\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\81240\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 System CLR Types 13.0.1601.5 (x64)\SQLSysClrTypes.msi
fcm\x64\mmc\81240\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\81240\enu\ISSetupPrerequisites\Microsoft SQL Server 2016 Management Objects 13.0.1601.5 (x64)\SharedManagementObjects.msi
fcm\x64\sql\81240\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\81240\enu\ISSetupPrerequisites\Windows PowerShell Extensions for SQL Server 2016 13.0.1601.5 (x64)\PowerShellTools.msi
\fcm\x64\sql\81240\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.
- 32-bit Microsoft Visual C++ 2017 Redistributable Package
IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 requires the following components:
- IBM Storage Protect Snapshot MMC Snap-in and Base System Services 8.1.21
Note: This component is included in the IBM Storage Protect Snapshot on Windows 8.1.21 package. - IBM Storage Protect Snapshot VSS Requestor 8.1.21
Note: This component is included in the IBM Storage Protect Snapshot on Windows 8.1.21 package. It is also known as the IBM Storage Protect backup-archive client 8.1.21.
Data Protection for Microsoft SQL Server 8.1.24 requires the following component:
- IBM Storage Protect backup-archive client 8.1.24, 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.
The following software is required for storage of backups in an IBM Storage Protect Server:
- The IBM Storage Protect API client 8.1.24, and later 8.1.x maintenance levels, new releases, and new versions
Note: The IBM Storage Protect API 8.1.24 is included and automatically installed with
- Data Protection for Microsoft SQL Server 8.1.24.
- IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21.
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.
Information regarding the virtualization environments supported by:
- IBM Storage Protect Snapshot is documented here: IBM Spectrum Protect Snapshot and Tivoli Storage FlashCopy Manager Virtualization Support.
- IBM Storage Protect for Databases: Data Protection for Microsoft SQL Server is documented here: IBM Spectrum Protect and IBM Tivoli Storage Manager guest support for virtual machines and virtualization.
The following information describes the minimum hardware and disk space requirements when you use IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 or Data Protection for Microsoft SQL Server 8.1.24.
Component | Minimal requirement |
---|---|
System | Compatible hardware supported by the operating system and the Microsoft SQL Server |
Disk space |
|
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. |
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.21 packages, see Download Information: IBM Storage Protect Snapshot 8.1.21.
Note: The IBM Storage Protect Snapshot for Microsoft SQL Server 8.1.21 component is located in the IBM Storage Protect Snapshot 8.1.21 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.21 are located in the website: Hardware and Software Requirements: IBM Storage Protect Snapshot 8.1.21.
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.24 packages, see Download Information: IBM Storage Protect for Databases 8.1.24.
Note: The Data Protection for Microsoft SQL Server 8.1.24 component is located in IBM Storage Protect for Databases 8.1.24.
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.
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.
Related Information
Was this topic helpful?
Document Information
Modified date:
27 September 2024
UID
ibm17169564