Tag Archives: SSMS

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

Error: There is not enough space on the disk

Posted on December 2, 2018 by thomasrushton

I was running a query in SQL Server Management Studio (SSMS), nothing too complicated, and got this error, unexpectedly: An error occurred while executing batch. Error message is: There is not enough space on the disk. There’s plenty of space … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

SQL Server Error 18456 Severity: 14 State: 73

Posted on May 14, 2018 by thomasrushton

A question asked on one of the forums today wasn’t easily answerable by Googling. Summary of the question “I have error 18456 State 73 – why?” Google seemed remarkably quiet on the subject of that particular state code. Even Aaron … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 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

Red Gate – SQL Tab Magic – Preview

Posted on August 12, 2011 by thomasrushton

Those clever chaps at Red Gate have had a “down tools” week – not quite sure what that means, as it sounds like hard work – and this time they’ve come up with “SQL Tab Magic“. This simple-looking little tool … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 1 Comment

Lazy programming from MS? Surely not…

Posted on December 21, 2010 by thomasrushton

Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere… (Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug.  I suspect it was RTM, … Continue reading →

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