Tag Archives: backup

How to save SQL Server backups to Azure in SQLBackupAndFTP

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

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

How to backup to UNC Path

backup to unc pathIt’s important to have flexibility and not sacrifice security when backing up your databases. For this reason, some DBAs will prefer to backup to UNC paths on their local network.
This will keep the backups in a closed environment with access only to those users inside the network which are authorized.
In this article we will show you how to backup to UNC paths in the simplest way possible, by using SQLBackupAndFTP, instead of using complex and confusing T-SQL and complex maintenance plans.

Continue reading How to backup to UNC Path

Backup SQL Server Database from command line

backup SQL Server Database from command lineOne 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 with some additional parameters, which are also passed in the command terminal.
Continue reading Backup SQL Server Database from command line

How to perform SQL Server maintenance

sbf maintenance

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 encrypt SQL server backups

database encryption SQLBackupAndFTP
 
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

remove old sql server backup

How to remove old SQL Server backups – quick tutorial:
Managing storage space occupied by your backups is a task which 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