First off, apologies to the 3 readers I have (I don't read my blog post, I just write), since all of them are far better than I am when it comes to clustering. To cut it short: how can you move ANY resource from one node to another? Namely, the disk witness in the quorum … Continue reading Move cluster group from one node to another
Month: February 2012
Create SQL Server aliases using registry editor
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
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
SQL-PLAY 