HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

SQL Server 2012 SQL Log "the log file is not using Unicode format":

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
formatthefile2012logsqlunicodeusingservernot

Problem

On only one server of many, the SQL log is blank and shows a message "the log file is not using Unicode Format" when viewed via SSMS. The log is in the right location as specified in the service properties and is readable with notepad. Log looks normal, just won't show up in Log File Viewer in SSMS. Any ideas why?

SQL Server 2012 in active passive Windows failover cluster on Windows 2012. SQL Server ver 11.0.3368

This instance is the SQL Server for MS SCCM. It has trace flags -T8295 and -T4199 as service startup parms. These were added by SCCM when its DB's were installed.

Thanks

Solution

I had an idea which worked. I forced creation of a new log using sp_cycle_errorlog and the new log can be read fine in SSMS. This server recently had a bad crash due to a SAN connection failure. I think that the SQL log file may have bcome corrupted as a result of that.

Context

StackExchange Database Administrators Q#49364, answer score: 3

Revisions (0)

No revisions yet.