Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers

up vote 5 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
add comment

Try the path

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

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.