Post reply

Restore further T-Log Backups

  • May 9, 2023 at 10:58 am

    #4186545

    Hi,

    is it possible, to restore more t-log backups, after I restored the database?

    We got a problem, and we had to restore the database, then check the table in the database. Maybe we did the point in time restore to early, and I'd like to restore some more t-log backups, without the restore of the full backup.

    Is this possible?

    I tried a lot, but currently I am not able to restore more t-log backups, after the database was online to check the table.

    Thanks,

    Kind regards,

    Andreas

  • May 9, 2023 at 1:01 pm

    #4186627

    Did you check the "Restore ... with standby" option ?

     

    BOL ref: RESTORE ... With Standby

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • May 9, 2023 at 1:57 pm

    #4186647

    Hi,

    thanks for your post, you safed my day, maybe my whole life.

    It works, and now I am able to support my team.

    Thanks a lot,

    Kind regards,

    Andreas

  • May 9, 2023 at 4:39 pm

    #4186755

    The other method is "WITH NORECOVERY".  But, people need to find and read the documentation to know of either option before they tackle the two most important things a DBA will ever do... BACKUP and RESTORE.

    I forget who I first heard say it but it's absolutely true... "You don't need a backup plan... you need a restore plan" which, of course, includes backups.

    There are a couple of lists of links at the bottom of the great link that Johan cited.  IMHO, it's a "required" reading list for anyone charged with protecting data with Backups and Restores, even if you use "canned" code, like Ola Hallengren's great scripts.  One of my favorite analogies for this would be "To be a auto-mechanic, you're going to need to know a whole lot more than just how to drive a car". 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply