There are a lot of SQL companies out in the world that build relational database systems to take care of storing and managing your data.
SQL Server
SQL Server – types of backups
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.
SQL Server Backup – introduction
What is an SQL Server backup?
Why should you create an SQL Server backup?
How do you create a SQL Server backup?
Best place to backup your data?
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.
What’s new in SQL Server 2014
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 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 restart interrupted restore operations
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.
How to make a point in time restore – T-SQL
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.
How to make a point in time restore – 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).
How to change the recovery model on a database
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.