Reconstruct data from .MDF and .LDF

• jvelazquez

  Grasshopper

  Points: 17

  More actions

  August 2, 2002 at 7:41 am

  #78839

  The hard disk fails, then we use the EasyRecovery tool for recover the mdf and ldf files, we did it with success !

  But how can i restore o recover teh database or some tables from these files... whe format the hard disk, install NT and SQL but what can i do for recover the information from .MDF and LDB. files.

  Thanks !

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 2, 2002 at 9:17 am

  #433908

  All you need to do is reattach. You can use Enterprise Manager to do it in SQL2K, or the stored procedure sp_attach_db in either SQL7 or SQL2K.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn