Wednesday, October 12, 2011

MSSQL error logs in *nix boxes

Today we had to parse one SQL error log file in UNIX box and I saw a kind diff file format -

#grep "Database mirroring is inactive" ERRORLOG.1

And i saw no output. :-(

I thought its dos2unix which can help me. BUT not!!

#file ERRORLOG.4

ERRORLOG.4: Little-endian UTF-16 Unicode English character data, with very long lines, with CRLF line terminators

grep command couldn’t parse the UTF-16 Unicode file. Hence, the file had to be converted to the format which ‘grep’ can parse.

#iconv -f UTF-16 -t UTF-8 ERRORLOG.1 | grep "Database mirroring is inactive"

And cheers! I am done.


No comments:

Post a Comment

8c tips for Freshers / NCG's

I have been having a great company with some of the very talented NCG’s ( New College Hires/ Grads ) last ~2yrs.  I work for Intuit I...