backup Archives - Page 2 of 4

Best place to backup your data?

December 27, 2021April 15, 2014 by Omelchenko Alexander

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.

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

Copy-Only backups

December 29, 2021March 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

December 24, 2021March 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

December 24, 2021March 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

December 29, 2021March 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.

Recover deleted data in SQL Server

February 29, 2024March 5, 2014 by Omelchenko Alexander

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.

Back up files and filegroups

February 28, 2024March 1, 2014 by Omelchenko Alexander

This article will go over the topic of how to back up files and filegroups in SQL Server using either SSMS or T-SQL queries.

Continue reading in order to find out why and when you should backup files and filegroups.

Backup History for SQL Server databases

February 29, 2024March 1, 2014 by Omelchenko Alexander

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.

SQL Server 2014 for backups

March 1, 2024February 27, 2014 by Omelchenko Alexander

So, SQL Server 2014 CTP2 has been released and now we can have a look at some of its new features before its official commercial release later this year.

What we’re mostly interested in is, obviously, improvements related to backups and restores. Here is a shortlist with improvements.

At the time this article was written only SQL Server 2014 CTP2 was available, so information related to this subject is limited to only what was known from the perspective of the CTP2 edition.