isa server -log file maintenance

[treviboy]

I would like to write a script that removes log files that are of a certain date. It looks like the default is to let the files go for 30 days before deleting them.
First: How do i connect to the msde database ? Can I install sql server 2005 on the same machine and look at it this way or am I only going to be able to use command-line arguments to talk to the msde database. I havent done this before -how does this work?

Thanks in advance.

 

[mrdenny]

You can install the SQL 2005 Tools (or the SQL 2000 tools from a SQL 2000 Standard/Enterprise/Developer CD) to connect to the database. You can also use the command line tools that MSDE provides.

What are the columns in the table.

It would probaby be better to use the ISA tools to change the config so that the system deals with the log itself.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[treviboy]

We found a tool from MS website that shows us all the tables in the column. It works great - thanks !