How to solve Operating system error 3
When using SQLBackupAndFTP you may have come across this SQL Server error when saving a database backup: Cannot open backup device ‘<Path\Filename>’. […]
How to Make SugarCRM Backup
Today over 50,000 companies use SugarCRM globally for their customer management, sales automation, and other CRM needs. SugarCRM can be installed as […]
How to set up SQL Server Email Job Notifications
As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good […]
SQL Server Copy-Only Backup
For many DBA’s, copy-only backups introduced in SQL Server 2005 are a little-known and little-used feature of SQL Server. However, they can […]
How to set up Cloud-based Storage for SQL Server Backup
A central tenet of Disaster Recovery (DR) is that you should always maintain an offsite or off-premises copy of your critical database […]
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 […]
RESTORE VERIFYONLY and CHECKSUM options
For any SQL Server DBA who’s been in the field for a long time, you know that the exercise of restoring backups […]
How to skip databases in Offline state in SQLBackupAndFTP
If you have a database in the OFFLINE state and these databases are scheduled to be backed up, their backup will fail […]
How to exclude databases from a backup job in SQLBackupAndFTP
SQLBackupAndFTP has an option to backup all non-system databases. This is useful as it would automatically add all the new databases added […]
SQL Server backup report
Sometimes it helps to have simple access to detailed information about your latest backups. This is why a backup report always […]