How to setup SQL Auto Backup using SQLBackupAndFTP
In this post, we will show you how easy it is to setup SQL auto-backup using SQLBackupAndFTP.
Category: SQL Server
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 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 […]
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 […]
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, […]