Preventive Service Planning
Abstract
This document details the Hardware & Software requirements for IBM Spectrum Protect™ Snapshot for Microsoft SQL Server 8.1.12 and Data Protection for Microsoft SQL Server 8.1.12.
Content
The following components share hardware and software requirements. The components are:
- IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12 --> which is part of the IBM Spectrum Protect Snapshot 8.1.12 product.
- Data Protection for Microsoft SQL Server 8.1.12 --> which is part of the IBM Spectrum Protect™ for Databases 8.1.12 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 Spectrum Protect Snapshot
- IBM Spectrum Protect for Databases
- Known Issues and Limitations
Software requirements
The following information describes the minimum operating system and software requirements when you use IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12 or Data Protection for Microsoft SQL Server 8.1.12.
Operating systems
IBM Spectrum 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.12 |
||||||
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 V8.1.7) |
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 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.
Note: When you use Server Core Mode a remote GUI configuration, is required to use all MMC GUI feature or function.
IBM Spectrum 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.12 |
||||||
Windows 8.1 Professional or Enterprise editions |
|||||||
Windows 10 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
IBM Spectrum Protect™ Snapshot for Microsoft SQL Server and Data Protection for Microsoft SQL Server |
|||||||
---|---|---|---|---|---|---|---|
Application (64-bit) | Release 8.1 Latest fix pack 8.1.12 |
||||||
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 V8.1.4) |
||||||
Microsoft SQL Server 2019 Standard, Enterprise, and Developer editions |
(Beginning with V8.1.9) |
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 Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12 or Data Protection for Microsoft SQL Server 8.1.12:- 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 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 by using msiexec. In that scenario, you must manually ensure that the prerequisites are installed.
- 64-bit IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12
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 - 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 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 - 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.
- 32-bit Microsoft Visual C++ 2012 Redistributable Package
More required components
IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12 requires the following components:
- IBM Spectrum Protect Snapshot MMC Snap-in and Base System Services 8.1.12
Note: This is a component included in the IBM Spectrum Protect Snapshot on Windows 8.1.12 package. - IBM Spectrum Protect Snapshot VSS Requestor 8.1.12
Note: This is a component included in the IBM Spectrum Protect Snapshot on Windows 8.1.12 package. It is also known as the IBM Spectrum Protect backup-archive client 8.1.12.
Data Protection for Microsoft SQL Server 8.1.12 requires the following component:
- IBM Spectrum Protect backup-archive client 8.1.12, and later 8.1.x maintenance levels, new releases, and new versions
Note: 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.
More software requirements
The following software is required for storage of backups in an IBM Spectrum Protect Server:
- The IBM Spectrum Protect API client 8.1.12, and later 8.1.x maintenance levels, new releases, and new versions
Note: The IBM Spectrum Protect API version 8.1.12 is included and automatically installed with
- Data Protection for Microsoft SQL Server 8.1.12.
- IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12.
Note: 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 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.
Note: IBM Spectrum 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:
- IBM Spectrum Protect Snapshot is documented here: IBM Spectrum Protect Snapshot and Tivoli Storage FlashCopy Manager Virtualization Support
- IBM Spectrum Protect for Databases: Data Protection for Microsoft SQL Server is documented here: IBM Spectrum Protect and IBM Tivoli Storage Manager (TSM) guest support for Virtual Machines and Virtualization
Hardware requirements
Component | Minimal requirement |
System | Compatible hardware supported by the operating system and the Microsoft SQL Server |
Disk space |
|
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.
Note: 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. |
IBM Spectrum Protect Snapshot
Where to download IBM Spectrum Protect Snapshot
The IBM Spectrum Protect Snapshot download document provides information about how and where to obtain the IBM Spectrum Protect Snapshot V8.1.12 packages, see Download Information: Version 8.1.12 IBM Spectrum Protect SnapshotNote: The IBM Spectrum Protect Snapshot for Microsoft SQL Server 8.1.12 component is located in the IBM Spectrum Protect Snapshot 8.1.12 for Windows download image.
Hardware and software requirements for other components of IBM Spectrum Protect Snapshot
The hardware & software requirements for the other components that are part of IBM Spectrum Protect Snapshot 8.1.12 are located in the website: Hardware and Software Requirements: Version 8.1.12 IBM Spectrum Protect Snapshot
Hardware and software requirements for other releases of IBM Spectrum Protect Snapshot
The hardware and software requirements for other releases and fix packs for all IBM Spectrum Protect Snapshot components are located in the website: IBM Spectrum Protect Snapshot - All Requirements Documents
IBM Spectrum Protect for Databases
Where to download IBM Spectrum Protect for Databases
The IBM Spectrum Protect for Databases download document provides information about how and where to obtain the IBM Spectrum Protect for Databases V8.1.12 packages, see Download Information: Version 8.1.12 IBM Spectrum Protect™ for DatabasesNote: The Data Protection for Microsoft SQL Server 8.1.12 component is located in IBM Spectrum Protect for Databases 8.1.12.
Hardware and Software requirements for other releases of IBM Spectrum Protect for Databases
The hardware and software requirements for other releases and fix packs for all IBM Spectrum Protect for Databases components are located in the website: IBM Spectrum Protect™ for Databases - All Requirements Documents .
Known Issues and Limitations
The known issues and limitations in all 8.1.x levels of IBM Spectrum Protect Snapshot for Microsoft SQL Server and in all 8.1.x levels of IBM Spectrum Protect for Databases: Data Protection for Microsoft SQL Server are located in the website: Known Issues and Limitations: Version 8.1.x IBM Spectrum Protect™ Snapshot for Microsoft SQL & Version 8.1.x Data Protection for Microsoft SQL .
Related Information
Was this topic helpful?
Document Information
Modified date:
01 February 2022
UID
ibm16440969