Tag Archives: backup

Best place to backup your data?

best place to backup

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.
Continue reading Best place to backup your data?

SQL Server backup to URL (Windows Azure) w/ T-SQL

backup to url
In this article we will present you the main idea behind 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.
Continue reading SQL Server backup to URL (Windows Azure) w/ T-SQL

Media errors during backup or restore

media errors during backup or restoreMedia 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.
Continue reading Media errors during backup or restore

Backup History for SQL Server databases

 Backup HistoryHaving 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 related to this, like who created the backup, at what time, on what media and many other details are store in the system databases of the SQL Server instance.
Continue reading Backup History for SQL Server databases

SQL Server 2014 for backups

 SQL Server 2014So, 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 is, obviously, improvements related to backups and restores. Here is a shortlist with improvements.
Continue reading SQL Server 2014 for backups