We are using Tivoli TDP from IBM to do our backups to our tape robitic system. It has worked very well for backing and restoreing user databases.
My issue is with full instance restore, including all system databases. I did do full restores with SQL Server 2000 using backup devices. Now I am trying to do the same thing with the TDP utility.
My problem: I need to restore the user and system databases to another machine with a different instance name and maybe different drive config. I can restore the master, but it knows about the missing user databases and paths for the system databases. I have not been able to restore any user or system databases after the master.
Looking for someone who has done this with TDP, or might have more detail documentation. I have the standard document and the red book.
Hi...You can try below cmd:
--To Restore db backup to different (existing db2 on sever2) database on different server. Below example shows the restore of DB1 backup taken on SERVER1 and restored in DB2 on SERVER2.In this case TSM.OPT file enrty needs to point to SERVER1.
d:\tsm\tdpsql\tdpsqlc restore DB1 full /into=DB2 /fromsqlserver=SERVER1 /recovery=yes /replace
/relocate=DB1d1Data /to=E:\MSSQL2000 MSSQL\data\DB2_Data.MDF /relocate=DB1L1Log /to=G:\MSSQL2000\MSSQL\Log\DB2_Log.LDF /relocate=DB1d2Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data2.NDF /relocate=DB1d3Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data3.NDF /relocate=DB1d4Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data4.NDF
You can execute below cmd for full syntax help.
tdpsqlc help rest full
Thanks for the tip, but we have been using TDP for a over a year now. We have done hundreds of restores and restores for DR. Different servers, different disk configs, ect. Doing a fresh install and then restore of user databases is straight forward.
What I am trying to do is restoring the the Master database after the fresh install. (which is succesfull). But then, when opening the instance fully (instead of -f -m) it fails because the new restored master database knows about the user databases that are not resotred. Two, if the path and instance name are not the same, it knows about the other system db's with the old path information. We have systems with complex jobs (msdb) and security setups (master) and replication issues (model). I want to restore all the databases, system and user, so I don't have a complex list of scripts and documentation for each system. We have to test 20+ SQL instances and 30+ Oracle instances per year for DR alone. That is on top of the refreshes from prod to dev where all the jobs and security need to be duplicated.
Have you refreshed the entire instance?
Thanks for you information,