Tag Archives: Troubleshooting

CmdExec vs Powershell – error? What error?

Posted on October 20, 2020 by thomasrushton

Just a quickie Batch file scripts, called by SQL Agent, are not propagating their errors back up to the SQL Server job system because…. they’re being called from a Powershell script? To replicate the problem, create a .bat file containing … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

Availability Groups, Busy Databases, and Badly-Timed Reboots

Posted on August 27, 2019 by thomasrushton

A server’s availability group was mostly healthy, but for a couple of databases. There was nothing apparently wrong, but they weren’t synchronised, and we were beginning to see transactions failing to complete as they couldn’t be written on the secondary. … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

What A Difference An Index Makes

Posted on June 18, 2017 by thomasrushton

M’colleagues over the way were having problems with an upgrade / feature installation of McAfee EPO UDLP (no, I have no idea what that means). Looking at what was happening on the SQL Server that’s at the back of that … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

SQL Server 2012 Silent Install problems

Posted on February 20, 2015 by thomasrushton

Just been working on a silent install script for SQL 2012, and had a few odd errors. Unfortunately, I don’t have direct access to the server, just to my notes from the install. Error: “‘<null or empty string>’ is not … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

SQL Server 2012 installation – Error while enabling Windows Feature NetFx3

Posted on December 3, 2014 by thomasrushton

Just a quickie, as I didn’t have the time to take screenshots. Installing SQL Server 2012 on a new Windows Server 2012 VM. Part-way through the installation, I got the following error message: TITLE: Microsoft SQL Server 2012 Service Pack … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

RESTORE failure – error 3633… ‘DeleteTree’ … ‘fulltext.cpp’

Posted on April 5, 2013 by thomasrushton

Here’s a little bit of the pain that I’m facing today. I was trying a SQL Server RESTORE (using Quest’s Litespeed for SQL Server) of one of our databases, one that has a fulltext index. The restore was consistently failing … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , | Leave a comment