1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Restore only Transaction logs

Discussion in 'Microsoft SQL Server' started by bxtr97, Sep 7, 2012.

  1. bxtr97

    bxtr97 New Member

    Joined:
    Oct 12, 2010
    Messages:
    28
    Likes Received:
    0
    I have restored the full backup successfully and did not perform the recovery because we wanted to continue to restore transaction logs, however in the GUI when i select the transaction log backup that occurred after the full, it also selects the full and i cannot uncheck it. I attempted the restore with both selected and it appears to be either restoring the full again or at least sending the data of the full from TSM to the SQL server. The full on this server was 7TB so it takes a while.

    I know if the backups were taking in SQL server we as long as we left the database in recovery mode we could continue to apply transaction log. As long as I apply them in order is there a way in TSM to restore just the Transaction logs?

    Thank you
     
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Yes it will need the FULL backup since no recovery was done. If the database is up and running and you need to apply portions of the transaction logs, then TDP will do so knowing that the DB has been recovered, and is actve.
     
    bxtr97 likes this.

Share This Page