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.
Copy-Only backups
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.
How to set expiration date on a backup
The way you set the expiration date on a backup for SQL Server databases is quite easy.
You have two options for doing this. In order to find out, read the following article where we will show you both options.
Mirror Backups
You might have heard of mirror backups, but you don’t know what they are exactly?
Well, in this article we will try to explain in the best way possible what they are, if you should use them and when you should use them.
Media errors during backup or restore
Media errors during backup or restore operations are quite stressful because usually, these tasks should run smoothly.
But just in case you happen to have one such error, then it would be ready if you would be prepared or have a bit of knowledge about these errors before you see them.
Learn SQL #5: How to write a SQL query (2)
This is the continuation of our previous article, where we go over the basics of the main SQL Query to build a database and its tables. Also, we went over the SQL query that you use to get data from your database.
Now we will continue with the queries that you use to manipulate the data in the system.
Learn SQL #4: How to write a SQL query (1)
So, in our previous articles, we introduced you to what is SQL, for what it is used, how it stores data in databases and tables, and how it works through commands (SQL query), and how the commands are different based on what SQL type you use.
Now that we have the overview, we are going to dive into writing our first SQL command, which in technical terms is called a query, as you might already know.
Partial Backups
Partial backups are a type of backup which was first introduced with SQL Server 2005.
These types of backups were designed for use with the simple recovery model in order to improve flexibility in terms of backing up very very large databases that can contain at least one read-only filegroup.
Recover deleted data in SQL Server
If you ever have the misfortune of having data deleted from the production database, don’t get upset as there is a way you can recover most of the missing data with the aid of Transaction Logs and LSNs (Log Sequence Numbers).
Here is a step-by-step solution on how to achieve this.
