Author: Calin OPREA

Create SQL Server aliases using registry editor

Posted on by Calin OPREA

Another quick one today: how do I create an alias using the registry editor? If you want to want to ask me why would you do such a thing, it means you're reading the wrong blogJ. To cut it short, here are the entries in the registry: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo] – this is for x64 machines who … Continue reading Create SQL Server aliases using registry editor →

Error message: “A database snapshot cannot be created because it failed to start” when running DBCC

Posted on by Calin OPREA

I recently learned to hate even more the virtualization thing – once your host fails, guess what, everything else goes downJ. Anyway, the topic for today is not related to my personal feelings, but to DBCC failing on one of my servers. Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created … Continue reading Error message: “A database snapshot cannot be created because it failed to start” when running DBCC →

Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Posted on by Calin OPREA

Another quick one for today: When you encounter such an error (see the title and the print screen below), you might want to check this first: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/b0665753-6bb6-48bb-a938-febc6e942d58 For the really lazy ones: it's a clear sign of memory pressure. I hope this helps. Best regards,io

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

Posted on by Calin OPREA

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

Posted on by Calin OPREA

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

Posted on by Calin OPREA

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

Posted on by Calin OPREA

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 →