SQL Server Non Clustered Index CREATE taking forever to cancel
I ran a CREATE NON CLUSTERED INDEX command for 1.5 hours. Decided to cancel it because it was stopping other things running. The command has now been running for 22 hours. What is it doing that takes so long to roll back? The table is 2 billion rows and…
SQL backups are getting failed with below error
Error encountered while trying to open backup device. Error: [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Cannot open backup device '8122c6ff-b1c3-4550-a77b-c79a3066c737'. Operating system error 0x80770006(failed to retrieve text for…
Removing database from AG
I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica
Cannot add drive using Failover Cluster Manager - no disks suitable for cluster disks were found
I am creating a new SQL cluster to replace out old cluster. I created a new, two server cluster running Server 2022. I am told I need to add the disk to the cluster before I can install our SQL server software. I created a new volume in our PowerStore.…
Windows 11 Microsoft SQL 2022 Express Edition
Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block
Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
Debugging SQL Server on Linux from remote VS 2022 pc
Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…
SQL Server integration service installed with SQL Server management studio
Hi Can you please let us know if SQL Server integration service (or SSIS) which is a licensable product installed with SQL Server management studio (SSMS) (a non licensable product)? We have got instances of our DBAs mentioning that they can see…
My listview is listing only the id instead of 3 items on the table
PLEASE HELP ME I am working on sqlite database , i have the following code in c# maui return (await conn.Table<ServiceData>().ToListAsync()) ```.Where(s…
Managed Instance - Weekly report of logins
What's the best way to get a weekly report from an Azure Managed Instance giving all logon information (User, date, IP, success, etc)? I want all SQL logins and Entra ID logins. I've followed the steps detailed here:…
Path to Microsoft ODBC SSL Driver loaded libraries
How do configure dynamic loading of OpenSSL libraries for use MS ODBC? The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system. Our software is linked custom…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Reporting Services logs and database tables
hi all, Do the RS logs and various log database tables contain the same information? I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that…
The MSSQLSERVER and AGENT service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…
How to connect my c# application to my phpmyadmin database from my NAS?
Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
Dataset format needed for azure blob storage
How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…