Category Archives: sqlbackupandftp

How to backup SQL Server to UNC Path

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

Cannot perform a differential backup because current backup does not exist

cannot perform a differential backupCannot perform a differential backup for database, because a current database backup does not exist” is not a common error, which is why you might have a hard time finding a solution or an answer to it. 

This is why we have written an article to explain why this is happening and how to resolve this problem. Click to find out more details! Continue reading Cannot perform a differential backup because current backup does not exist

Backup SQL Server Database from command line with SQLBackupAndFTP version 10 or earlier

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 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

How to backup a SQL Server database to NAS drive

backup a sql server database to nasBacking up your database is one of the most important tasks a DBA should have set. There are multiple options in terms of backing up a database, for instance, you could backup a SQL Server database to NAS drives.

If you prefer this option or if your organization requires you that you backup your databases on your local network then you can count on SQLBackupAndFTP to assist you with this and make the job much easier!
Continue reading How to backup a SQL Server database to NAS drive

How to verify SQL Server backup files after backup

verify sql server backup files after backup
One of the most often made assumptions is that if you have made a backup of your database, your data is safe.
 Unfortunately, this is not true, and I’ll explain why, but don’t forget to verify SQL Server backup files after backup!
SQLBackupAndFTP allows you to do this, in order to be absolutely sure that indeed, your data is safe!

Continue reading How to verify SQL Server backup files after backup

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 get SQL Server backup email notification

SQL Server backup email notificationEver needed to know if your backup job has finished successfully or has encountered any issues?

Would you like to get from SQL Server backup email notification to let you know if your task has successfully finished or not?

Read this article to find out how to do this, really easy with the help of SQLBackupAndFTP
Continue reading How to get SQL Server backup email notification