Tag Archives: database

How to backup Azure SQL Database to Local Machine

Even though Azure SQL Database provides built-in backup, you may still want to create a local copy of your Azure SQL database. This could be handy for example when you want to keep database backup copy for free longer than allowed by Microsoft Azure built-in tools which are usually 7 to 35 days, depending on your service tier. Here we will explain in detail how to backup Azure SQL Database to a Local Machine.

Continue reading How to backup Azure SQL Database to Local Machine

SQL Server backup report

backup reportSometimes it helps to have simple access to detailed information about your latest backups. 
This is why a backup report always comes in handy when you need to know when was the last time your database or a specific database was backed up and what was the last type of backup that was taken. 
In order to help you with this, we’ve composed a small script which you can easily run to find out important information.

Continue reading SQL Server backup report