4 GB Size limitation

Hi,

Can somebody tell me if the 4 GB database size limit is per database or for all the databases

Regards

Harish

The limit is per database and its only for the data file not the log file.|||Thanks Euan.|||

Do you have any supporting documentation about this in the MS Site

Sorry to bother.

|||

Here is one place, comparing to MSDE

http://msdn2.microsoft.com/en-us/library/ms165672(SQL.90).aspx

Interesting blog...

http://blogs.msdn.com/czhower/archive/2006/01/06/510192.aspx

|||

Thank you.

Is there any limitation on number of databases. I mean, How many 4 GB databases can I have(Provided there is disk space).

I might be asking the basics, but need to finalize on a product architecture.

Thanks

|||

You can have as many 4 GB databases as your hardware allows. Needless to say, there is a practical limit to how many database can be managed and accessed given the other limitations of 1 CPU and 1 GB Ram.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.