Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are planning to get a backup server at Amazon EC2. As per my finding, Amazon supports only SQL Standard version. Can someone please help me with the above question. And, will any services be affected in SharePoint on SQL Standard version?

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Minimal is SQL Server 2008 Express with SP1.

The main difference with Standard is you can have a larger than 4gb database.

So the answer is yes.

Comparisons here

share|improve this answer
    
Are any SharePoint services affected when I use SQL Standard? –  neo269 Nov 7 '12 at 16:55
1  
No, it is a less restricted version of the minimum. –  Hugh Wood Nov 7 '12 at 16:59
    
Thanks... So basically, the Standard version is trimmed down version of Enterprise... Rest all should work perfectly... –  neo269 Nov 7 '12 at 17:02
1  
Yes it works just fine, Enterprise would be for large deployments that use a database cluster over of larger than 2 servers, and some quality of life things like "Hot add Memory and CPU". Read here: msdn.microsoft.com/en-us/library/cc645993.aspx –  Hugh Wood Nov 7 '12 at 17:11
1  
As Hugh mentioned, the Enterprise edition allows you to scale up the SQL Server, allowing you to add more memory and CPU core to the SQL Server and do more enterprise level stuff. Unless you are deploying a large scale SP farm then you do not need the Enterprise edition. Enterprise edition is a lot more expensive; and it gets really expensive as you add more processor core. In your case, I would go with the Standard edition of SQL Server 2008 (or 2008 R2 or 2012). Avoid the Express edition if you can because sooner or later you will hit the express edition limitations. –  Hossein Aarabi Nov 7 '12 at 19:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.