SQL 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.
What is an SQL Server backup?
Why should you create an SQL Server backup?
How do you create a SQL Server 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.
SQL Server 2014 has been launched on April the 1st and we’re very excited about this new version as it promises to be a great one.
In this article, we will show you what are its new features and how they can help you become more efficient in your work through a more performant system.
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
Situations in which a restore operation is interrupted are not very uncommon.
This is why, in this post, we will show you what you have to do in order to restart the interrupted operation using T-SQL queries.
The 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.
The 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).
In this post, we will take the path of understanding what a recovery model is and how it relates to your database, and why it is important.
We will show you how to find out what is the current recovery model of your databases and how to change them.
You might have heard of this term, but you don’t know what it actually presumes.
Read this next article to understand what a copy-only backup is and how it fits in the big picture of SQL Server.
