SQL Server – types of backups

types of backupsSQL Server offers multiple options when it comes to creating database backups. 
There are multiple types of backups for your databases, which will serve you in different situations. 
In this article, we will try to show you what are the basic types of backups, when and why to use them. 

Read more

Best place to backup your data?

best place to backup

There are multiple online solutions where you could store your SQL Server backups, but because there are so many you might not know which one to choose. 
In this article, we will try to go over some of the most popular solutions in order to help you decide what is the best place to backup and store your most important data.

Read more

SQL Server backup to URL (Azure Blob Storage)

SQL Server has a feature that allows you to save a backup immediately to Azure Blob storage, without intermediate storage on a local disk. This speeds up backups and also allows you not to worry about free space on the local disk for temporarily saving backups. The principle of operation SQL Server itself can connect … Read more

How to make a point in time restore – T-SQL

point in time restoreThe point-in-time restore is a feature of SQL Server databases that allows you to recover an exact state of your database that is specific to an exact point in time.

This option is available ever since the logging for this action has been activated (transaction log).

This article is a continuation of a previous article where we demonstrated how to do such a restore using SSMS.

Read more