title: Database backup of azure database deployed in local sql server management studio
body: <p>Can anyone help me in doing this task? I am using my sql azure database in my local machine's sql server management studio 2008 r2. What my issue is, I am trying to take backup of a database from my c# console application using the following methods:</p>
  
  <ul>
  <li><p><strong>using smo</strong>: showing error at "sqlBackup(server)" method.
  The error details like -</p>
  
  <p>System.IndexOutOfRangeException: Index was outside the bounds of the array.
     at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNam
  eToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)
     at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inSe
  rver)
     at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()</p>
  
  <p>at Microsoft.SqlServer.Management.Smo.AbstractCollectionBase.get_StringCompar
  er()
     at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCol
  lection()
     at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildCollec
  tion(Boolean refresh)
     at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetEnumerator()</p></li>
  <li><p><strong>using "backup database" command</strong>, this showing command not supported in this version of sql server. After searching in internet, i found that this command wont support for azure databases in ssms.
  Can anyone please provide me solution to solve this.</p></li>
  </ul>