BACKUP DATABASE TO DISK = N‘NUL’ – and misconceptions

Hopefully this will help someone out there. There is a command, BACKUP DATBASE <db_name> TO DISK = N'NUL' and apparently people either don't know that is there, or are using it for all the wrong purposes. We use this particular command to find out our "golden point", so to speak, which means that we can … Continue reading BACKUP DATABASE TO DISK = N‘NUL’ – and misconceptions

Execution of job LSRestore_ failed. See history for details

I've been itching all day to write about this, but I got caught in way too many other small issues, but now, that I'm home, I hope I get the chance to write about this little mishap that I got today. I was documenting an emergency role change for a secondary involved in log shipping … Continue reading Execution of job LSRestore_ failed. See history for details

Book review: SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues

Alright, I bought the book and started reading it. Now, this is just my very first impression with the book, so don't take it too seriously. First of all, on a 1 to 5 scale, I would give it somewhere between 3.5 and 4. In other words, above average. OK, hold on, justice is NOT … Continue reading Book review: SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues

Failed to load msxmlsql.dll is SQL Server 2005

Now, there are a plethora of posts about it, and two of them really stand out: http://support.microsoft.com/default.aspx?scid=kb;EN-US;941105 - an issue with Windows Server 2003 http://support.microsoft.com/kb/929668 - if SQL Server 2005 is a (direct) upgrade from SQL Server 2000 Also, you will find many blog posts suggesting to attempt a repair of the MSXM 6 (currently, … Continue reading Failed to load msxmlsql.dll is SQL Server 2005

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