Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download

Links

XODOX
Impressum

#1: Re: Using findstr on SQL 2005 ERRORLOG file

Posted on 2008-04-21 22:45:06 by Dan.Cook

On Feb 28, 11:12=A0am, Teresa Masino <teresa.mas...@peninsula.org>
wrote:
> We have set up a couple of SQL Server 2005 systems and I have found
> that the format of the ERRORLOG files and the SQL Agent's log files
> are Unicode or some format that findstr cannot parse properly. =A0"find"
> parses them fine, but it doesn't have the capabilities that I need --
> specifically, I can't search for multiple strings in one search.
>
> I see the checkbox on the SQL Agent's for "Write OEM File", but it is
> grayed out so I am not able to try checking that. =A0I also don't know
> if that would affect the server's ERRORLOG file too or just the
> Agent's log file.
>
> So what am I missing? =A0What is everyone else doing who is used to
> having scripts to parse these files looking for strings that indicate
> problems? =A0Is there a server setting that will force it to go back to
> a plain ANSI text file format for log files? =A0Is that a bad thing to
> do?
>
> Thanks in advance for any insight,
> Teresa Masino

The TYPE command will convert unicode to ASCII. i.e.

TYPE \\coxsql2\E$\MSSQL.1\MSSQL\LOG\ERRORLOG > \\coxsql2\C$\ERRORLOG
\ErrorLog.txt

Report this message