(SQL) Tip of the Day: Point in Time Recovery

Today’s (SQL) Tip…

The new SQL Azure editions will back up your database for you. Microsoft Azure SQL Database has automatic backup enabled for all Basic, Standard, and Premium databases. The backup service creates periodic databases backups and transaction log backups. The backups of Premium databases are retained for 35 days, Standard databases for 7 days, and Basic databases for 24 hours.

You can utilize these backups to recovery your database in the event of deletion of data or the whole database. You can also use this to replace the use of CREATE DATABASE AS COPY on the same server.

You can read more about business continuity in SQL Azure here: http://msdn.microsoft.com/library/azure/hh852669.aspx