I am excited to let you know that SQLAzureMW now has two tools that can be used from a command line. One of the main requests from the SQLAzureMW community was to take the user interactive wizard and make it command line driven interface so that it could be used in an automated backup process to back up their Windows Azure SQL Database schema / data to a data store for disaster recovery. SQLAzureMW is a user interactive wizard that walks a person through the analysis / migration process. SQL Database Migration Wizard (SQLAzureMW) is an open source application that has been used by thousands of people to migrate their SQL database to and from Windows Azure SQL Database. Here’s the Compiled List of Windows Azure SQL Database Backup options Windows Azure SQL Database Backup and Restore Strategy - –sql-database-backup-and-restore-strategy.aspīusiness Continuity in Windows Azure SQL Database (Architecture and Design to protect from widespread loss of data). The following are the options that are available to you to create a backup of the data and schema: In order to protect your data against user/application errors or a total loss of a region you must create your own backup of the data. Please be aware that Windows Azure SQL databases are replicated to different servers / datacenters for disaster recovery but are not “Backed up” for the purpose of recovering accidental data loss or changes. Windows Azure has built-in fault tolerance to protect your data from individual server, network, and device failures. This topic introduces the concepts and the functionality available currently to back up and restore the data within Windows Azure SQL Database.ĭatabase backups protect the database against data loss caused by hardware failures, user, or application errors or a widespread loss of regional facilities. Windows Azure SQL database Backup and Restore Strategy:īacking up and restoring data is different in Windows Azure SQL Database than an on-premise SQL Server and must work with the available resources and tools.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |