General discussion

  • Creator
    Topic
  • #2073961

    My Data Base Gone. SOS PLease

    Locked

    by davood_f ·

    some one has deleted my database in sql server 7.0
    now I only have two file ,those are in :
    ..\sqlserver7\Data\myDB_Data.mdf &
    ..\sqlserver7\Data\myDB_Log.ldf
    Can I gain my database completly again?

All Comments

  • Author
    Replies
    • #3778114

      My Data Base Gone. SOS PLease

      by m2 ·

      In reply to My Data Base Gone. SOS PLease

      try following from Query Analyzer:

      sp_attach_db ‘myDB’, ‘c:\MSSQL7\Data\myDB_data.mdf’,’c:\MSSQL7\Data\myDB_log.ldf’

      Good luck to you!

    • #3778107

      My Data Base Gone. SOS PLease

      by ron navon ·

      In reply to My Data Base Gone. SOS PLease

      Dear Sir,

      Keep the mdf and ldf file in the side, make a data base with the same name, stop the services of SQL change the rename the new mdf and ldf, copy the old mdf and ldf.
      restart the server.
      I hope that is help you. Ron

    • #3754878

      My Data Base Gone. SOS PLease

      by davood_f ·

      In reply to My Data Base Gone. SOS PLease

      This question was auto closed due to inactivity

Viewing 2 reply threads