Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My development server hard drive crashed and i was running Microsoft sql server on it as my database. I was wondering if its possible to export the databases or copy the meta data? the only way i can see the files is through a live boot linux cd so where is the database files located on disk?

share|improve this question
Just restore from backup. You know, the copy of the important data that you make frequently so that you aren't relying on a single hard disk (which any system administrator knows are prone to failure over time). – Chris S Jun 27 '11 at 1:35
alternatively McDonalds is waiting ;) Serving burgers does not require backups. – TomTom Jul 6 '12 at 19:57

If you can mount the file system and navigate across the directory structure, then there is a chance that you can rescue things. Some steps to consider:

  1. Backing up the partition to another drive (GParted or any other partition utility)
  2. Boot the Windows installation media to a command prompt
  3. Run chkdsk against the partition/disk in question

If needed, there may be other 3rd party utilities which can automate the steps as well as include additional functionality to assist.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.