Tivoli® Storage
Manager FastBack provides
enhanced backup and restore capabilities for Microsoft SQL Server 2000, 2005, and 2008
Standard Edition databases and transaction logs, without compromising
either data integrity or performance of online operations.
The following list details the support that
is offered for Standard Editions of Microsoft SQL Server 2000, 2005, and 2008
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 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 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).
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:
Table 1. Using the VSS
service and SQL scripts on operating systems and SQL Servers| |
SQL Server 2000 |
|
SQL Server 2000 |
|
SQL Server 2000 |
|
|---|
| |
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 |
|---|
If you run the supported SQL Server 2005 software, select
both log and data volumes, and select VSS application quiescing, the
backup works.
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:
Table 2. Environment support matrix for SQL Servers in Cluster Server
environments| |
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 |
Both snapshot and CDP are supported for the SQL Server, both
named and non-named instances.