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
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
Sometimes 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.
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
This article is an easy step-by-step tutorial and it will explain how to easily backup multiple servers and the databases that you want while using SQLBackupAndFTP.
One of the most important operations and tasks that need to be performed on a database is the backup process.
In this sense, you can prompt to backup a SQL Server database from the command line using SQLBackupAndFTP version 10 or earlier with some additional parameters, which are also passed in the command terminal.
Continue reading Backup SQL Server Database from command line with SQLBackupAndFTP version 10 or earlier
Make sure to encrypt SQL Server backups in order to add another level of security to your data.
Adding this option to your backups is extremely easy with the help of the Encryption option in SQLBackupAndFTP.
Read the short tutorial in this article below to encrypt your backups.
Continue reading How to encrypt SQL server backups
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.
Continue reading How to remove old SQL Server backups
As you might know already if you’re creating backups and also monitoring your server’s resources you have seen that the CPU is used intensively during the compression phase of the backup operation.
Find out in this article how to set 7zip CPU priority to LOW.
Continue reading Set 7zip CPU priority to LOW