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