• Excellent article and highly practical examples! Thank you!

    One question though: when having to restore to a specific point in time using STOPAT can I trust the "BackupStartDate" column returned by the following code?

    RESTORE HEADERONLY FROM DISK = 'C:\BACKUP_TESTE\AdventureWorks2008R2_20110927_LOG.BAK';

    That would be an easier way to identify which log backup I really need to stop at before performing the actions?

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA