Using the Tivoli Storage Manager scheduler

This section provides an example of how to use the Tivoli® Storage Manager scheduler with Data Protection for SQL Server to automate online backups of SQL Server databases. This scenario illustrates the use of the Tivoli Storage Manager scheduler and creating a full backup of your SQL databases.

  1. Verify the latest Tivoli Storage Manager backup-archive client version is installed.
  2. Register Data Protection for SQL Server to a Tivoli Storage Manager server and installed on the SQL Server.
  3. (SQL 2012 AlwaysOn Availability Groups and stand-alone database only) Complete the following procedure to change the log on account. By default, the domain account is not set. If you do not complete this procedure, the scenario cannot be successfully completed because a permission error occurs.
    1. Right click to select Computer > Manage > Service.
    2. Right click to select TSM TDPSQL scheduler service > Properties.
    3. Navigate to the Log on tab.
    4. Change Local System account to This account. Enter the domain account information.
    5. Save the changes.
  4. On the Tivoli Storage Manager server:
    1. Define a schedule to run a Windows command file. This schedule must be defined in the policy domain to which Data Protection for SQL Server is registered.
    2. Associate the Data Protection for SQL Server node to the defined schedule.
  5. On the system where the SQL Server and Data Protection for SQL Server are installed:
    1. Install the Tivoli Storage Manager server scheduler client as a Windows service for Data Protection for SQL. If a scheduler exists for the regular Tivoli Storage Manager backup client, install another one for Data Protection for SQL.
    2. Define a command file that contains the Data Protection for SQL commands to do the desired backup. For more information about creating a Windows command file, see the Windows documentation.
    3. If you are running in a SQL Server Failover Cluster environment:
      1. Install the Tivoli Storage Manager server scheduler client as a Windows service on both cluster nodes.
      2. Create a cluster resource that represents the Tivoli Storage Manager scheduler. Verify that the cluster resource is started. This service is dependent on the SQL Server cluster resource.
    4. Start the scheduler.