Using Backup to URL in SQL Server 2012 instance

  In this post, we would like to explain on how we can overcome the limitation of using the feature “backup to URL” in Maintenance Plan wizard in SQL 2012   Symptoms We cannot take backups from maintenance plans using backup to URL to Azure Blob Storage using SQL 2012 Engine instance with 2012/2014/2016 SSMS….

0

Error: Could not deploy package. Unable to connect to target server.

In this post we would like to explain one of the interesting issue that we encountered while deploying a DACPAC from sqlpackage.exe. Symptoms Cannot Deploy DACPAC Extracted from SQL 2012 Server from .NET custom code or from SQLPackage.exe command to SQL 2014 C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin>SqlPackage.exe /Action:Publish /SourceFile:”C:\temp\AgentLink2_11.0.6020.dacpac” /tsn:”RAGHAVSDC” /TargetDatabaseName:TestACM Publishing to database ‘TestACM’…

2

SQL Server Service fails to start after applying patch. Error: CREATE SCHEMA failed due to previous errors.

  In this post we would like to explain one of the interesting issues that we encountered while upgrading a SQL Server Instance. Symptoms SQL Server Service fails to start after applying SQL patch due to misconfiguration in MSDB. Error:- 2016-06-28 19:23:41.22 spid5s    Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered…

0

Automated backups configuration fails when configured from Azure portal

  In this post, we would like to explain one of the interesting issues that we encountered while using the automated backup feature for a VM from the azure portal (We can find the option once we click on VM > SQL Server Configuration> Automated Backup)   Symptoms   Cannot Configure Automated backups in azure…

0

Automate SQL server backup file removal/deletion from Azure blob storage

  In this post, we would like to explain one of the interesting issues that we encountered while working with azure backups and restore. Symptoms Cannot delete the .bak files from azure blob storage through maintenance plans or any other options from SQL which have been backed up using backup to URL or managed backup….

0