SQL Server 2012 SP1 CU2 Adds Backup, Restore of On-premises Database to Azure

SQL Server 2012 SP1 Cumulative Update 2 simplifies backup and restore capability of an on-premises SQL Server database to Windows Azure. Microsoft releases ODBC Drivers for SQL Server, Job History & Data Source Options to Bing Maps Spatial Data Services, and Windows Server Solutions BPA Updated January 2013.

Share online:

SQL Server 2012 SP1 Cumulative Update 2 includes a new functionality that simplifies the backup and restore capability of an on-premises SQL Server database to Windows Azure.

In addition to disk and tape you can now use SQL Server native backup functionality to back up your SQL Server Database to the Windows Azure Blob storage service.

In this release, "backup to Windows Azure Blob storage is supported using T-SQL and SMO. SQL Server Databases on an on premises instance of SQL Server or in a hosted environment such as an instance of SQL Server running in Windows Azure VMs can take advantage of this functionality," Microsoft stated.

Refer these documents:

Also, Microsoft ODBC Drivers for SQL SQL Server on Windows and for SQL Server on Linux. These new ODBC drivers also include additional functionality not available in the previous versions.

Microsoft notes, that it is adopting ODBC as the de-facto standard for native access to SQL Server and Windows Azure SQL Database--that will result in ODBC drivers for Windows and Linux being better aligned going forward.

To this end, Microsoft is aligning and renaming the previous ODBC drivers as follows:

  • "SQL Server Native Client (SNAC) along with its ODBC functionality is now called Microsoft ODBC Driver 11 for SQL Server on Windows;
  • Microsoft SQL Server ODBC Driver 1.0 for Linux along with its functionality is now called Microsoft ODBC Driver 11 for SQL Server on Linux."

Key features for the Windows version include:

  • "Driver-aware connection pooling: Driver-aware connection pooling allows driver writers to customize the connection pooling behavior in their ODBC driver.
  • Connection resiliency in the Windows ODBC Driver: To help improve resiliency for cloud scenarios, the ODBC driver on Windows can restore broken connections along with a session state to a Windows Azure SQL Database.
  • Asynchronous Execution (Polling Method): An application thread can call an ODBC function in asynchronous mode and the function can return before the
    operation is complete, allowing the application thread to perform other tasks.
  • Beginning in the Windows 8 SDK, you can determine that an asynchronous
    operation is complete using the notification method. Learn more about Asynchronous Execution (Polling Method)," infomrs Microsoft.

and the new Linux version:

  • "Connect Linux to Windows Azure SQL Database: You can now connect from both Linux on-premises applications and Windows Azure Linux-supported VMs to Windows Azure SQL Database.
  • High Availability Support: Support for SQL Server 2012 AlwaysOn Availability Groups to enable High Availability and Disaster Recovery for Linux-based applications.
  • SQL Trace Support: Expanded tracing now supports Linux ODBC to help you know what your Linux-based application is doing all from the same SQL Trace experience," Microsoft adds.

Download links: Microsoft ODBC Driver 11 for SQL Server

Microsoft alos released Update Rollup 4 for Windows Server Solutions BPA (KB2796170) via Microsoft Update. New rules added with this relase:

  • "DefWebSiteExtended - This rule checks whether the default website is extended correctly.
  • RemoteVDirAuthentication - This rule checks whether Anonymous Authentication is disabled.
  • SelfUpdateVDirSSL - This rule checks whether the SSL protocol is enabled or Anonymous Authentication is disabled in the SelfUpdate virtual directory," Microsoft blogged.

Finally, Bing Spatial Data Services now makes it easy to view your job history.

"With the new ListJobs API , you can return a list of all geocode jobs and jobs that made changes to data sources in the last 15 days for any Bing Maps Account. Pending jobs are listed first. All you need to do is provide a Bing Maps Key from your Bing Maps Account with the following URL," Bing stated.

Windows Update Notification

Windows Update Notification