How To: Backup a Database To Local SQL Server

To backup a database to a local SQL server:

  1. Select the SQL Server item in the Backup Destination section of the SQL Azure page.
  2. In the Server name field, specify the name of the SQL server.
  3. In the Authentication field, specify the name of the SQL Server server.
  4. In the User name field, specify the SQL Server login account.
  5. In the Password field, specify the password for the SQL Server login account.
  6. In the Database field, specify the database name.

NoteNote:

If the database and the table with the same name already exist in the SQL Server, the data in the table will be lost.

See Also