Category Archives: Error Log

General information which involves errorlog, error log info.

Day 15 Server Logs

There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand the system. MySQL track the information in those logs. Following are the list of logs: Error Log (– start/stop/errors) Query … Continue reading

Posted in Error Log, MySQL, Others, Performance Tuning, Transaction Log, Troubleshooting | Tagged , , | Leave a comment

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services. >> After installation when try to access instance. You would get “ACCESS DENIED” error. To resolve this issue, … Continue reading

Posted in Error Log, Installation, Troubleshooting | Tagged , , | Leave a comment

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as “Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error … Continue reading

Posted in Basic, Error Log, Limitation | Tagged , | Leave a comment

Error Log Part 2

I already discussed the steps of server starts which log info at error logs here, In this blog I would like to share the information we can get from error log. Error Log  contains: Version of Sql server Version of  … Continue reading

Posted in Error Log, General | Tagged , | Leave a comment