This blog post is waiting for me to have some time for the past couple of months by now. It did bite me back then, and so it did yesterday. "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Error source: Microsoft OLE DB Provider for SQL Server" … Continue reading Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Error source: Microsoft OLE DB Provider for SQL Server – revisited
Author: Calin OPREA
My mail to SQL Sentry that will win me (yeah, right) a free seat to SQL Skills training!
The amazing guys @SQL Sentry (www.sqlsentry.net) are giving away a chance to win a free seat to SQL Skills Internals and Performance training (check out the details: http://www.sqlsentry.net/sqlskillsimmersion.asp.Of) course, I decided to give it a try, so I wrote to the guys; you can check it below:"Hello there.Now, last night at around 2:30 AM I … Continue reading My mail to SQL Sentry that will win me (yeah, right) a free seat to SQL Skills training!
Move cluster group from one node to another
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
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
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.
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
Cannot shrink the log – now what
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
Database marked as suspect?
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?
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
SQL-PLAY 