A word of advice: the script assumes that you have the exact number of CPUs per NUMA node, WHICH MIGHT NOT BE THE CASE IN YOUR SCENARIO:
I received recently an email from a friend asking for my help as he faced a problem. He runs a small business in the healthcare industry and his needs in terms of IT should and are minimalist, if you want. And that's expected. Of course, I asked what was the problem about and he said: … Continue reading Corruption she (the DBCC) wrote….
This is so going to bite yer ass if you don't pay attention… As usual, a very quick post: I tried to create (ok, restore) a certificate from the production server to our DR server, so that the automated restores would work. When I ran the script (yes, CREATE CERTIFICATE … FROM FILE […]), I … Continue reading Create certificate from backup fails on SQL Server 2008
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
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
Happy New Year anyone (and Gong Xi Fa Cai, since it's rapidly approapching). Now this one really asks for a blog post, since I saw it too many times on various forums and I just got it on one of my production servers. I just got an alert that we're running low on space on … Continue reading Cannot shrink the log – now what
I just ran into a situation like this, with the CPLS where I'm teaching: "Calin, you're the guy I was expecting to call!". Riiight, all of a sudden there's big love among us, right? Nope, it was a database that was marked as suspect. For no particular reason. Okay, do you have backups? From yesterday. … Continue reading Database marked as suspect?