Omelchenko Alexander
How to set expiration date on a backup
Mirror Backups
Media errors during backup or restore
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
Recover deleted data in SQL Server
Backup History for SQL Server databases
Having a complete backup history of all of your backup and restore operations can become quite useful at times.
All the data that you might need to be related to this, like who created the backup, at what time, on what media, and many other details are stored in the system databases of the SQL Server instance.