Azure DB Backup/Restore Via SSMS 2014

This topic will provide details(on high level) of new features introduced in SQL Server 2014 Management Studio (SSMS) to Manage Azure Databases.

 

Enhanced Backup:SQL Server 2014 provides new Windows Azure integration to SQL Server's backup capabilities. You can specify a Windows Azure URL as the target for your SQL Server 2014 database backups. This new Windows Azure backup feature is fully integrated into SSMS.
 

In Backup Interface, you will see additional Option called "URL" as shown in the exhibit below,This option will backup the data on azure(cloud), 

 

Select "URL" as "Back up to" and provide the azure connection and file details to backup the data on azure.

 

Enhanced Restore: Same with the restores, you can choose URL as your Source…and provide the details accordingly as shown below.
 



 

Select "URL" and Click on "Add" Button

 

 

This backup and restore functionality are same or similar to when using DISK or TAPE, with a few differences.

 

Hope This Helps!

Deprecated/Discontinued DBEngine Features in SQL Server 2014

As we all aware, each and every new release of any software, we might expect changes in the release like, new features, update/upgrade on the existing features, outdated features due to compatibilities or alternate options.

 

The below link provides the list of the features and functionality that Microsoft is dropping from SQL Server 2014,

 

Deprecated Database Engine Features in SQL Server 2014

Discontinued Database Engine Functionality in SQL Server 2014

SQL Server 2014 CTP1

Microsoft has released SQL Server 2014 CTP1 Product Guide. This product guide release represents a significant milestone for customers and partners who want to experience the extensive new value delivered by SQL Server 2014 CTP1.

Download the datasheets, white papers and technical presentations from,
http://www.microsoft.com/en-us/download/details.aspx?id=39269

This will help you evaluate Microsoft SQL Server 2014 CTP1.