Continue reading Best place to backup your data?
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
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. Continue reading Copy-Only backups
The way you set expiration date on a backup for SQL Server databases is quite easy. You have two options of doing this. In order to find out, read the following article where we will show you both options. Continue reading How to set expiration date on a backup
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. Continue reading Mirror Backups
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. Continue reading Media errors during backup or restore
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.
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 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
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 is, obviously, improvements related to backups and restores. Here is a shortlist with improvements. Continue reading SQL Server 2014 for backups