Sql-server – SQL Server 2012 SQL Log “the log file is not using Unicode format”:

sql serversql-server-2012

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

Best Answer

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.

Related Question