SQL Server Backup Types
Regular backups are required to protect your database and ensure its restoration in case of failure. Various backup types provide different protection […]
Category: Database Backup
Category relating to database backups in SQL Server.
SQL Differential Backup
The crucial difference between SQL differential backup and a full backup is that differential backup includes all data that have been changed since the […]
Database Backup Software for MS Sql, MySQL, PostgreSQL
It’s no secret that scheduled backups are the best way to protect your database from disaster. In this article, we are going […]
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.
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 […]