I have deleted a ldf files

• Dan Iordache

  Newbie

  Points: 1

  More actions

  July 15, 2002 at 7:54 am

  #78986

  How can I recovery a ldf file (I have only mdf file and I can't restore or undelete ldf file)

• Antares686

  SSC Guru

  Points: 125444

  More actions

  July 15, 2002 at 8:23 am

  #432705

  Use sp_detach_db to detach the mdb file if still attached, then use sp_attach_single_file_db [ @dbname = ] 'dbname'

  , [ @physname = ] 'physical_name' to reattach and it will build a new ldf. See SQL BOL for details.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)