SQLBackupAndFTP.com presents you a free SQL Server Formatting Types Cheat Sheet. We spent several hours composing it for you.
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 to your database. The most popular database backup types are full backup, differential backup, and transaction log backup. Before you create your own backup plan you need to consider two things: your recovery point objective (RPO) – how much data can you afford to lose? And your recovery time objective (RTO) – in case of disaster, how much time can you spend restoring your database? Now let’s check out some of the backup types. Continue reading SQL Server Backup Types
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 last full backup despite the fact that they have been included in the previous differential backup. Continue reading SQL Differential Backup
Unable to Create Restore Plan Due to Break in the LSN Chain
Sometimes when you restore your database backup you can get an “Unable to Create Restore Plan Due to Break in the LSN Chain” error. Let’s see how to deal with it. Continue reading Unable to Create Restore Plan Due to Break in the LSN Chain
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 to explain, which database backup software is used for different database systems. Continue reading Database Backup Software for MS Sql, MySQL, PostgreSQL
SQL Server Express Backup
While it’s easy to create SQL Server Express backup with SQL Server Management Studio it’s quite difficult to run it regularly since SQL Server Express edition lacks handy job scheduler maintenance options in comparison with the full version of SQL Server. Here is where third-party backup utilities like SQLBackupAndFTP enter the stage. Continue reading SQL Server Express Backup
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. Continue reading How 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>’. Operating system error 3 (The system cannot find the path specified). Continue reading How to solve Operating system error 3
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 an on-premise solution or as a SaaS (Software-as-a-Service) solution. Managing SugarCRM means that you have to work with a huge flow of information that is stored in large databases. Clearly, when working with databases one has to take care of their security, and that implies making backups on a regular basis. Now let’s check how to use SQLBackupAndFTP for regular SugarCRM backups.
Continue reading How to Make SugarCRM Backup
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 idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications