Home / server / Questions / 160987
Accepted
Daniel Magliola
Asked: 2010-07-16 19:27:30 +0800 CST

Will SQL 2008 Express still have a 10Gb limit if I use it to open a 2005 MDF file?

  • 772

I have the following situation: I have a production site running on SQL 2005 Express (only because it's free), and it's a reasonably big DB, and i'm always incredibly close to the 4 Gb limit. Every now and then I actually hit it and it's a big mess.

Now that SQL 2008 Express has 10Gb as a limit, I'm going to migrate.

The question is, if I just install SQL 2008, and attach the MDF file from 2005, will I have the 10 Gb limit? Or do I have to create a new Database from 2008, and then import the data?

If the latter, how do you recommend to do this import, what's the fastest and simplest way?

Thank you very much!
Daniel

sql-server

1 Answers

  1. Best Answer

    Yes. Note that the 2005 database will autoamtically be updated. It is NOT and NEVER WAS a limit in the MDF file - the files are the same as for a "real" server. The limit was always in the software.

    • 2