TDP - Installing Storage Manager for Databases (Microsoft SQL Server)

Planning

1. Determine your backup strategy.
   1. VSS Backups (Full backup only)
   2. Legacy Backups (Full/Differential/Logs)

Server Preparation

1. Two nodes must be registered, the node that will be used for the Backup/Archive Client, and one for TDP.
2. Register the Backup/Archive node.
   1. tsm> REGister Node <hostname/clustered name> <password> DOmain=<domain> CONtact=<contact info>
3. Register the Data Protection node.
   1. tsm> REGister Node <hostname/clustered name>-TDP <password> DOmain=<domain> CONtact=<contact info>
4. Create the proxy access for the agent.
   1. tsm> GRANT PROXynode TArget=<hostname/clustered name>-TDP AGent=<hostname/clustered name>
5. Backup Strategy
   1. If the path to the schedule includes a space, use the MS-DOS naming convention such as C:\Program Files would be C:\PROGRA~1
   2. Legacy Backups
      1. Create the full backup client schedule.
         1. tsm> DEFine SCHedule <domain> TDP-MSSQL-FULL Type=Client DESCription="TDP for MSSQL Full Backup" ACTion=Command OBJects="<C:\path\to\sqlfull.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=Enhanced DAYofweek=<day>
      2. Create the differential backup client schedule.
         1. tsm> DEFine SCHedule <domain> TDP-MSSQL-DIFF Type=Client DESCription="TDP for MSSQL Differental Backup" ACTion=Command OBJects="<C:\path\to\sqldiff.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=Enhanced DAYofweek=<day,day,day,...>
      3. Create the log backup client schedule.
         1. tsm> DEFine SCHedule <domain> TDP-MSSQL-LOGS Type=Client DESCription="TDP for MSSQL Log Backup and Truncation" ACTion=Command OBJects="<C:\path\to\sqllogs.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=Classic PERiod=4 PERUnits=Hours DAYofweek=ANY
   3. VSS Backups
      1. Create the full backup client schedule.
         1. tsm> DEFine SCHedule <domain> TDP-MSSQL-VSS Type=Client DESCription="TDP for MSSQL VSS Backup" ACTion=Command OBJects="<C:\path\to\sqlvss.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=Classic PERiod=1 PERUnits=Days DAYofweek=ANY

TDP Client Installation

1. Install the Tivoli Backup/Archive Client before proceeding.
2. Install the Data Protection for SQL Server.
   1. Execute the setupfcm.exe program.
3. Follow the instructions to complete the installation.

TDP Client Configuration

1. Start the TDP MMC.
   1. Start > All Programs > Tivoli Storage Manager > Data Protection for Microsoft SQL Server > DP for SQL Management Console
2. Expand: IBM Tivoli Storage Manager->Dashboard->Manage
3. Click: Configuration
4. Double click: Wizards
5. Double click: TSM Configuration
6. Restart the system.

TDP Client Verification

1. Start the TDP MMC.
   1. Start > All Programs > Tivoli Storage Manager > Data Protection for Microsoft SQL Server > DP for SQL Management Console
2. Expand: IBM Tivoli Storage Manager->Dashboard->Protect and Recover Data
3. Click: SQL Server
4. Click on Tab: Automate
5. Change PowerShell to Command Line
6. In the command window below execute the following commands.
   1. q tsm
   2. q tdp
   3. q sql
7. If these commands do not return errors, the TDP Client is configured properly.

Further Reading

1. IBM Tivoli Storage Manager Infocenter
2. Data Protection for Microsoft SQL Server