Post reply

Transaction Log backup

  • December 5, 2012 at 2:15 am

    #271564

    In Management Studio, in SQL 2008 TLog backup Maintenance plan creation - Back up the tail of the log, and leave the database in the restoring state is there. IMHO, this is checked when we need to take tail log backup, in case of a issue where we would need point intime restore of the database viz when restoring the same database which we are backing up. IS this correct?

  • December 5, 2012 at 5:32 am

    #1565694

    Hello Bala,

    Tail log backups are only needed in case of a Disaster Recovery scenerio (Point in time recovery is needed). One should not take taillog backup in normal routine.

  • December 5, 2012 at 6:06 am

    #1565705

    arunyadav, thanks for the confirmation.

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

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