Get database after sql crash

by 5 replies
5
One of the hard drive in my office's NT server was crashed two weeks ago. I had installed MS-SQL in c: and the data was stored in d:. The hard crased was c:. Thus I replaced the crashed hard drive and re-install NT server and SQL server again.

The problem now is how to restore the data from the .mdf files located in d: (there's no other backup). I've tried to "restore" but MS-SQL server reported that it was not a valid backup file format and not allowed me to restore the database. Could anybody help? Thanks!!
#programming #crash #database #sql
  • Copying 16 year old messages?

    https://www.experts-exchange.com/que...-mdf-file.html

    Must be a bot.
    • [1] reply
    • I seriously don't know what's weirder, A random bot who just came up here with a 16 year old msg for god knows what purpose? Or the one who actually found out so quickly this was copied from a 16 year old msg..?

      • [1] reply
  • Backup data also save as .BAK file, You can try using .BAK file .
  • Banned
    [DELETED]
  • Oh here is the bot replying to itself to post its spam links.
Join the discussion

Next Topics on Trending Feed

  • 5

    Get database after sql crash

    One of the hard drive in my office's NT server was crashed two weeks ago. I had installed MS-SQL in c: and the data was stored in d:. The hard crased was c:. Thus I replaced the crashed hard drive and re-install NT server and SQL server again. The problem now is how to restore the data from the .mdf files located in d: (there's no other backup). I've tried to "restore" but MS-SQL server reported that it was not a valid backup file format and not allowed me to restore the database. Could anybody help? Thanks!!