Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Any one using Tivoli, TDP from IBM???? Expand / Collapse
Author
Message
Posted Thursday, February 17, 2005 12:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 6, 2012 6:49 AM
Points: 249, 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




Post #162509
Posted Thursday, February 17, 2005 2:16 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:33 AM
Points: 385, Visits: 725

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

 




Post #162554
Posted Thursday, February 17, 2005 2:27 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 6, 2012 6:49 AM
Points: 249, 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




Post #162557
Posted Wednesday, February 6, 2008 10:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 24, 2012 9:37 AM
Points: 1, Visits: 71
You can restore Master into another database, stop sql, rename master.mdf/ldf from the restored into database and start sql.


Post #452552
Posted Saturday, February 16, 2008 3:38 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 9:52 AM
Points: 89, Visits: 995
Tried adding trace flag 3608?

_____________
Donn Policarpio
Post #456662
Posted Friday, October 21, 2011 4:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:05 AM
Points: 120, Visits: 792
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
Post #1194241
Posted Wednesday, November 30, 2011 1:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 30, 2011 1:31 AM
Points: 1, Visits: 20
Projector Lamps - Recessed Lighting - workout
Post #1213721
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse