Backup, file manipulation operations and encryption changes on a database must be serialized

I love scratching my head; that's why I became a DBA in the first place, I get the chance to scratch my head and swear a lot, without anyone complaining about it. The most recent head-scratching situation was when we checked our backup history table (we use a custom script, and no, we're not allowed … Continue reading Backup, file manipulation operations and encryption changes on a database must be serialized

“A MOF syntax error occurred” when installing SQL Server

OK, in my case it was a clustered environment, but I bet this applies to single instances as well. I ran the setup (it's not quite my first SQL Server install, you know) and after configuring all the steps, I hit Install and waited. The good news is that I didn't have to wait too … Continue reading “A MOF syntax error occurred” when installing SQL Server

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