Super User is a question and answer site for computer enthusiasts and power users. 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

A client has a very important database that has not been backed up in 6 months. The PC has promptly failed. The Windows directory is corrupt, and the computer will not boot.

It had a Microsoft SQL Server Express 2005 database on it. I have access to the hard drive by booting in with an Ubuntu Live CD, but I am not sure if I can find the database. I am not sure what I am looking for, or where to look either. The dead machine had Windows XP on it.

share|improve this question
up vote 6 down vote accepted

you are searching for something usualy stored like this

Folder:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Filenames:

<DBNAME>.mdf
<DBNAME>_log.ldf

probably existing backups are stored usualy here

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<anyname>.bak
share|improve this answer
2  
These are the default locations, but I'd search the entire hard drive for .MDF and .LDF files just-in-case. – JBRWilkinson Nov 20 '12 at 11:38

Try the path

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .