DataBase Restore Via TDP in SQL Server
Restore through tdpsql GUI:
copy the source dsm.opt file \restore folder.
edit the dsm.opt file and put * into password location and save it.
run cmd it will open command prompt and run open notepad too.
copy the the following script on notepad and modify the location you copied the dsm.opt file.
set sql_dir=C:\Tivoli\TDPSql\restore\
c:
cd %sql_dir%
cd C:\Tivoli\TDPSql\
tdpsql /tsmoptfile=%sql_dir%\dsm.opt
Modify the location of \restore dms option file
copy the modified the script from notepad and paste on command prompt screen and run it, GUI will start, then
Go to 3rd tab restore tab and put the source tdpsql node name as the password paste and select which db and date you want restore on it in destination location
8
9 GUI will start looks like as follows:
.
10 type the Source of the tdpsql-servername as tdpsql password.
11 It looks like this and select dba db you want to restore like as follows.
12 Then again right click on full and select relocate and modify the current db location of mdf and ldf files as follows.
15 After your restore is completes, you can close all open windows.
Using TDP for SQL to backup MSSQL databases
set sql_dir="C:\Program Files\Tivoli\TDPSql"
set instance=restore_stagesql01
c:
cd %sql_dir%
TDPSQLC Restore mtvods_prod FULL /TSMNODE=TDPDB-MTVDWSTAGESQL01 /TSMPassword=TDPDB-MTVDWSTAGESQL01 /FROMSQLserver=MTVDWSTAGESQL01 /sqlserver=MTVDWQASQL01
/tsmoptfile=%sql_dir%\%instance%\dsm.opt
/logfile=%sql_dir%\%instance%\restoremtvods_prod.log
/mountwait=yes
NEW USER SA ISSUE REFRESH COMMAND ADSL04\Uat Sever using SA Password in the Script
set sql_dir="C:\Program Files\Tivoli\TDPSql"
rem C:\Program Files\Tivoli\TDPSql\RestorefromADSLIVE04 ---Commented Line
c:
cd %sql_dir%
TDPSQLC Restore AdSalesRptOnline FULL /stripes=1 /TSMNODE=TDPDB-ADSLIVESQL04 /TSMPassword=TDPDB-ADSLIVE04/FROMSQLserver="ADSLIVE04" /sqlserver="ADSL04\Uat " /SQLUSer="sa" /SQLPassword="P123"
/INTO=AdSalesRptOnline_STG /RELocate=AdSalesRptOnline_Data,AdSalesRptOnline_Log,AdSalesRptOnline_Log2 /TO=M:\MSSQL.1\MSSQL\Data\AdSalesRptOnline_STG_Data.MDF,O:\MSSQL.1\MSSQL\LOG\AdSalesRptOnline_STG_Log.LDF,O:\MSSQL.1\MSSQL\LOG\AdSalesRptOnline_STG_Log2.LDF
/tsmoptfile=%sql_dir%\RestorefromADSLIVE04\dsm.opt
/logfile=%sql_dir%\RestorefromADSLIVE04\adsalesrptonline_stege_DEV.log
/REPLACE
/mountwait=yes
13 After modifying you select OK,
14 Now you select to restore and then it will start the restore of dba db on distination server.