Post reply

Backup/Restore

  • July 6, 2012 at 3:53 am

    #258851

    Hi All

    SQL Server 2008 Enterprise Edition

    I have daily full backups and hourly log backups running

    The full backup runs for +- 6 Hours

    I am planning on taking the previous night's full backup and restoring it to another server and then restore the subsequent transaction logs.

    Once the Full backup has been restored to the other server (with no recovery), is there a script/method I can use to tell me exactly which transaction log file needs to be restored first ?

    Thanks

  • July 6, 2012 at 4:07 am

    #1509563

    Backups must be restored in the order in which they were created. Before you can restore a particular transaction log backup, you must first restore the following previous backups without rolling back uncommitted transactions, that is WITH NORECOVERY.

    Log backups must be applied in the sequence in which they were created, without any gaps in the log chain.

    When database is NORECOVERY its non-operational, means you can not access it..If you bring back the database online then you can't restore logs.

  • July 6, 2012 at 4:11 am

    #1509567

    Sqlsavy (7/6/2012)

    Backups must be restored in the order in which they were created. Before you can restore a particular transaction log backup, you must first restore the following previous backups without rolling back uncommitted transactions, that is WITH NORECOVERY.

    Log backups must be applied in the sequence in which they were created, without any gaps in the log chain.

    When database is NORECOVERY its non-operational, means you can not access it..If you bring back the database online then you can't restore logs.

    I get this

    My question is: Because the full backup runs for 6 hours, there are obviously Log backups running during this time - What is the first T-Log backup I need to restore, once the full backup has been restored?

    Thanks

  • July 6, 2012 at 4:21 am

    #1509579

    All transaction log backups taken after the full database backup should be restored . Log backups running prior /while full database backups should be ignored.If you try to restore them you'll recive an error.

  • July 6, 2012 at 4:23 am

    #1509582

    Sqlsavy (7/6/2012)

    All transaction log backups taken after the full database backup should be restored . Log backups running prior /while full database backups should be ignored.If you try to restore them you'll recive an error.

    Is there a script/method to check exactly which T-Log file it's expecting?

    Thanks

  • July 6, 2012 at 4:27 am

    #1509586

    I think this is what you're after

    http://www.sqlbackuprestore.com/backuprestorehistorytables.htm

Viewing 6 posts - 1 through 5 (of 5 total)

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