Viewing 4 posts - 1 through 5 (of 5 total)
Over 60 SQL server error logs are read by a VB script every 30 minutes which notifies SQL DBAs of any errors found.
Dan
April 23, 2008 at 11:53 am
The TYPE command will convert unicode to ASCII. i.e (from a batch job).
TYPE \\SQLSRVR1\E$\MSSQL.1\MSSQL\LOG\ERRORLOG > \\SQLSRVR1\C$\ERRORLOG\ErrorLog.txt
Dan
April 23, 2008 at 10:30 am
Thank you! looks like a great script. the 150gb database I am working with has 43 files. Hope it works.
Dan
December 24, 2007 at 8:42 am
Viewing 4 posts - 1 through 5 (of 5 total)