Tag Archives: Upgrade

Upgrading SQL Server using Availability Groups – Checklist

Posted on October 17, 2019 by thomasrushton

This is a checklist put together and followed for an upgrade of a pair of physical SQL Server 2012 servers which hosted a single availability group of several terabytes of data with minimal downtime. The availability group was configured with … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 3 Comments

Adventures with DBCC and Database Upgrades

Posted on November 1, 2011 by thomasrushton

We have (had?) an application that has been retired (Hurrah!).  However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server.  So what I’m … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 3 Comments

Unable to launch Activity Monitor.

Posted on November 30, 2010 by thomasrushton

It all started so innocently. A SQL Server 2005 installation.  An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.”  And a need to find out what’s going on.  Click, click, click – Activity Monitor.  Double-click.  Uh-oh. (Incidentally, why … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 2 Comments

SQL Server Upgrades ahoy!

Posted on June 8, 2010 by thomasrushton

A major problem facing many of us is that of sprawl.  In my case, I have databases served by SQL Server 2000, 2005 & 2008.  As if that’s not bad enough, the service pack levels on these servers varies, as … Continue reading →

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