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

  • Not sure i understand.

    You would need to restore your last full backup (.bak), then re-apply (restore) each log backup (.trn) up until the failure.

    If you dont have a log backup from after you added the new ldf file, its gone.

    HTH

    Adam Zacks-------------------------------------------Be Nice, Or Leave