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.
Microsoft’s own Windows Azure cloud is one of the most popular backup options for storage of SQL Server backups. It is especially attractive as an offsite storage medium for SQL Server backups because it is a Microsoft product and is already has tie-ins with the latest versions of SQL Server, beginning with 2012 Service Pack 1, Cumulative Update 2. Let’s take a closer look at how to save your SQL Server backups to Azure. Continue reading How to save SQL Server backups to Azure in SQLBackupAndFTP
If you have limited access to SQL Server’s file system, getting the .bak file back may be an issue. In this case, you can send database backup to some network folder if both you and the SQL Server have access to it.
We will show how to do it with SQLBackupAndFTP. Continue reading How to backup SQL Server to UNC Path
SQL Server maintenance is just as important as creating backups of your databases. Without a doubt, there are a lot of organizations that install a SQL Server database or more without setting their maintenance plans up first Things generally go smoothly and at the beginning, there is no problem, that is, until a problem appears. Continue reading How to perform SQL Server maintenance
How to remove old SQL Server backups – quick tutorial: Managing storage space occupied by your backups is a task that should not require a DBA’s time. With SQLBackupAndFTP you can easily remove old SQL Server backups, periodically. In this article we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.