Tivoli® Storage
Manager FastBack provides
enhanced backup and restore capabilities for Microsoft SQL Server 2000, 2005, and 2008
Standard Edition, and SQL Server 2012 Enterprise Edition databases
and transaction logs without compromising either data integrity or
performance of online operations.
Important: For SQL Server 2012 support,
you must add the NT AUTHORITY\SYSTEM login as a member of the sysadmin server
role. Also, only stand-alone SQL Server is supported; AAG (AlwaysOn
Availability Group) enabled is not supported.
For SQL Server 2012 support,
you must add the NT AUTHORITY\SYSTEM login as a member of the sysadmin server
role. Also, only stand-alone SQL Server is supported; AAG (AlwaysOn
Availability Group) enabled is not supported.The following list details the support that
is offered for Standard Editions of Microsoft SQL Server 2000, 2005, 2008,
and 2012 databases and transaction logs:
- Transparent integration with the SQL server by using an SQL native API for the backup task.
- Volume Shadow Copy (VSS) service, a type of application quiescing, for SQL Server 2005 and SQL Server 2008 on Windows Server 2003 and Windows Server 2008. You cannot use a VSS quiescing application to back up utility partitions. If you need an application-aware snapshot, do not use VSS application quiescing.
- IBM® application quiescing for SQL Server 2000 installed on Windows Server 2000 and Windows Server 2003.
- Back up and restore of SQL databases that are on a single volume, or are spanned over multiple volumes.
- Back up and restore of SQL databases that contain multiple data files or multiple log files.
- Back up of multiple databases simultaneously, without interruption to SQL server operation.
- Real-time restore for tables, views, and other SQL elements by using FastBack Mount. You can mount virtual volume with backed up database and recover all that you need without restoring the volume to disk.
- Tivoli Storage Manager FastBack supports named instances, however, named instances are not displayed in FastBack Manager. Non-named instances are displayed in FastBack Manager.
The following points relate to Recovery Model support:
- Tivoli Storage Manager FastBack supports backup by using the Simple Recovery Model. If a database is marked as Full Recovery Model, the database is backed up, but the logs are not purged.
- Named instances are not displayed in FastBack Manager.
Supported SQL versions
The
following SQL versions are supported:
- Microsoft SQL Server 2000 Standard Edition - On Windows 2003.
- Microsoft SQL Server 2000 Enterprise Edition with Service Pack 2 and later - On Windows 2000 Server with Service Pack 4 or Windows 2003 Enterprise.
- Microsoft SQL Server 2005 Standard Edition (32 bit and 64 bit).
- Microsoft SQL Server 2005 Enterprise Edition (32 bit and 64 bit).
- Microsoft SQL Server 2008 Standard Edition (32 bit and 64 bit).
- Microsoft SQL Server 2008 Enterprise Edition (32 bit and 64 bit).
- Microsoft SQL
Server 2012 Enterprise Edition (64 bit) - On Windows 2008 Server R2
or Windows 2012 Server R2.
If both Microsoft Exchange Server and Microsoft SQL Server are concurrently installed on the same computer, you must create a dedicated policy to individually back up each server.
The following
table summarizes the best practices that regard how to use the VSS
service and SQL scripts on various operating systems and SQL servers:| SQL Server 2000 | SQL Server 2005 | SQL Server 2008 | SQL Server 2012 | |||||
| Default | Named Instances | Default | Named Instances | Default | Named Instances | Default | Named Instances | |
| Windows 2000 | FastBack Client Application Quiescing | XRSQL Scripts | - | - | - | - | - | - |
| Windows 2003 | FastBack Client Application Quiescing | XRSQL Scripts | VSS service | VSS service | VSS service | VSS service | - | - |
| Windows 2003 64 bit | - | - | VSS service | VSS service | VSS service | VSS service | - | - |
| Windows 2008 64 bit | - | - | VSS service | VSS service | VSS service | VSS service | VSS Service | VSS Service |
| Windows 2012 R2 64 bit | - | - | - | - | - | - | VSS Service | VSS Service |
If you run the supported SQL Server 2000 software, use the IBM application quiescing and back up both data and log files. If you run named instances, use scripts to back up.
Tivoli Storage
Manager FastBack can
also back up the SQL Server in a Microsoft Cluster
Server environment. The FastBack Client must
be installed on all nodes in the cluster. The following table provides
you with an environment support matrix:
Both snapshot and CDP are supported for the SQL Server, both
named and non-named instances.
| Windows Server 2003 Cluster Server (32 bit) | Windows Server 2003 Cluster Server (64 bit) | Windows Server 2008 Cluster Server (64 bit) | Veritas Cluster Server / Windows Server 2003 (32 bit) | Veritas Cluster Server / Windows Server 2003 (64 bit) | |
|---|---|---|---|---|---|
| Microsoft SQL Server 2000 | Yes | SQL 2000 only available on Itanium processors | No | No | No |
| Microsoft SQL Server 2005 (32 bit) | Yes | No | Yes | No | No |
| Microsoft SQL Server 2005 (64 bit) | No | Yes | Yes | No | No |
| Microsoft SQL Server 2008 (32 bit) | Yes | No | No | No | No |
| Microsoft SQL Server 2008 (64 bit) | No | No | No | No | No |