Friday, March 23, 2012

TDP SQL SERVER CONFIGURATION

IBM Tivoli TDP SQL Server Configuration steps:


TDP SQL INSTALLATION:








 End User License Agreement: 


Installation Location:





 Installation Completed:

Checking through the command line using tdpsqlc:




Accessing through the TDP GUI Utility:

TDP SQL Window:


Opening the SQL Server 2005 Management studio:



Creating the Database:




Creating Table:


 Inserting the records into table:


 Listing the table data:



Accessing through the TDP SQL Utility:



Taking SQL Database Backup:




After taking a backup delete the database (For test the restore):




 Restore using the TDP Utility:



Restoring:



 Checking the database with the tables and records:


After restoring, all the data are available in the database.

CLI:

tdpsqlc
tdpsql ---- to open the TDP SQL GUI
tdpsqlc backup
tdpsqlc restore

All the Best to Every One !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Senthilkumar Muthusamy

98658 31007


3 comments:

  1. Hi senthil the blog is really good

    ReplyDelete
  2. Hello, you can try guys SQLgzip (from http://SQLgzip.com) This is tool which enables you to backup SQL Server database directly to TSM filespace. Only TSM client is needed so no need to buy expensive TDP license. Additionally 32-bit version fully functional is for free !

    ReplyDelete