Question

Which version of SQL Server 2008 should we upgrade to?

We are upgrading from SQL Server 2000 on Windows Server 2003. Our database is currently around 4gb with 16 users. We also run Vault on this same server in the same SQL Server instance with 10 users.

My understanding is Express Edition has a size limitation, so I'm wondering whether FogBugz cares about any functional differences between Workgroup / Web / Developer / Standard / Enterprise editions, or does it even matter for our size and volume?

Answer 1

I think you have more of an issue with proper SQL Server Licensing than with FogBugz. FB runs on pretty much any of the sql editions provided the characteristics of the database fall withing the sql product guidelines.

Considering that your existing FogBugz db is about 4gb, you can probably still get some milage out of SQL Express. The R2 release has increased the maximum db size to 10Gb. If that doesn't provide enough room for growth for you, then you're probably looking at either the workgroup edition or standard.

Answer 2

You can use SQLServer Express 2008 R2, The limitation is 10 GB per database now.