Results 1 to 3 of 3
  1. #1
    Senior Member Jeff_Jeske's Avatar
    Join Date
    Jul 2006
    Location
    Stevens Point, WI
    Posts
    485
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Question Sql tdp redirected restore help needed

    I have two SQL servers:

    DIX-T-REIDBS-02 (test server) and DIX-Q-REIDBS-02 (qual server)

    Both servers have two databases on them. I want to restore database DIX-T-REIDBS-02\SQLDBA1 to DIX-Q-REIDBS-02\SQLDBA2.

    Be advised the TDP node uses a different name for both DIXTREIDBS02-S and DIXQREIDBS02-S respectively.

    I copied the TDP DSM.OPT from DIX-T to DIX-Q and verified that DIX-Q now thinks it's DIX-T via the GUI (spoof).

    I click on the restore tab and can select DIX-T-REIDBS-02\SQLDBA1 backup file without issue but the GUI doesn't show the intended destination of DIX-Q-REIDBS-02\SQLDBA2 database. It also doesn't provide any option to redirect that restore from SQLDBA1 to SQLDBA2 even if it did show up!

    I have read through 5.5.4 TDP install and user guide including app G but do not see any supported documentation for this particular task.

    My DBA attempted to create a command to perform the same task but it bombs out complaining about invalid options. Here is the script:

    tdpsqlc restore SQLDBA1 full /INTO=SQLDBA2 /FROMSQLSERVER=DIX-T-REIDBS-02 /RECOVERY=YES /REPLACE /RELOCATE=SQLDBA1 /TO=d:\DBData01\SQLDBA2.mdf
    /RELOCATE=SQLDBA1_log /TO=d:\DBData01\SQLDBA2.ldf

    I'm a bit at a loss as I don't even know when I should be using the TDP node name rather than the actual server name.

    Can any of you create a script that will perform this task, identify why the above script is failing or at a minimum help me make the GUI do what I want it to do?

    Thanks in advance!
    Jeff
    Last edited by Jeff_Jeske; 02-21-2012 at 12:04 PM.

    Jeff Jeske - Sentry Insurance Storage Engineer
    IBM Certified Advanced Deployment Professional
    SNIA Certified Storage Engineer
    EMC Proven Professional
    ITIL Certified

    Sometimes the more you know... the harder it is to make a good decision!

  2. #2
    Senior Member Jeff_Jeske's Avatar
    Join Date
    Jul 2006
    Location
    Stevens Point, WI
    Posts
    485
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default

    Taco tuesday bump

    Jeff Jeske - Sentry Insurance Storage Engineer
    IBM Certified Advanced Deployment Professional
    SNIA Certified Storage Engineer
    EMC Proven Professional
    ITIL Certified

    Sometimes the more you know... the harder it is to make a good decision!

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    I did this a couple weeks ago (cmd line) and it was a bit tedious...

    A physical file existed on my target, which I let this process replace but its the /TO in my command......

    tdpsqlc restore <dbname> full /sqlserver=<target_sql_server\<target_sql_instance> /fromsqlserver=<source_sqlserver>\<source_sql_instance> /tsmoptfile=<tdp_optfile_you_copied> /tsmpassword=xxxxxxxxxx /relocate=<logical_filename> /to=<full_path_and_existing_physical_filename> /into=<dbname> /recovery=yes /replace

    If you are restoring DIFF or LOG after your FULL restore, set /recovery=no on the FULL and only set it to "yes" on the very last restore you do in the series.

    Get the logical filename using "query TSM"...

    tdpsqlc query TSM <dbname> full /fromsqlserver=<source_sqlserver>\<source_sql_instance> tsmoptfile=<tdp_optfile_you_copied> /fileinfo /all
    Last edited by GregE; 02-21-2012 at 02:19 PM.

  4. The Following User Says Thank You to GregE For This Useful Post:

    Jeff_Jeske  (02-21-2012)

Similar Threads

  1. backom redirected restore
    By tsm_dude in forum DB2
    Replies: 1
    Last Post: 06-29-2009, 12:42 PM
  2. Names of Tapes Needed for a TDP Restore
    By Rouen in forum Scripting
    Replies: 1
    Last Post: 09-12-2008, 03:12 PM
  3. DB2 TDP Backup and redirected restore
    By jharris in forum DB2
    Replies: 2
    Last Post: 10-24-2007, 12:30 AM
  4. Which volumes needed for TDP EXCHANGE restore
    By renever in forum TDP/Application Layer Backup
    Replies: 0
    Last Post: 04-26-2006, 09:46 AM
  5. Redirected restore in TSM
    By martoncik in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 08-18-2004, 07:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •