Failing to restore a database having ‘In-memory OLTP’ database

A few days ago, encountered a weird scenario where a ‘In-memory OLTP’ database had to be restored from its backup and it was failing to restore – precisely getting stuck in the Recovery state.  Checked the error logs and found the below log snippets and it was a SQL server 2016 SP1 instance.   2018-10-30 08:41:23.010…

2

SQL Server Management Studio (SSMS) working only when launched as an Administrator

Two weeks ago, I found one of my clients encountering an interesting issue where he found that the SQL server management studio (SSMS) works only when it is launched as an Administrator. But if it is launched as a normal user, SSMS does not work and throws exception. On launching SSMS as an user, even…

0

What is QDS_ASYNC_QUEUE wait type ???

A week ago, one of my clients’ faced an issue with the SQL server performance going poor post migration from SQL 2012 to SQL 2016. On delving deeper found that QDS_ASYNC_QUEUE was the major wait type. The client did have the Query Store enabled on the subject databases and found the below information on research. As…

2

SQL Server Failover cluster instance upgrade failure issue from 2008 R2 to 2012

Today, one of my clients’ production environment was facing an issue with the failed upgrade of a SQL Failover Cluster Instance from SQL 2008 R2 to SQL 2012. They were trying the upgrade since a couple of days and it was failing with the below error TITLE: SQL Server 2008 R2 Setup —————————— The following…

0

SQL Server detected a DTC/KTM in-doubt transaction

Few days back, one of my clients’ faced an issue with their Availability group getting into the resolving state. On checking the logs found that the issue was due to a split brain scenario and as it was a business critical issue, we resolved the issue by restarting the SQL server services on the Secondary…

0

Upgrade of SSRS from SQL 2008 R2 to SQL 2012

Yesterday, I encountered a weird scenario where in the SSRS component was failing to upgrade from SQL 2008 R2 to SQL 2012 where in the SQL database engine and all the other components succeeded. SSRS component upgrade was failing with the below error : TITLE: Microsoft SQL Server 2012 Setup —————————— The following error has…

0

Sharing TDE Encrypted Backup outside the organisation.

In order to share the TDE Encrypted Database backup with somebody outside the organisation, the below steps can be followed. ++ Create new temporary database in order to prepare a make-shift copy of the intended database. RESTORE DATABASE MyEncryptedDB_Temp FROM DISK = N’C:\Temp\EncryptedDatabase.bak’ WITH MOVE EncryptedDatabase’ TO N’C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\EncryptedDatabase_Temp.mdf’, MOVE N’EncryptedDatabase_log’ TO N’C:\Program Files\Microsoft…

0