TDP - Installing Storage Manager for Databases (Microsoft SQL Server): Difference between revisions
Jump to navigation
Jump to search
Line 13: | Line 13: | ||
## <tt>'''tsm> GRANT PROXynode TArget=<hostname/clustered name>-TDP AGent=<hostname/clustered name>'''</tt> | ## <tt>'''tsm> GRANT PROXynode TArget=<hostname/clustered name>-TDP AGent=<hostname/clustered name>'''</tt> | ||
# Backup Strategy | # Backup Strategy | ||
## 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 | |||
## Legacy Backups | ## Legacy Backups | ||
### Create the full backup client schedule. | ### Create the full backup client schedule. | ||
Line 23: | Line 24: | ||
### Create the full backup client schedule. | ### Create the full backup client schedule. | ||
#### <tt>'''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'''</tt> | #### <tt>'''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'''</tt> | ||
== TDP Client Installation == | == TDP Client Installation == |
Revision as of 16:53, 14 August 2014
Planning
- Determine your backup strategy.
- VSS Backups (Full backup only)
- Legacy Backups (Full/Differential/Logs)
Server Preparation
- Two nodes must be registered, the node that will be used for the Backup/Archive Client, and one for TDP.
- Register the Backup/Archive node.
- tsm> REGister Node <hostname/clustered name> <password> DOmain=<domain> CONtact=<contact info>
- Register the Data Protection node.
- tsm> REGister Node <hostname/clustered name>-TDP <password> DOmain=<domain> CONtact=<contact info>
- Create the proxy access for the agent.
- tsm> GRANT PROXynode TArget=<hostname/clustered name>-TDP AGent=<hostname/clustered name>
- Backup Strategy
- 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
- Legacy Backups
- Create the full backup client schedule.
- 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>
- Create the differential backup client schedule.
- 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,...>
- Create the log backup client schedule.
- 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
- Create the full backup client schedule.
- VSS Backups
- Create the full backup client schedule.
- 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
- Create the full backup client schedule.
TDP Client Installation
- Install the Tivoli Backup/Archive Client before proceeding.
- Install the Data Protection for SQL Server.
- Execute the setupfcm.exe program.
- Follow the instructions to complete the installation.
TDP Client Configuration
- Start the TDP MMC.
- Start > All Programs > Tivoli Storage Manager > Data Protection for Microsoft SQL Server > DP for SQL Management Console
- Expand: IBM Tivoli Storage Manager->Dashboard->Manage
- Click: Configuration
- Double click: Wizards
- Double click: TSM Configuration
- Restart the system.
TDP Client Verification
- Start the TDP MMC.
- Start > All Programs > Tivoli Storage Manager > Data Protection for Microsoft SQL Server > DP for SQL Management Console
- Expand: IBM Tivoli Storage Manager->Dashboard->Protect and Recover Data
- Click: SQL Server
- Click on Tab: Automate
- Change PowerShell to Command Line
- In the command window below execute the following commands.
- q tsm
- q tdp
- q sql
- If these commands do not return errors, the TDP Client is configured properly.