How to remove old SQL Server backups

remove old sql server backupHow to remove old SQL Server backups – quick tutorial: 
Managing storage space occupied by your backups is a task that should not require a DBA’s time. 
With SqlBak you can easily remove old SQL Server backups, periodically. 
In this article we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.

Read more

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