Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can I install SQL Server 2008 Standard Edition that I got though BizSpark on Amazon EC2?

share|improve this question

1 Answer 1

It's possible to install MS-SQL on a Windows Server instance and generate an AMI of the server image, but since EC2 instances do not maintain local storage between instance restarts you'll need to do some serious thinking about how you are going to persist your database storage across instance restarts.

Amazon also offers pre-build AMIs with SQL Server installed and configured to use their EBS service which will persist data across instance restarts. You may be better off using one of their existing AMIs for this instead of rolling your own.

share|improve this answer
    
Definitely better to use the Amazon-provided AMI. That BizSpark copy of SQL Server 2008 need not go to waste, as it would be great for a local development/test environment. –  Skyhawk Sep 30 '10 at 21:39
    
thanks. We are already using SQL Server 2005 Express on Amazon. Our app is a 24x7 app, so there won't be a "restart" scenario. The reason I asked the question is because, since our DB will be growing beyond 4GB, soon we will need to upgrade to SQL Server 2008 Standard Edition. I was just wondering about the licensing issues with using BizSpark license on Amazon EC2. One problem with Amazon AMI having SQL Server pre-installed is that we will have to pay extra money for that. Since I have a BizSpark license that I can use in production, I would rather use it instead of Amazon AMI. –  Josh Oct 1 '10 at 4:19
    
Ah, well your question didn't mention anything about whether the license could be used there. That would have been a good point to mention. :) I'm not sure of an answer to that, but my gut tells me that it would be fine when installed on a standard Windows server there. We're talking about Microsoft though, so I wouldn't rely on my gut when it comes to their licensing terms. –  Justin Scott Oct 3 '10 at 1:01

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.