locked
Can we backup a SQL Server Standard instance and restore to an Azure Windows VM? RRS feed

  • Question

  • Hi,

    We have used a SQL Server Standard VM when we should have used a standard VM and installed our own SQL Server. We have set up another VM that merely used the original c: and d: as disks, but we are still being charged for the SQL Server Standard VM.

    I am assured that there is something on those disks that tell Azure to charge for SQL Server Standard, even though we don't actually used the database. 

    One way to rectify this is rebuild the environment on a standard VM. That will take us a week becuase it is a specific SharePoint installation.

    Can we backup the existing disks/VM , whatever and restore to a standard VM with our own SQL? If so how? It is hard to imagine there aren't others who have incorrectly chosen SQL Server Standard and want to just use a standard VM and avoid extra SQL Server charges.

    thanks for your input.

    Leigh
    Monday, March 17, 2014 5:01 AM

Answers

  • HI

    here is my solution,

    1 create a extenstion disk(E:), try Create a Full Database Backup (SQL Server) save the DB file to disk E:.

    2 dis-attach disk E:, and attach it to your standard VM.

    3, save this disk as your backup, delete your SQL VM.


    Please mark post as answered if it helped!

    • Proposed as answer by Susie Long Friday, March 21, 2014 7:10 AM
    • Marked as answer by Susie Long Monday, March 31, 2014 1:31 AM
    Tuesday, March 18, 2014 2:56 AM

All replies

  • HI

    here is my solution,

    1 create a extenstion disk(E:), try Create a Full Database Backup (SQL Server) save the DB file to disk E:.

    2 dis-attach disk E:, and attach it to your standard VM.

    3, save this disk as your backup, delete your SQL VM.


    Please mark post as answered if it helped!

    • Proposed as answer by Susie Long Friday, March 21, 2014 7:10 AM
    • Marked as answer by Susie Long Monday, March 31, 2014 1:31 AM
    Tuesday, March 18, 2014 2:56 AM
  • Hi Yuan,

    Thanks for your suggestion. It seems remarkably simple. Have you tried this yourself?

    Leigh

    Tuesday, March 18, 2014 2:59 AM
  • No I haven't but I believe this can be done.

    If you meet any problem  about that, you can post here, I will try that.


    Please mark post as answered if it helped!


    • Edited by Yuan2013 Tuesday, March 18, 2014 5:28 AM
    Tuesday, March 18, 2014 5:27 AM
  • Hi,
     
    Anything updates now?

    If you need further assistance, please feel free to let us know.
      
    Best regards,

    Susie

    Thursday, March 27, 2014 8:06 AM