Blog

Azure SQL Database is a managed cloud database-as-a-service. It provides application developers with SQL Server databases which are hosted in the cloud and fully managed by Microsoft. The service is very easy to start with. Several clicks in the portal and you have a database running. Now you can copy the connection string to your application config file, and boom - you have all up and running. No installation, no license to buy - just pay the hourly fee. Any production database is a very important asset, so we are used to give it a good care in self-hosted scenario. A number of questions appear when you try to apply those practices to the cloud offering: How do I make a backup of my database? Where should I store it? How do I move my database including schema and data from on-premise to the cloud? How do I move it from the cloud to my local server? What is a point-in-time restore offered by Azure? Should I use geo-replication? What is geo-restore? In this post I'll