Restore of SQL DB using TDP for SQL
V0.1
Shyam Rajamanickam
[email protected]
Table of Contents
TDP for SQL Restoration...........................................................................................................2
1. Simulating Restore.....................................................................................................................2
2. Restore DB with different name to the same server.................................................................5
3. Restore DB from other clients...................................................................................................7
4. Use tdpsqlc to restore DB from a different server.....................................................................9
1
TDP for SQL Restoration
1. Simulating Restore
1) Delete the table dbo.ChunkData from the ReportServerTempDB to simulate the scenario of data
loss.
2
2) Open flash copy manager on TSM_Client01 and set Replace=True in the restore option.
3) Choose the backup DB and click restore.
3
4) Confirm the removed table is restored
4
2. Restore DB with different name to the same server
1) Right click the backup DB and choose ‘Restore to Alternate Location…’
2) Set the new name of the database to be TEST, and new location of the file is C:\Backup
5
3) Confirm the new DB in SQL server
6
3. Restore DB from other clients
1) Change nodename to TSM_Client02_SQL in the file C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt
on TSM_Client01
NODename TSM_Client02_SQL
2) Launch tdpsql.exe and click Restore Databases tab. A warning may pop up, just click OK. (or grant
the proxynode on TSM_Sandbox first: grant proxynode target=TSM_Client02_SQL
agent=TSM_Client01)
3) The DB on the source server will be listed now. Just choose the DB and click restore. (You can
specify the new DB name in Restore Into, and new location in Relocate)
7
8
4) Confirm the database has been restored. And change the setting that is modified in step 1) back.
4. Use tdpsqlc to restore DB from a different server
1) Uncomment the password settings in the dsm.opt on TSM_Client01
*PASSWORDAccess generate
2) Run the following command to restore database named “Profile DB” from TSM_Client02 to
TSM_Client01
tdpsqlc restore “Profile DB” full /tsmnode=TSM_client02_SQL /fromSQLServer=Sbox-Sql
3) Confirm the “profile DB” has been restored, and change the password settings back.
9
10
