SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Any one using Tivoli, TDP from IBM????


Any one using Tivoli, TDP from IBM????

Author
Message
devereauxj
devereauxj
SSC Veteran
SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)

Group: General Forum Members
Points: 297 Visits: 140

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.

Thanks,

Joseph





Jp
Jp
SSC-Addicted
SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)

Group: General Forum Members
Points: 441 Visits: 775

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

--JP





devereauxj
devereauxj
SSC Veteran
SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)

Group: General Forum Members
Points: 297 Visits: 140

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,

Joseph





claywilcox
claywilcox
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 71
You can restore Master into another database, stop sql, rename master.mdf/ldf from the restored into database and start sql.



Donn Polix
Donn Polix
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 1084
Tried adding trace flag 3608?

_____________
Donn Policarpio
Anchelin
Anchelin
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 1128
HI Old Hand

Can you please give us the backup command for database backups to TSM via SQL Server Agent job?

Your response will be much appreciated!

Regards
A
markmendiola991
markmendiola991
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 20
Projector Lamps - Recessed Lighting - workout
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search