How to read an old SQL Server 2005 mdf file

Question

I've upgraded my SQL Server 2005 to 2008, without backing up the databases. I kept the old data folder with the 2 DB.mdf and DB.ldf files.

So how can I import or read my .mdf file into SQL Server 2008 ?

If I try to use the 2008 tools import/export, I am unable to find the source because the 2005 has been replaced. Only the server 2008 is running.

If not possible, An other way, would be to read the .mdf file with vb if you know

Thank you for your help

regards Mike

@FeliceM You can restore from backups, not from the raw data files. — , Nov 22 '13 at 12:42
IIRC, attaching the data files works even if those data files come from an older version, though. — , Nov 22 '13 at 12:43

score 1 · Answer 1 · answered Nov 22 '13 at 12:45

1

In SSMS right click Database folder --> attach then choose your data file and log file accordingly

answered Nov 22 '13 at 12:45

vasin1987

score 1 · Answer 2 · answered Nov 22 '13 at 12:59

If you attach the SQL 2005 files to an SQL 2008 instance it will know what to do with them (it will upgrade the database). Use sp_attach_db, CREATE DATABASE ... FOR ATTACH or even the management tool, How to: Attach a Database.

I recommend make a copy of the files before the attach.

score 0 · Answer 3 · answered Nov 22 '13 at 12:43

0

Here there is a full article on how to move a Sql 2005 on 2008 sql server. Link

answered Nov 22 '13 at 12:43

FeliceM

3 Answers3