Availability Group Listener
I have four servers: a Domain Controller server, a Primary SQL Server, a Secondary SQL Server, and a fourth server intended to be the Listener server. All three servers—the Primary SQL Server, Secondary SQL Server, and the Listener server—are joined to…
SQL Server Database Engine
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I am trying to install SQL server 2022 and I keep getting the same error: Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log…
SQL Server Database Engine
I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms
I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms
SQL Server Database Engine

SQL Server Buffer Pool Persistence Feature Request
SQL Server Buffer Pool Persistence Feature Request Could SQL Server implement a feature to export buffer pool data? This would eliminate the need for data warm-up after database restarts or initial startups. By directly importing previously saved buffer…
SQL Server Database Engine

MSSQL connection in Visual Studio Mac->(Socket Exception)
HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…
SQL Server Database Engine
Unable to install SQL server. Error code : -2068119551
I keep fail to install the SQL server. I have already tried using Basic and Media which is ISO. When i used ISO, the error is -The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an…
SQL Server Database Engine

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..
I'm trying to patch SQL Server 2019 in a clustered environment. The setup is failing with this error: Setup has encountered the following error: Failed to retrieve data for Summary.txtthis request..Detail.txt
SQL Server Database Engine
Issue to restore the schema
Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following USE db_to_restore go ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE go but it…
SQL Server Database Engine
Third party backup tools for SQL server
Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.
SQL Server Database Engine

MDS migration - No data in the mdm view MasterDataServices
Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…
SQL Server Database Engine
SQL Server error code 4014 on Linux
Hi there! I'm getting an error 4014, severity 20, state 10 error in my SQL Server error log. It seems to happen at random intervals. This is for a SQL Server 2022 instance running on Red Hat Enterprise Linux 9.5. The client is making a connection using…
SQL Server Database Engine
While upgrading SQL server showing mentioned error all settings and bit are same.
While upgrading SQL server showing mentioned error all settings and bit are same urgent
SQL Server Database Engine
How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?
Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…
SQL Server Database Engine
Failed to update the SQL server 2019 CU27+GDR with KB5040948
Dear All, Currently I'm facing and issues of applying SQL server 2019 CU as below: Summary the Step: 1. Unable to open the file installer of KB5040948, as below: The below are the error logs in Setup Bootstrap log: Overall summary: Final result: The…
SQL Server Database Engine
Not able to see 'select instance' option while upgrading the server.
while upgrading the SQL server 2017 to 2019 in upgrade process in my company laptop not able to see 'select instance' WhatsApp Image 2025-04-26 at 3.48.07 PM.jpeg option. 1.server name is correct. 2.upgrading same instance. How to fix the issue to…
SQL Server Database Engine
Server Agent job running an SSIS package fails with the error: “The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.”
Server Agent job running an SSIS package fails with the error: “The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.”
SQL Server Database Engine
sp_executesql is not working when sql server is running in a container
sp_executesql is not working when sql server is running in a container. The issue only happens when I specify collation as Latin1_General_BIN docker command: docker run -d -p 1433:1433 -e 'ACCEPT_EULA=Y' -e "MSSQL_SA_PASSWORD=$db_password" -e…
SQL Server Database Engine

SQL Database writes suddenly slow.
Writing to SQL Server Database has suddenly become very slow since April 26th 2025. Everything is run on premise within the same region. Nothing has changed on our end. Writing tasks that once took 11 seconds now take 3 minutes. Writing tasks that once…
SQL Server Database Engine
How to index vector fields for semantic search in sql server azure
CREATE VECTOR INDEX idx_OpenAIEmbedding ON dbo.table_name (OpenAIEmbedding) WITH ( VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension SIMILARITY_FUNCTION = 'COSINE' ); Started executing query at Line 1 Msg 343, Level 15, State 2, Line…
SQL Server Database Engine

How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.
How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.
SQL Server Database Engine
