SQL Server 2014 Backup

SQL Server 2014 Database Backup Encryption is away of Database Backup using Encryption Key and Advanced Algorithms ” AES 128, AES 192, AES 256, and Triple DES ” and it’s integrated with the Product.

Configure Backup

1- Create Database Master Key for Master Database.

USE Master
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'COmpl£xP@$$W0rd';
GO

2- Create a Backup Certificate in SQL Server 2014.

USE Master
GO
CREATE CERTIFICATE BackupEncryptionCert
WITH SUBJECT = 'SQL Server 2014 Backup Encryption Certificate';
GO

Screenshot (78) 

3- Backup Steps 

  1. Access Database using Management Studio
  2. Select Database
  3. Tasks
  4. Back UpScreenshot (79)
  5. in General Setting we can choose Back Up to Disk OR URL
    • Disk is a local storage in a traditional way.
    • URL is a new feature which enable to backup data on Microsoft Azure  using Credentials and Azure container.Screenshot (80)
  6. in Backup Options we can choose the Algorithms Screenshot (81)
  7. Click OK

 

 

Advertisements

One thought on “SQL Server 2014 Backup

  1. Pingback: SQL Server 2014 top New Features | Helmy Mohamed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s