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 Cause…

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 VM from the…

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’…

0

Troubleshooting SSL on SQL Server Issue – AT_KEYEXCHANGE is not set

It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set to 1, for it to be loaded to the SQL server. Due to the glitches during the creation of the certificate there may be scenarios arising where in this value might not be set to 1. If…

0

Creating and Registering SSL Certificates

A few days back, I was working with one of our partners who had a requirement of creating a SSL self-signed certificate through MMC console. As we are already aware that it is a complex and a tedious procedure, tried developing a script to ease the task for us. Also found that there were a…

0

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 error…

0

Setting up Service Broker where the initiator database is part of the AG

  There have been several posts on setting up Service Broker where the database is part of the Availability Group. This is a one stop blog for setting up Service Broker where the initiator database is part of the AG What happens when the AG fails over? Should there be any additional steps in setting…

0

Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"

  I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to configure the new instance as Distributor I faced the below error: Error: —————————— TITLE: Configure Distribution Wizard —————————— ‘Prod\SQL16’ cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server…

1

How to find which user deleted the user database in SQL Server

  In one of the recent scenarios we noticed that a user database was deleted and customer wanted to which user has dropped the database. We know that multiple user had full access on that database. In this post I’ll be sharing the steps to find the details of user who drop the database. Method-1…

0

Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has failed with the following error while generating a snapshot, particularly during creation of BCP files. Error: 241, Severity: 16, State: 1 Conversion failed when converting date and/or time from character string. To further investigate the above error and to…

1