SQL Error Messages Archives - Page 75 of 114 - SQL Authority with Pinal Dave

SQL SERVER – Starting Up Database – Why Multiple Times in Errorlog?

February 20, 2016

SQL Error Messages, SQL Log, SQL Scripts, SQL Server

Fixing error messages is something which keeps me energized because there is something challenging that is put in front of me. I know these can be frustrating times working on errors, but they also make you learn more about the product and make you better. My day life includes creating demo’s for sessions and learning new techniques that will enhance my knowledge. One of the days I started my machine and immediately connected to my SSMS environment to just see that it was taking unusually longer than expected time to get the instance up and ready. Let us see blog post about Starting Up Database.

My instinct was to scan through the ERRORLOG, I found the below series of messages.

SQL SERVER – FIX Error 18456, Severity: 14, State: 6. Login failed for user

February 17, 2016

Pinal Dave

SQL Tips and Tricks

SQL Connection, SQL Error Messages, SQL Log, SQL Server

One of the blog which I wrote earlier was also on Login failed for user with state 58. Let us see how to FIX Error 18456.

After reading that blog, one of the blog reader contacted me and told that she is getting state 6. I thought this error are very common and is important to demystify some of the reasons for the same. I have asked completed error message to assist him. Here is the message she shared:

Error: 18456, Severity: 14, State: 6.

SQL SERVER – FIX Error 18456, Severity: 14, State: 58. Login failed for user

February 13, 2016

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Log, , SQL Server

One of the most common and searched SQL Server failure is around “Logins”. Login failed for user has always been tricky and interesting to troubleshoot. I don’t think there is a silver bullet to easily troubleshoot the same. With every version of SQL Server, there are enhancements made in error reporting, which try to make life on DBA’s easy. In previous version of SQL, whenever there is a login failed, it would print message in the SQL ERRORLOG along with the state of login failed. It was difficult for a DBA to find the cause further and it all boiled down to doing a number of permutations and combinations of resolution over the internet. Let us see how to FIX Error 18456.

SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group

February 12, 2016

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Log, SQL Scripts, SQL Server, Transaction Log

One of my blog readers posted on Facebook asked following question about Huge Transaction Log:

Hi Pinal,
We are using AlwaysOn availability group for our production database. The database is fairly large in size as its around 260 GB. The database transaction log file grows around 2.5gb every day. Over the weekend the DBA team noticed that the Log file for this database bloated up to around 230 GB and then seems to hold steady. While troubleshooting I noted an error that the rebuild Index failed due to “Availability_Replica”. Here is the error which we saw in ERRORLOG

SQL SERVER – Install Error – The /UIMode setting cannot be used in conjunction with /Q or /QS

February 5, 2016

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server

Doing repetitive tasks is something everyone hates. I am sure many of us have resorted to ingenious techniques to figure out doing the task efficiently. There is no standard tool or technique that everyone uses. Recently I was asked to install a SQL instance with same configuration on 10 servers. Who would like to log in to all those servers, run setup.exe and go through the same setup wizard? Luckily, the SQL Server setup allows to create a configuration file. The very thought of extracting it as configuration is something that made me jump out of my seat. Let us learn about Install Error – The /UIMode setting cannot be used in conjunction with /Q or /QS.

Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server

January 31, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

Sometimes in the interviews I observe that users are able to answer all the theoretical questions correct but when it is about doing practical they fail. A while ago, when I was helping a large organization with interview, suddenly their DBA reported that one of their server has installation error.…

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

January 30, 2016

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Upgrade, System Database

I do apply patches to my SQL instances as and when they are released by Microsoft. This is important because I always feel keeping the bits up-to-date is essential because I don’t want to get infected as I travel quite a bit. Since I play a lot with my SQL Server, there are more chances that things are going to break sooner than your production server. Here is one such incident. Let us learn about how to fix script level upgrade.