Tag Archives: backup

Backup Encryption | Part-2

In the first part we discussed the new feature of Backup Encryption which is introduced in SQL Server 2014, the post describes the benefits, restrictions, permissions required etc. Now let’s see this in action, the below mentioned scripts will generate Service Master Key, Database Master key and a Certificate which will act as an encryptor …

Backup Encryption | Part-1

We’ve been asking for this feature from a long time and it was one of the main reasons why third party tools were being used, they were minting money like anything. Thankfully Microsoft introduced this feature in SQL Server 2014, now you can encrypt the data while creating a backup at runtime and creates an …

SQL Tip-10 | SQL Server Database Backup to Cloud (Microsoft Azure)

Backup to URL is not new to SQL 2014, it was first introduced in SQL Server 2012 CU2, but you were allowed to use the URL in query only. Starting with SQL Server 2014 this feature has been totally integrated, now you can specify URL while taking Backup or doing Restore no matter if you are performing the task via Query, Backup\Restore GUI, Powershell cmdlets or using SMO.

SQL Server Webcast on Bulletproof Backup & Restore Strategy

First Webcast by Sarabpreet Singh on Bulletproof Backup & Restore Strategy

Related posts: SQL Server Webcast on Log Shipping Free SQL Server Webcast | Tap is the only Solution Ver.2 | 08-Nov-2012 MS Webcast | Lunch Time – Implementing SQL Server AlwaysOn | 15-May-2013 MS Webcast | Lunch Time – How to Monitor SQL Servers using Powershell – Part 1 | 26-June-2013