Wednesday, March 21, 2012

Question on size restriction for Sql Express and Sql 2005 Standard

If i create a database in SqlEX and then move it to a sever running Sql 2005 standard, am Is my database still limited to the 4GB size?

No, I've tested:

create a database in SQL Express, then detach it;

attach to SQL 2005 Enterprise Edition;

Increase the data file size to 5GB, no problem

No comments:

Post a Comment