SQL 2008 SP3 DB Backup

  • Lynn Pettis (1/15/2013)


    george sibbald (1/15/2013)


    sjimmo (1/15/2013)


    Lynn

    To restore to 1/13 4:00 AM you will need the previous days (1/12) full backup file plus all the t-log backups since that backup up to the t-log backup that includes the point in time to which you want to restore

    Since their 1/13 database dump started on 1/13 at 1:00 AM, wouldn't that mean that the T-Log dumps for 1/12 have stopped at 1:00? I believe the LSN chain broke at the start of the new database dump. My understanding is that once the backup begins, it takes any dirty data and commits it. It then places a marker on the T-Log so that when the db dump completes the t-log is then dumped making the db dump complete. Thus the reason that you would need the previous full dump but cannot apply T-Log dumps to a full dump completed after the T-Log dumps.

    from 2008 on you can take tlog backups whilst the full backup runs, they just don't truncate the log. A full backup does not 'dump' the log.

    I may be wrong, but I thought this was true in SQL Server 2005 as well.

    my apologies, I mis-remembered and should have checked, too many active versions.

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

Viewing post 16 (of 15 total)

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