Get database after sql crash

by perkinss

Posted: 10 years ago 5 replies

PROGRAMMING

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!!

#crash #database #sql

KirkMcD 10 years ago

Copying 16 year old messages?

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

Must be a bot.
- Thanks
- 1 reply
{{ DiscussionBoard.errors[10685504].message }}
- Daniel22 10 years ago
  
  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..?
  
  Originally Posted by KirkMcD
  
  Copying 16 year old messages?
  
  https://www.experts-exchange.com/que...-mdf-file.html
  
  Must be a bot.
  
  Thanks
  
  1 reply
  
  {{ DiscussionBoard.errors[10685767].message }}
  
  KirkMcD 10 years ago
  
  Originally Posted by Daniel22
  
  Or the one who actually found out so quickly this was copied from a 16 year old msg..?
  
  Oh that's easy, just do an exact phrase search on one of the sentences in the post.
  
  Thanks
  
  {{ DiscussionBoard.errors[10687606].message }}
hmnur32 10 years ago

Backup data also save as .BAK file, You can try using .BAK file .
- Thanks
Signature

Checkout FIVERR GIG khasan.net doimake.com
{{ DiscussionBoard.errors[10685867].message }}
OrnSveinsson Banned 10 years ago

[DELETED]

{{ DiscussionBoard.errors[10693860].message }}
KirkMcD 10 years ago

Oh here is the bot replying to itself to post its spam links.
- Thanks
{{ DiscussionBoard.errors[10694063].message }}

Get database after sql crash

Trending Topics

Is there a way to do article marketing these days that actually works?

What's preventing you from adopting AI in your sales process?

Wow, my War Room membership for 20 yrs is almost up..,

i appreciate all ya'll...

Clients Ghosting: Advice please!