Naveen Khandelwal

Taking SQL Server Backups in yyyymmdd_hhmmss format

by

When we configure native log shipping, it takes log backups in yyyymmdd_hhmmss format. Recently, we had requirement where customer wanted us to take other native backups in yyyymmdd_hhmmss format. We used below code for taking different backups in required format. Full Backup Differential Backup Log backup

SQL Server Express Edition Limitations

by

I have mostly seen standard and enterprise editions in customer environments. However there are few customers who keep SQL Server Express edition and later understand its limitations. One customer wanted to upgrade his express edition and wanted to know major limitations of express editions so that he can convince his management for edition upgrade. So … Read more

Handling SQL Server High CPU Issue

by

High CPU on a SQL Server could have various causes and we need to provide the resolution accordingly. One of our customer reported CPU being 100% for few hours and it was not going down even for few seconds. Majority of CPU workload was due to SQL processes only. This customer had never complained about … Read more

Row was not found at the Subscriber

by

We got one replication related alert for one of the critical database. Distribution agent was failing with below error message: The row was not found at the Subscriber when applying the replicated DELETE command for Table ‘[dbo].[TableXXX]’ with Primary Key(s): [PrimaryKeyID] = 12345678 (Source: MSSQLServer, Error number: 20598) Above error could be seen in replication … Read more

Upgrade OS on MS SQL Server Box

by

Recently we got one request to upgrade OS of a MS SQL database server. Customer asked us to perform in-place upgrade from Windows 2012 datacenter to Windows 2019. We educated customer that in-place upgrade should be avoided considering associated risks. However, customer was fine with risks considering it was a development database server. Anyways, customer … Read more

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

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

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