SqlBak Blog - Page 16 of 19 - Backup and monitor SQL Server databases from the web

SQL Server backup to URL (Azure Blob Storage)

February 23, 2024March 30, 2014 by Omelchenko Alexander

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

March 8, 2024March 29, 2014 by Omelchenko Alexander

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

May 9, 2024March 29, 2014 by Omelchenko Alexander

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

May 9, 2024March 29, 2014 by Omelchenko Alexander

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

May 9, 2024March 26, 2014 by Omelchenko Alexander

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

May 9, 2024March 25, 2014 by Omelchenko Alexander

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

May 9, 2024March 24, 2014 by Omelchenko Alexander

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

May 9, 2024March 24, 2014 by Omelchenko Alexander

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

May 9, 2024March 23, 2014 by Omelchenko Alexander

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)

May 10, 2024March 8, 2014 by Omelchenko Alexander

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.