TDP - Installing Storage Manager for Databases (Microsoft SQL Server): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 12: | Line 12: | ||
# Create the proxy access for the agent. | # Create the proxy access for the agent. | ||
## <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: Legacy Backups | |||
## Create the full backup client schedule. | |||
### <tt>'''tsm> DEFine SCHedule <domain> TDP-MSSQL-FULL 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>'''</tt> | |||
## Create the differential backup client schedule. | |||
### <tt>'''tsm> DEFine SCHedule <domain> TDP-MSSQL-DIFF 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,...>'''</tt> | |||
## Create the log backup client schedule. | |||
### <tt>'''tsm> DEFine SCHedule <domain> TDP-MSSQL-FULL DESCription="TDP for MSSQL Full Backup" ACTion=Command OBJects="<C:\path\to\sqlfull.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=ClassicDAYofweek=<day>'''</tt> | |||
== Client Installation == | == Client Installation == | ||
# Install the Tivoli Backup/Archive Client before proceeding. | # Install the Tivoli Backup/Archive Client before proceeding. | ||
# Install the Data Protection for SQL Server. | # Install the Data Protection for SQL Server. |
Revision as of 14:04, 13 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: Legacy Backups
- Create the full backup client schedule.
- tsm> DEFine SCHedule <domain> TDP-MSSQL-FULL 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 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-FULL DESCription="TDP for MSSQL Full Backup" ACTion=Command OBJects="<C:\path\to\sqlfull.bat>" STARTDate=MM/DD/YYYY STARTTime=HH:MM:SS SCHEDStyle=ClassicDAYofweek=<day>
- Create the full backup client schedule.
Client Installation
- Install the Tivoli Backup/Archive Client before proceeding.
- Install the Data Protection for SQL Server.