Hi Friends, Today I again experienced the same old frustrating error while opening SQL Server Configuration Manager on one of the SQL Servers. Refer the screenshot below. The error says: Cannot connect to WMI...
A not so common but major issue could be missing Disk\Drive issue for any SQL Server, If there were user DB files on that disk chances are you’ll lose some data if the same...
In last part we discussed the installation, configuration and usage of the SQL Server Backup to windows azure tool.
In this part we’ll discuss some internals of this tool and how to restore the backups which were moved to Azure storage.
As you know there are so many cool benefits of using Windows Azure Storage Account, everybody want to use it to get advantage. Last month i blogged about “SQL DB Backup to URL\Cloud” feature which was first introduced in SQL Server 2012 and later in SQL 2014 it was integrated completely in every aspect.
But what if you are still running old version of SQL Server and want to take advantage of Cloud?
Backup to URL is not new to SQL 2014, it was first introduced in SQL Server 2012 CU2, but you were allowed to use the URL in query only. Starting with SQL Server 2014 this feature has been totally integrated, now you can specify URL while taking Backup or doing Restore no matter if you are performing the task via Query, Backup\Restore GUI, Powershell cmdlets or using SMO.