Post reply

Unicode file expected. (error: 22004) when looking at SQL Server Agent log files

  • January 25, 2010 at 9:17 am

    #215908

    I am running SQL 2008 on a server. When I try to look at the SQL Agent log files I receive the following error. Unicode file expected. (error: 22004)

    The instance is running on clustered servers but I don't get this error on other server configured the same way.

    Thanks for the assistance.

  • January 26, 2010 at 1:44 am

    #1108499

    it may be the log is too big. Try using wordpad to view it

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 26, 2010 at 7:48 am

    #1108687

    The file is only 3 MB. I opened it in Notepad and it looks just fine. It looks very similar to a log file that does open on another server. Thanks

  • March 29, 2010 at 3:36 pm

    #1141769

    This may not fix your problem, but:

    In the dialog used to configure the error log files, there is an option to choose:

    'Write OEM error log'. Help on this dialog explains that selecting this option:

    Writes the error log file as a non-Unicode file. This reduces the amount of disk space consumed by the log file. However, messages that include Unicode data may be more difficult to read when this option is enabled.

    '...more difficult... ' as in 'NOT', perhaps!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply