This is in continuation to my previous post on TDP for Microsoft SQL Server Installation. This post helps you understand the post installation of TDP for SQL, After installation TDP for SQL you need to configure the TDP for taking the SQL Backup. Follow the below procedure for configuring TDP for SQL.
Step by Step Configuration:
Step-1: Go to Start and All Programs –> Tivoli Storage Manger–> Data Protection for Microsoft SQL Server–>Open the DP for SQL Management Console.
Step-2: As soon as you open the DP for SQL Management Console it will automatically open the Configuration wizard for the first time.
If you would like to open manually above configuration wizard, On left side of the panel Expand the Dashboard–> Expand Manage–> Expand Configuration–> Select wizard–>in the center of the console select the TSM Configuration and right side Action panel you can see the start button click on start button to open the configuration
Step-3: On the Data protection Configuration wizard you see the SQL Server Application (note: the status must be shown as Installed if the status shown not installed check the pre-requisites) Select the SQL Server and Click Next
Step-5: Data protection for configuration wizard will run the pre-requisites, make sure the status should be passed. if any error occurs in the Status, fix the errors and re-run the Requirements Check
Step-6: Provide the TSM Node Name(VSS Requester and Data Protector SQL) if you don’t require the VSS Backup Select the Do not configure the VSS Support and Click Next.
Step-7: Configure the TSM Server Settings
- TSM Server Administrator Name
- TSM Server Administrator Password
- TSM Configuration Macro
Edit the macro file and provide the details if required. click Ok to save the settings and Click Next to continue.
Step-8: Next Wizard VSS requester Configuration leave defaults and Click Next.
Step-9: The Configuration Wizard runs all the configuration of VSS Data Protector provisioning and additional configuration. After completing the Configuration, Make sure Status should be Passed, if in case if you end up with any sort of error please identify and fix those errors and re-run the configuration again.
Step-10: You have reached the end of the installation.
Congratulations! you have Successfully Configured the TDP for SQL , Click Finish to close the wizard
Note:- In the below screen, If you check the VSS Diagnostics it will take you through the another wizard for VSS Checkup. i am not going to show this option for this article.
Once the configuration is finished you should be able to see the Database Server under Protect and Recover Data.
Hope you find this information useful, Please do comment / Share & Subscribe to TECHIESSITE.