Solved

Sql express or sql 2008

Posted on 2012-04-09
3
157 Views
Last Modified: 2012-04-11
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
Comment
Question by:janhoedt
3 Comments
 
LVL 10

Accepted Solution

by:
sqlservr earned 500 total points
ID: 37826440
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
 

Author Comment

by:janhoedt
ID: 37826444
Ok, thanks. But does sql express require less resources then full version, what makes it more performant?
0
 
LVL 5

Expert Comment

by:kanalQko
ID: 37826456
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now