Tag Archives: database

How to backup Azure SQL Database to Local Machine

Database Backup, SQL Server, sqlbackupandftp, , , , , ,

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

SQL Server, , , ,
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 →