Post reply

Third Party Backup / Restore

  • September 23, 2004 at 9:59 am

    #162820

    Question, is it possible to do a FULL backup via a third party tool and then perform log dumps via MS SQL 'backup' command throughout the day...will I be able to RESTORE the FULL backup as well as be able to apply these transaction logs if failure occurs?

    Thanks...Marsha

  • September 23, 2004 at 10:59 am

    #524216

    You would most likely need to perform the restore of the full backup using the third party tool (if you are using features not found in the standard SQL Server backup), and restore the trx logs using the standard SQL Server commands. 

    Should have no problem as long as the third party tool has options for you to restore the full backup with the NORECOVERY or STANDBY options.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • September 23, 2004 at 12:44 pm

    #524245

    Better test it!!!

    Steve

  • September 24, 2004 at 7:35 am

    #524329

    SQL LiteSpeed supports this functionality.  I've run tests where I've done the following and all were successful:

    Full LiteSpeed Backup

    Native Tlog Backup

    LiteSpeed Tlog Backup

    ------------

    Full native backup

    Litespeed Tlog Backup

    Native Tlog Backup

     

    Every scenario will work fine as long as you remember which order and restore in the proper order.  Hope this helps.

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

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