Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Sql express or sql 2008

Hi,

I wonder if there s a reason to absolutely go for sql server instead os sql express when you have a small environment. Express asks for less resources and  goes upto 10 gb, wright?

Thx for your feedback.
J
0
janhoedt
Asked:
janhoedt
1 Solution
 
Ramesh Babu VavillaCommented:
below are the limitations on SQL Server 2008 Express edition
1 BCP not suppported
2 Database size is 10 GB and Log file size is 4 GB
3 Profiler not installed
4 scheduled Maintenace jobs not available
5 Import/Export option is not avaialable
0
 
janhoedtAuthor Commented:
Ok, thanks. But does sql express require less resources then full version, what makes it more performant?
0
 
kanalQkoTechnical Support EngineerCommented:
resources should be similar, anyway I`d suggest you to look for ms sql 2012, which was already released (i`m going to beta exam in a while) ;-)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now