Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
3  
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
2  
alternatively McDonalds is waiting ;) Serving burgers does not require backups. –  TomTom Jul 6 '12 at 19:57
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.