Need help with setting up MS-SQL on EC2.

Posted by Hareem Haque on Server Fault See other posts from Server Fault or by Hareem Haque
Published on 2010-03-16T14:46:40Z Indexed on 2010/03/16 14:51 UTC
Read the original article Hit count: 329

Filed under:

ec2

|

ami

|

windows-server-2008

|

sql-server-2008

I have a large MS-SQL database that i need to send to the aws cloud. The issue is how do i persist my sql data and how to setup MS-SQL cluster using windows AMI.

The real issue is that for replication i need to use the private ip's of the instances. However, these ip's are always dynamic and will change on server launch.

Any ideas on how i can get rid of this problem.

I really appreciate your help

Best Regards Hareem Haque

© Server Fault or respective owner

Related posts about ec2

Why do I have to run aptitude update twice to install Ruby?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Summary. I have a fresh EC2 Precise 64-bit instance (ami-82fa58eb). After launching the instance, I want to install ruby1.9.1 (among others). This doesn't work: aptitude update && apt-get -o Dpkg::Options::="--force-confnew" --force-yes -fuy dist-upgrade && aptitude install -y ruby1… >>> More
Options for EC2 ec2-create-snapshot and family

as seen on Server Fault - Search for 'Server Fault'
I am trying to use the various tools provided by ec2-ami-tools Eg, ec2-create-snapshot -h .... -K, --private-key KEY Specify KEY as the private key to use. Defaults to the value of the EC2_PRIVATE_KEY environment variable (if set). Overrides the default. -C, --cert… >>> More
Amazon EC2 EBS automatic backup one-liner works manually but not from cron

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to implement an automatic backup system for my EBS on Amazon AWS. When I run this command as ec2-user: /opt/aws/bin/ec2-create-snapshot --region us-east-1 -K /home/ec2-user/pk.pem -C /home/ec2-user/cert.pem -d "vol-******** snapshot" vol-******** everything works fine. But if I add… >>> More
Amazon EC2 spot instances - is there a catch ?

as seen on Server Fault - Search for 'Server Fault'
I needed to start a new EC2 instance today and decided to try out the new spot instances, where you can reduce your instance cost by bidding on the maximum per-hour price you're prepared to pay. Since today's spot price was only 35c / hour, compared with 85c / hour for an on-demand instance, I was… >>> More
Amazon EC2 spot instances - is there a catch ?

as seen on Server Fault - Search for 'Server Fault'
I needed to start a new EC2 instance today and decided to try out the new spot instances, where you can reduce your instance cost by bidding on the maximum per-hour price you're prepared to pay. Since today's spot price was only 3.5c / hour, compared with 8.5c / hour for an on-demand instance, I… >>> More

Related posts about ami

Create an AWS HVM Linux AMI from an Existing Paravirtual Linux AMI

as seen on Server Fault - Search for 'Server Fault'
Is it possible to create a hardware virtual machine (HVM) AMI from an existing paravirtual (PV) AMI. My initially thought was to start a new PV instance and use the ec2-create-image command to create a new image while specifying HVM as the virutalization type. However, ec2-create-image does not… >>> More
How to select and AMI when creating an instance of EC2

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Amazon EC2 for the first time, and need to create an instance that runs Windows, MSSQL Server 2008, .Net Framework 3.5 SP1 and IIS Server 6.0. I am unable to decide what AMI (out of the huge list of community AMIs) should I choose to meet my requirements. Is there a way I can make this… >>> More
BPM 11gR1 now available on Amazon EC2

as seen on Oracle Blogs - Search for 'Oracle Blogs'
BPM 11gR1 now available on Amazon EC2The new Oracle BPM 11gR1, including the latest Oracle SOA Suite 11gR1 Patchset-2 is now available as an Amazon Machine Image (AMI). This is a fully configured image which requires absolutely no installation and lets you get hands on experience with the software… >>> More
Available Instance types for marketplace ami's

as seen on Server Fault - Search for 'Server Fault'
I based my autoscaling AMI's on the Turnkey Linux nginx AMI from the marketplace. I am now unable to select any of the newer generation instance types; for instance, my autoscaling uses m3.large type but I'd really like it to use the c3.xlarge type but every time I try to create a c3.xlarge instance… >>> More
EC2 EBS AMI Instance stopping/restarting doesn't start services

as seen on Server Fault - Search for 'Server Fault'
I've recently been moving our instances to EBS instances (CentOS) and still have a bit of confusion on what's happening when I "stop" and instance. I have some of my services with runlevels 345 on but when I start a stopped instance the services don't start. What's actually happening when I issue… >>> More