Tag Archives: SQL Server Log

Unable to access SQL Error Log using SSMS

Recently my laptop was upgraded to Windows 10. Today while I was trying to access the SQL Server error log on my express instance (by executing xp_readerrorlog), I received the below error. Msg 22004, Level 16, State 1, Line 0Failed … Continue reading

Posted in How To, Just Learned, SQL Server, SQL Server Log, SQL2012 | Tagged , , , | Leave a comment

Shrinking Transaction log

Some days back, I had a discussion with one of my colleague about Shrinking a database log file. He told me that they had a database with a log size 10 times larger than the data file size, and they … Continue reading

Posted in Backup - Restore, SQL Server, T-Log | Tagged , | 3 Comments

Increase SQL Server Error Logs

By default, 6 old SQL Server error log files are available on our SQL server instance and the older ones are recycled. However, sometimes, we may require the error log files older than the default. Its possible to increase the … Continue reading

Posted in How To, SQL Server | Tagged , , | 2 Comments