SQL Server with Storage in Cloud instead of SAN

Posted on 2011-10-26
Last Modified: 2014-11-12
Hi experts!  i was wondering about the feasability of having a server with just the Storage drives in the Cloud, even temporarily.  Would that just be so slow and not worth it, or is that possible even in the short term?  The reason i ask is we are looking to move some servers and i thought if we could set one server up with the storage in the cloud, we could then just ship the server over and use replication until the time we send the actual production servers over with the SAN if that makes sense?  Otherwise we will need to either buy a small SAN or copy backups to huge storage devices or cloud space (we are talking about approx 6 TB of data ). Below is kind of the process I am thinking of, I welcome thoughts, suggestions, etc. Thanks...

Location A has 1 SAN with all servers attached:

Move Dev to Location B (SAN has to stay for now so need storage here)

Switch to Use Dev at Location B as primary.

Shut down Location A Prod/Test/SAN and ship to Location B

Restore Prod from Dev Location B

Switch to use Location B Prod as primary

Question by:CRBam
    LVL 9

    Expert Comment

    by:Evan Cutler
    if your going to use the cloud, I'd use one that is rigged for your systems

    SQL Azure (Microsoft) is a cloud based SQL Server.  it costs $100/mo for 10TB.
    I'd use that for your movements.

    Author Comment

    Thanks for your response! If we went with SQl Azure,would that require any changes to our configurations, application code, SPs, etc? Or would it act exactly as our Test and Prod servers which are SQL Server 2008 R2?
    LVL 9

    Accepted Solution

    not the way I've been told.
    It sounds like your given a connection string, and SMSS connection node, and you fire as if you had two local servers.

    Give it a shot:
    LVL 9

    Expert Comment

    by:Evan Cutler
    I think tho, you would have to update your appcode to the new connection string's like if you moved your database to a different host.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now