Create Azure DB with copy of way met low performance issue(1G Data need 20+mins) RRS feed

  • Question

  • Since Middle of Decenmber 2011, I met this issue.

    And most of my testing failed at testing preparation step as this low performance issue.

    We try to use the copy from backup DB to do the test DB preparation and then do data sync through the DSS.

    The backup Database has 1G size data failed both with 1tablek with 1000000 rows or 1tablek with 40000 rows.






    This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, January 12, 2012 8:19 AM


  • Hi Ping,

    Could you please post the error message about the failure? There are arguments you may pay attention to while you create a database with copy of on SQL Azure database, please see the scenarios not supported  and Database Copies section on this article: http://msdn.microsoft.com/en-us/library/windowsazure/ee336274.aspx.

    It will be helpful to ask this type of question on SQL Azure froum if you cannot work around this issue with the information above.


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, January 30, 2012 6:35 AM
    Monday, January 16, 2012 3:40 AM