You can use Transact-SQL or SMO to issue backup and restore commands. To write a backup to Microsoft Azure Blob storage, you must first create a Microsoft Azure Storage account, then create a SQL Server credential to store storage account authentication information.
How to use the new featuresįeature 1: Backup and restore from SQL Server to Microsoft Azure Blob storage Expanding the supported features for SQL Server Sysprep to include SQL Server Analysis Services, SQL Server Integration Services, and shared features enables SQL Server Sysprep to be used in a wider variety of image preparation scenarios. However, there were many major features that were not supported by SQL Server Sysprep. This enabled images to be prepared with desired features and then completed later. For more details, see SQL Server Backup and Restore with Microsoft Azure Blob Storage Service.įeature 2: Expanding the supported features of SQL Server Sysprep to include Analysis Services, Integration Services, and most shared featuresĮarlier versions of SQL Server supported the preparing of images by using SQL Server Sysprep. This improvement can be used to back up a SQL Server database on an on-premises instance or on an instance of SQL Server that is running in a hosted environment, such as the Microsoft Azure Virtual Machine. In this release, backups to Microsoft Azure Blob storage are supported by using Transact-SQL and Server Management Objects (SMO).
More Information Features that are added in this cumulative update Feature 1: Backup and restore from SQL Server to Microsoft Azure Blob storageĮxpanding on current backup storage options, native SQL Server backups can now be stored in Microsoft Azure Blob storage. This article describes several new features that are added in the cumulative updates for Microsoft SQL Server 2012 and Microsoft SQL Server 2008 R2. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 Service Pack 1 fix release. Microsoft distributes Microsoft SQL Server 2012 Service Pack 1 fixes as one downloadable file.
SQL Server 2012 Enterprise SQL Server 2012 Standard SQL Server 2012 Developer SQL Server 2012 Web SQL Server 2012 Express SQL Server 2008 R2 Service Pack 2 SQL Server 2008 R2 Datacenter SQL Server 2008 R2 Enterprise SQL Server 2008 R2 Express SQL Server 2008 R2 Standard SQL Server 2008 R2 Web SQL Server 2008 R2 Workgroup Lainnya.