In this blog we would learn how to fix Msg 4353 – Conflicting file relocations have been specified for the file. We solve this error very quickly.
SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While recovering a cluster in ForceQuorum mode, dropping an availability group failed: Failed to destroy the WSFC group. Here is how I got past this error.
SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint
Error 9642 in the ERRORLOG: an error occurred in a Service Broker/Database Mirroring transport connection endpoint. Here is what caused it for my client.
Spotting Unusually Small Backups Against Each Database’s Average
Flag unusually small backups against database-specific history, use aggregate filtering, and investigate alerts without assuming data loss.
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.
Fix Error 3637: Backup Fails on a DAC Connection
To fix error 3637, find out why your backup runs on a dedicated administrator connection. This post reproduces the message with sqlcmd and its -A switch, shows the same backup working on a normal connection, and lists where a DAC hides in scripts and scheduled tasks.
Tracking Backup Throughput and Duration From msdb History
Track backup throughput and duration from msdb history, compare recent trends, and keep striped devices from duplicating backup totals.