0 votes
in Azure by

What is the best way to back up SQL Azure data in Windows Azure?

1 Answer

0 votes
by

To deal with hardware failures, SQL Azure stores three copies of a database. You can use the COPY command to generate a copy of a SQL Azure database to deal with user-level problems. You can also use BCP, SSIS, and other tools to backup SQL Azure data to a local SQL server, but point-in-time recovery is currently unavailable.

...