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

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

share|improve this question
3  
Only R2 has the 10GB limit. Note that once migrated, there is no way back, the database is upgraded and you cannot attach it anymore to a SQL 2005 instance. –  Remus Rusanu Jul 16 '10 at 5:08
    
Good point about R2, thanks! I just double checked I downloaded the right version. –  Daniel Magliola Jul 16 '10 at 6:40

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
Awesome, just wanted to make sure before wasting a lot of hours finding out the hard way. Thank you! –  Daniel Magliola Jul 16 '10 at 3:34

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.