Perform these tasks to verify your

Before attempting to perform a backup or restore operation, it is recommended that you verify that Data Protection for SQL is installed and configured correctly.

Manually verifying the installation and configuration of Data

Protection for SQL from the command line

You can issue query commands at the command line to verify the installation and configuration.

1. ClickStart >All Programs>Tivoli Storage Manager>Data Protection for Microsoft SQL Server>SQL Client - Command Line.

2. Enter the following commands:

tdpsqlc query tdp tdpsqlc query tsm tdpsqlc query sql

The Data Protection for SQL Server configuration has been verified when these commands complete without errors or warnings.

Verify that a SQL Server is ready to perform VSS operations

Perform the following tests to verify that your SQL Server is ready to perform VSS operations. For best results, perform these tests prior to installing Tivoli Storage Manager.

After all of these tests complete without errors, you are ready for the Tivoli Storage Manager component installations. For Windows 2003, before issuing theVSHADOW

commands you must download the VShadow tool. For Windows 2008 and later, the DiskShadow tool is preloaded. You can run the VSHADOWcommands, but you must download the VShadow tool in order to run them.

Using the VSHADOW command (Windows 2003)

1. Test the creation and the deletion of a non-persistent shadow copy: a. From the command line, issue the Microsoft Windows VSHADOW

command:

VSHADOW k: l:

where the variable "k:" is the SQL Server database volume and the variable "l:" is the SQL Server log volume.

b. Repeat the preceding step four times.

2. Test the creation and the deletion of a persistent shadow copy:

a. From the command line, issue the Microsoft Windows VSHADOW command:

VSHADOW -p k: l:

where the variable "k:" is the SQL Server database volume and the variable "l:" is the SQL Server log volume.

Important: If you do not have enough space to run the command, you might want to delete shadow copies on the server. To deleteall shadow copies on a server, issue the Microsoft Windows

VSHADOW command: VSHADOW -da b. Repeat the preceding step four times.

c. Verify that the Windows Event Log contains no errors.

3. If you want to perform OFFLOAD VSS Backup operations, test the creation and the deletion of a non-persistent transportable shadow copy (VSS Hardware Provider environments only):

a. From the command line, issue the Microsoft Windows VSHADOW command:

VSHADOW -t=export.xml k: l:

where the variable "k:" is the SQL Server database volume and the variable "l:" is the SQL Server log volume.

b. On the server that you have designated for offloaded backup, from a command-line prompt, issue the Microsoft Windows VSHADOW command as follows:

VSHADOW -i=export.xml

c. Verify that the Windows Event Log contains no errors.

Using the DISKSHADOW command (Windows 2008 and later)

Before installing Data Protection for Microsoft SQL Server, it is highly recommended that you test core VSS functionality first. VSS functionality can be validated with the Windows 2008 Server-embedded command DISKSHADOW. DISKSHADOW is available for Windows Server 2008 and Windows Server 2008 R2. The following are the DISKSHADOW tests that are recommended before any Tivoli Storage Manager components are installed.

1. Test non-persistent shadow copy creation and deletion. Rundiskshadow in a command window and enter the following commands:

DISKSHADOW>begin backup

DISKSHADOW>add volume f: (Database volume) DISKSHADOW>add volume g: (Log volume) DISKSHADOW>create

DISKSHADOW>end backup

DISKSHADOW>list shadows all (this may take a few minutes) DISKSHADOW>delete shadows all

Note: Volumes f:andg:represent the SQL Database and log volumes. Repeat this sequence of commands 4 times. Verify the Windows Event Log contains no errors.

2. Test persistent shadow copy creation and deletion. Rundiskshadowin a command window and enter the following commands:

DISKSHADOW>set context persistent DISKSHADOW>begin backup

DISKSHADOW>add volume f: (Database volume) DISKSHADOW>add volume g: (Log volume) DISKSHADOW>create

DISKSHADOW>end backup

DISKSHADOW>list shadows all (This may take a few minutes) DISKSHADOW>delete shadows all

Note: Volumesf:andg:represent the SQL Database and log volumes. Repeat this sequence of commands 4 times. Verify the Windows Event Log contains no errors.

3. Test Non-persistent transportable shadow copy creation and deletion. Rundiskshadowin a command window and enter the following commands:

DISKSHADOW>set context persistent DISKSHADOW>set option transportable DISKSHADOW>begin backup

DISKSHADOW> add volume f: (Database volume) DISKSHADOW> add volume g: (Log volume)

DISKSHADOW>set metadata c:\metadata\sqlmeta.cab (specify the path where you want the metadata stored)

DISKSHADOW> create DISKSHADOW>end backup

Manually copy thesqlmeta.cabfile from the source server to the offload server and run the following commands:

DISKSHADOW>LOAD METADATA path to sqlmeta.cab

DISKSHADOW>IMPORT

DISKSHADOW>list shadows all (This can take a few minutes) DISKSHADOW>delete shadows all

Note: Volumesf:andg:represent the SQL Database and log volumes. Repeat this sequence 4 times. Verify the Windows Event Log contains no errors.

After the tests complete satisfactorily, you can install Tivoli Storage Manager components.

Diagnose the cause of common errors returned from VSS

operations

Note that the following two errors are commonly returned when performing a VSS operation. Information is provided to help locate the cause of the error.

ANS1017E (RC-50) Session rejected: TCP/IP connection failure

This is displayed when the Tivoli Storage Manager backup-archive client CAD is either not running or is not configured properly.

ANS1532E (RC5722) Proxy Rejected: Proxy authority has not been granted to this node. This is displayed when the Tivoli Storage Manager server has not been