Results 1 to 7 of 7
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default Emergency SQL Restore Question

    I backup a database FULL weekly.............DIFF daily...........LOG hourly.

    I am restoring this database up to this morning May 18, at 06:00.

    If I use "tdpsqlc restore FULL....." with the /RESTOREDate and /RESTORETime parameters, will this bring everything up to the time/date I specify, OR is that ONLY going to look at the most recent FULL, which is 5/14, in which case I then need to do DIFF and LOG restores to bring it forward and use those same date/time parameters in each of those commands?
    Last edited by GregE; 05-18-2012 at 10:28 AM.

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,714
    Thanks
    3
    Thanked 206 Times in 201 Posts

    Default

    The restore should bring everything back to the time and date specifed including the log files.
    Ed

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

    Default

    Thank you. The documentation wasn't quite clear to me on that.

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

    Default

    Curious..........we restored to 6:00am because they saw corruption around 7:30am.

    Let's say corruption actually occurred before that and the 6:00am log backup also contained corrupt data. Would I have to restore the entire DB again or could we restore only the previous log? I think the whole thing, but correct me if there is another way.

  5. #5
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,714
    Thanks
    3
    Thanked 206 Times in 201 Posts

    Default

    Depends. If the corruption hit the 0600H log, then you have to restore before that. If there is no LOG to restore, then TSM will restore the last FULL backup.
    Ed

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

    Default

    So they're not happy with what has been restored and they want an earlier restore.

    There are logs before that 0600H log. So I can restore ONLY a 0500H log file to this currently restored database and the DBA can just send us back an hour with that alone? If so, that's a HUGE time saver.
    Last edited by GregE; 05-18-2012 at 03:06 PM.

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

    Default

    Ok, yesterday during the day I restored a complete SQL db back to 10PM Thursday. It ran well, around 45MB/sec

    Last night we had to do that again, but restoring it to a different server. Same data, on same tapes (no reclamation or tape moves occurred on the storage pool). Ran it during the night when TSM was under load (during some short stretches, there was little load), and it ran at 150Kb/sec (not a typo), and I had to eventually kill it. We may not need it anyway at this point, and I'm going to try an identical restore during the day today to see if it goes back to a normal speed.

    What in the heck would bring it to it's knees if it is the same data as it was when it ran normal? If it was TSM server load at night causing it, I would have expected a massive speedup during the times where TSM had a break in it's backup activities, but that did not happen.

Similar Threads

  1. Restore of SQL transactionlog to another server with TDP for SQL Restore
    By Piper06 in forum Restore / Recovery Discussion
    Replies: 0
    Last Post: 04-22-2012, 07:32 AM
  2. Replies: 0
    Last Post: 10-05-2009, 01:56 AM
  3. Single Tape drive as emergency replacement for library
    By misnoma in forum Tape / Media Library
    Replies: 1
    Last Post: 05-30-2008, 09:58 AM
  4. SQL Server 2000 Restore Question
    By m*a*s*h in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 09-28-2007, 10:30 PM
  5. tsm server recovery, emergency!!! need help!!!
    By fwang in forum Disaster Recovery Module
    Replies: 6
    Last Post: 10-11-2005, 05:12 AM

Posting Permissions

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