Home Forums SQL Server 2005 Administering In Sql Server Can we recover new log file(.ldf) if we added that after full backup RE: In Sql Server Can we recover new log file(.ldf) if we added that after full backup

  • January 11, 2011 at 12:25 pm

    #1272030

    I would think that the steps of adding a new file (ALTER DATABASE) are captured in the transaction logs and would occur when you restore the transaction logs after first restoring the full ..... I've never tried it though.