Complete Guide to SQL Server Backup and Restore Using the Command Line

by

Creating backups of a SQL Server database is one of the most critical aspects of maintaining a system. There are various tools available for creating backups, such as SQL Server Management Studio, SqlBak, and SQLBackupAndFTP. However, performing backups via the command line interface can provide even more flexibility and customization options.

PowerShell and batch scripts can be used to perform SQL Server backups via the command line interface. PowerShell scripts offer advanced functionality, while batch scripts are simpler and easier to use. Command line backups provide more flexibility and customization options than GUI-based tools.

This article provides an overview of the process involved in performing SQL Server backups via the command line interface and discusses the advantages of using PowerShell and batch scripts.

Read more

SqlBak Best Practice Guide

by

This guide contains recommendations for setting up a SqlBak backup job. This information has been developed and collected over years of interaction with SqlBak users. There will be no theory and formulas, only practical advice.

Note that these practices are not the only solutions. They are suitable in most cases, but can be fundamentally wrong under various circumstances.

Let’s consider the steps that are used to set up a backup job.

Read more

SqlBak Guide: Backup Storage Selection

by

SqlBak supports sending to 16 different storage types. In one job, you can specify multiple backup storage locations, and for each storage location, you can specify the duration of backup storage on it.

Note:
SqlBak does not store your backups on its servers. Backups are sent directly from your server to the storage location.

Read more

MySQL Point-in-Time Recovery (PITR)

by

Point-in-time recovery is the concept of restoring data to a particular time in the past.

Suppose you deleted an important database table at 2 p.m. on a Wednesday. You realize this fifteen minutes later and you need to restore the data. Replication will do you no good, because the table in the replica has also been deleted. Only backups can save the day.

However, if you back up your data at 1 a.m. every day, the closest recovery point to when the table was deleted will be at 1 a.m. that Wednesday. When you restore data, you will lose 13 hours of data. But if you use the point-in-time recovery strategy, you can recover data as of 1:55 pm, losing only 5 minutes!

Read more

About MySQL Server Incremental Backups in SqlBak

by

What are incremental backups?

Incremental backup is a backup that only contain data that has changed since the previous backup, not including all the data in the database.

Why are incremental backups needed?

Incremental backups allow performing backups much more frequently, as they are much smaller in size. However, to restore from an incremental backup, not only the incremental backup file is required, but also the entire preceding chain of backups.

Read more