151 questions
1 answer
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
asked 2025-05-02T08:55:59.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 33%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Talent Mabuto
0
Reputation points
answered 2025-05-02T10:01:10.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 28.999999999999996%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Alban Berisha
80
Reputation points
2 answers
One of the answers was accepted by the question author.
Why TUF file is required in Log shipping when uncommitted transactions are already in memory?
I know that while restoring the log backup, un-committed transactions will be recorded to the undo file and only committed transactions will be written to disk there by making users to read the database. When we restore next Tlog backup SQL server will…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2023-04-10T14:18:55.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
281
Reputation points
commented 2025-05-02T07:35:20.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY3%3C/text%3E%3C/svg%3E)
YaragoppaSunil-3326
0
Reputation points
1 answer
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
151 questions
asked 2025-04-25T03:14:41.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,731
Reputation points
edited a comment 2025-05-02T06:48:40.9333333+00:00
Peter_1985
2,731
Reputation points
1 answer
I need to find a missing report
I'm searching for a report for one of our specialists on 04/07/25 who is no longer with TD as of this month. However the specialist name is no longer listed under the team manager for TD bank. I've left a comment but I have no idea who it goes to our…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
asked 2025-04-29T12:38:40.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 22%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gordon, Cliff (he/him/his)
0
Reputation points
commented 2025-05-02T05:52:30.48+00:00
Olaf Helper
46,631
Reputation points
1 answer
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
151 questions
asked 2025-04-24T18:18:03.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 9%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Asharaf Pattarathil
0
Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper
46,631
Reputation points
1 answer
Sql Server to Excel
Hi Trying to export data from sql server to a Table formated excel. But after the data insert the Format of excel not coming properly. I mean the odd and even rows with different color Thanks
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T10:49:51.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SVA
116
Reputation points
answered 2025-05-02T05:44:35.3033333+00:00
Olaf Helper
46,631
Reputation points
1 answer
SQL Server Management Studio 18 - Maintenance Plan
I have setup SQL backups to run daily at midnight for 5 servers, all works fine except 1 server does not run/create backup files. No errors or logs just does not run and not sure why. Any suggestions? Thanks! David
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T12:56:03.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chun, David
0
Reputation points
answered 2025-05-02T05:42:54.2466667+00:00
Olaf Helper
46,631
Reputation points
0 answers
Cannot load query details for Azure SQL Query performance insight
Cannot load query details for Azure SQL Query performance insight. There are a bunch of errors in browser development console, see screenshot attached.
SQL Server Database Engine
151 questions
asked 2025-05-01T02:15:45.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Terletskyy
0
Reputation points
commented 2025-05-02T05:41:28.0833333+00:00
Olaf Helper
46,631
Reputation points
1 answer
Can I do an SQL Server Edition upgrade from Express to Developer on Azure VM?
I'm trying to upgrade an SQL Express database that comes with an application to SQL Developer edition. The machine is an Azure VM, not Azure SQL server instance. The application is Best Practice, a medical practice management software. The base…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
asked 2025-05-01T23:21:26.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 81%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Melchor Buenaflor Admin
0
Reputation points
answered 2025-05-02T05:39:43.66+00:00
Olaf Helper
46,631
Reputation points
0 answers
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
151 questions
asked 2025-05-01T09:43:27.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Maneesh Murali
0
Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
simo-k
7,735
Reputation points
0 answers
SQL Elastic Pool Stuck on Scaling for 22 Hours
For performance testing I've scaled my SQL Elastic Pool from: General Purpose - 18 vCores - 2TB Storage to Business Critical - 128 vCores - 3TB Storage The main database in the pool has between 1TB to 1.5TB of data in, the rest have under 100GB and the…
SQL Server Database Engine
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 37%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
PDF Export with a custom font giving the error "Cannont find or create the font 'xyz,Bold'."
I've ran into an issue I have never seen before, maybe somebody could help before I pull my hair out any more. We've got some reports we did for a customer in SSRS. They work fine and render fine. Recently the customer gave us a custom font their…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
asked 2025-04-30T21:12:59.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 68%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brothers
0
Reputation points
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers
0
Reputation points
1 answer
SSIS Execute SQL Task Error on Variable
I'm selecting a Number(38,0) data type field from an Oracle table and am attempting to pass the value returned from that Oracle select statement into an Int64 type variable in Visual Studio. The query I'm using is select max(<field_name>) from…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-29T23:21:53.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 37%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kristie A
0
Reputation points
answered 2025-04-30T20:20:29.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
58,616
Reputation points
1 answer
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
151 questions
asked 2025-04-29T16:04:17.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tim Coleman
0
Reputation points
commented 2025-04-30T15:17:33.2433333+00:00
Tim Coleman
0
Reputation points
3 answers
One of the answers was accepted by the question author.
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
151 questions
asked 2025-04-27T10:36:04.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
165
Reputation points
accepted 2025-04-30T11:02:15.8366667+00:00
Anandhswarupp
165
Reputation points
0 answers
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
151 questions
asked 2025-04-30T10:31:00.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 26%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yasir Anis Janjua
0
Reputation points
asked 2025-04-30T10:31:00.4933333+00:00
Yasir Anis Janjua
0
Reputation points
1 answer
Failure sending mail: One or more errors occurred. Mail will not be resent. (SQL Server Reporting Services)
Have tried chatGPT ways as well could get a solution on the below result error: "Failure sending mail: One or more errors occurred" Check your SSRS log files (in \Program Files\Microsoft SQL Server\<Instance>\Reporting…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
asked 2025-04-29T11:02:58.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 93%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Puneet Dasari
20
Reputation points
commented 2025-04-30T10:21:26.31+00:00
Puneet Dasari
20
Reputation points
3 answers
One of the answers was accepted by the question author.
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
asked 2024-04-19T19:31:42.4666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Colin Sachs
40
Reputation points
commented 2025-04-30T09:42:49.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
Favaz Farook
0
Reputation points
3 answers
One of the answers was accepted by the question author.
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,041 questions
asked 2024-04-19T19:31:42.4666667+00:00
Colin Sachs
40
Reputation points
commented 2025-04-30T09:42:49.91+00:00
Favaz Farook
0
Reputation points
0 answers
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
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)