Backup best practices shortcuts
Many of the backup best practices we have presented in our detailed article can be easily applied through two software solutions.
We will take up each of the items in the list and try to quickly and efficiently detail how you can use them with these two applications.
Set up automatic backup schedules
You can very easily do this with SQLBackupAndFTP and set up your backup schedules to run automatically with a great degree of flexibility regarding any terms.
Also, SqlBak offers you similar options in terms of scheduling a job to backup your database, except this one is done automatically, from the web.
Backups should not be stored on the same physical drive as the database
This is a really important one and it can also be found on both applications.
Both of them have the option of creating the backup files on different storage platforms, be it a personal FTP storage or a commercial storage platform.
SQLBackupAndFTP provides you with these options:
While SqlBak gives you access to the following platforms:
Use all available verification options when doing backups
This is also an important aspect for making sure that wherever your backups are stored, they are consistent files and you will not have errors during the restore process.
All of these three best practices can easily be accomplished with both software products through setting up an automatic schedule to to these three types of backups for you.
Backup system databases
Backing up system databases is a must in case you change instances, because these databases contain system configuration and also SQL Server job information which otherwise would have to be redone in case of a total system restore.
SQLBackupAndFTP lets you select these databases easily:
SqlBak also has this option available right from the browser: