It’s important to verify SQL Server backup files after the backup process is complete. Although the process can finish successfully this does not guarantee that the integrity of the data in the backup file is valid. This will definitely cause some annoyance when later trying to restore the backup file. In order to avoid this unwanted scenario, you should use verification options …
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.
In this article, we will present you the main idea behind the SQL Server backup to URL feature which has been available since the 2012 SP1 CU2 version. This backup operation can be performed either from Powershell, T-SQL, or SMOs (SQL Server Management Objects), but in this article we will present you just the version with T-SQL.
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.