master database restore failed in SQL Server 2008 R2 SP1 CU1

We just woke up having 30+ instances of SQL Server 2008 R2 Enterprise edition in development and testing. Which is bad for obvious reasons. So basically I have to uninstall the Enterprise and re-install Developer Edition on all the machines. Steps to take: Create a maintenance plan to back up all the databases (simplest way; … Continue reading master database restore failed in SQL Server 2008 R2 SP1 CU1

How can I tell if my restore process is actually doing something

Just stumbled into this: if you have a large DB to be restored, it might take forever to actually see the progress moving to 10%, 20%, and so on. Yeah, I know, you should never do a restore from the SSMS, but don't try to tell me thatJ. Anyway, coming back to our scenario: if … Continue reading How can I tell if my restore process is actually doing something

SQL Server 2008 cluster installation – IP address already in use

A quick one today, but I intend to make a series out of it, especially that we're having loads of "fun" with clustering: we encountered something in the line: IP Address 192.168.1.100 is already in use. To continue, specify a different IP address". Okay, I think this one filled the glass of my colleague, but … Continue reading SQL Server 2008 cluster installation – IP address already in use

Side-by-side installation of SQL 2008 R2 and SQL Server 2005

My wife asked me to install a named instance of SQL Server 2005 Enterprise Edition x64 on top our existing SQL Server 2008 R2 Enterprise x64. HA! As a SQL Server MCT (besides the fact that I did quite a few installs in my time) I should have known better how to do it. So … Continue reading Side-by-side installation of SQL 2008 R2 and SQL Server 2005

Is the primary key always clustered in SQL Server?

As I was playing in SSMS (SQL Server Management Studio), I created a table using the plain-old T-SQL, and then I decided to create a primary key, the "wizard" way, so to speak. Let's have a repro here: CREATE TABLE [dbo].[Employees] ( [empID] [int] NOT NULL , [firstname] [varchar](30) NOT NULL , [lastname] [varchar](30) NOT … Continue reading Is the primary key always clustered in SQL Server?