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.

Our production app is in a datacenter, on our gear.

We are looking to set up a DR site in Amazon EC2.

For starters, we will need SQL Server, and we will do encrypted log shipping to the instance.

Any tips for running a production SQL app on EC2 ?

We use SQL Server 2008 Standard Edition.

Specific questions and concerns:

  • Where do you put the DB, since the instance SQL Server is transient storage? -- Answer: Use EBS, per http://aws.amazon.com/running_databases/
  • My understanding is that the instances can reboot once or twice a year. How does one manage this for a production sql server setup? -- Answer: Use EBS for the db's, save your ami instance so it is all configured for the data location on EBS
  • Can someone attest to running a 100-400gb SQL Server db on aws?

Thanks!

share|improve this question

closed as too broad by Magellan, Dave M, squillman, kce, Ward Oct 17 '13 at 4:33

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

to run windows server into s2 is nothing special. you can get more info at http://aws.amazon.com/windows/ to transfer the logs you can use different strategies as FTP, ssh etc.

share|improve this answer

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