Hi,
I'm using SQL Server 2005 Express for an application.
SQL Server 2005 Express supports 4GB user data per database. Because need over 4GB(may be 20GB ~ 30GB) data space, I should split database which each max size up to 200 MB. And create 100 databases.
Is it reasonable? If true, what about the performance or system's overhead?
Thank you.
No, that is not feasible for what you list for a variety of reasons. If you need 20-30GB, you need (and SHOULD) purchase SQL Server full version. What about the workgroup edition to save some money?
No comments:
Post a Comment