The latest version of MS SQL Server 2014 can be termed as a Hybrid Cloud Platform because of Windows Azure Integration features present in it. With this unique feature you can now host your database’s log files and data files in Azure cloud storage. It contains new tools that allows managing easy backup on Windows Azure Storage and also in creating Windows Azure Virtual machines for deploying database. This feature stores the database in a container inside Windows Azure Storage. One can create as many containers as they want under an account but up to a limit of 100 TB.
In spite of the added features, this version of SQL comes with some limitations as well. The inbuilt OLTP data cannot be transferred or rather saved in the Azure Storage. Same is applicable for the File Stream data as well. Moreover, it doesn’t allow multiple instances to access the same database file at the same time. But these limitations don’t hamper the utility that it offers. Users can create their own Virtual Machines in azure and take back up of database there. If the primary database is on premise then the failover and backup has to be done manually. Otherwise if the primary database is on Azure then the failover and backup is automatically synched.
SQL Server 2014 residing on Azure VM allows backup of both instances and databases on Azure itself. These features are what are known as Windows Azure Integration. Moreover it allows users to deploy databases to instances of SQL Server on Windows Azure Virtual Machine. The installation wizard is pretty simple and one can do it by following the instructions. Setting up of Secondary instances in Azure is also integration. In case the primary fails, it allows ongoing read operations to continue. The high point of some new Windows Azure integration features in SQL Server 2014 is that it gives the flavor of Hybrid Cloud along with a Database requirement.Tags: