Hard disc crashed, Restoration Problem

• Rahuul

  Mr or Mrs. 500

  Points: 581

  More actions

  May 30, 2003 at 6:01 am

  #357790

  hi all,

  We had a hard disc crash and our SQL server is gone, but we have the database files (both system & user database files), it was not backuped files, these are the files which were online at the time of crash.

  Is it possible to up the database with previous databases, with the existing, mdf and ldf files & how?

  Thanks in advance

  Rahul

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 30, 2003 at 6:55 am

  #459172

  Try sp_attach_db to attach the databases back after SQL Server reinstalled. I may not work if databases were not properly shutted down.