SQL Server Log shipping Copy Job Failing without error

by

We did setup of a fresh log shipping for one of the customer. It was setup without any issues. Log shipping backup, copy and restore jobs were created as well. We restored full and subsequent log backups from primary to secondary for initial sync. Log shipping backup job was working fine as well. However SQL … Read more

SQL Server 2017/2019 Reporting Services Edition Upgrade

by

Few days back, one of our customer reported that his SQL Server 2019 reports were not accessible. We had a look at SQL Server Reporting Services logs. We observed below error messages in log: We checked edition for database engine as well as reporting service. We were not surprised to know that it was evaluation … Read more

Error code: 22903, text: ‘Another connection is already running ‘sp_replcmds’ for Change Data Capture in the current database.’.

by

Recently I faced very interesting scenario where for a database both change data capture and transactional replication was enabled. As per MS documentation, both features can work together but we need to keep few things in mind while implementing both features together on a database. Coming to my case, although change data capture job was … Read more

Ola hallengren Index maintenance – Optimal way to use it

by

This code will execute IndexOptimize stored procedure and will reorganize or rebuild indexes based on default fragmentation values ( i.e., 5 and 30% – rebuild). However, this will not update statistics as default set to null.

Database stuck in single_user mode after COPY database wizard

by

Recently one of our customer called in for help as his database got stuck in SINGLE_USER mode after he tried to copy database using Copy Database wizard. Using detach and attach method in database copy wizard does not allow any user connections to the source database thus puts the database in single_user mode in initial … Read more

OLA Backup job not deleting old Transaction Log Backups

by

Recently I encountered one issue where OLA Hallengren transaction log backup job was not deleting old backup files for one particular user database. While for other databases it was deleting the files as per retention period mentioned against “CleanupTime” parameter. “CleanupTime” parameter was mentioned as 48 hours but there were log backup files older than … Read more

Log file full due to snapshot replication

by

Log File Truncation Pending for Replication in Snapshot Replication

Azure SQL DB

by

Hi All,

This post was written to serve as a repository for important links that may be of assistance to anyone. The idea is to have a library of articles on hand and on the internet for ease of access.

Read more

Always On Secondary replica database in Synchronized/In Recovery mode

by

Recently while working on one alert, when I logged onto the server and connected SQL instance, noticed that on one of secondary replica in AlwaysOn availability group was having databases in “Synchronized/In Recovery” mode. This is not the usual status for secondary replica databases. Replica was configured in synchronous commit mode and databases were not … Read more

Fixing Application Latency and Timeout issues in Multi-Subnet Always ON SQL Server Setup

by

Issue Application Team complained about latency in connecting to database through listener name. They also complained about application taking more time to connect to database after Always ON Group failover. Sometimes they observed application timeouts as well. Underlying database was part of Multi-Subnet Always ON SQL Server. Application was connecting to database using Listener IP. … Read more