SQL database are very huge if your network traffic are big. Of course you can setup a lot of things like JOBS who can delete information, shrink database and etc. And keep the most precious information into some tabels ! It is an entire philosophy. Yours sincerely, Bogdan Florin manager BizarNet - Satellite Internet Services www.bizarnet.ro phone: +40-64-426507 gsm: : +40-90-074031 -----Original Message----- From: "Herzig, Mark" <mherzig@xxxxxxxxxxxxxx> To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx> Date: Mon, 22 Apr 2002 10:36:58 -0400 Subject: [isalist] RE: Does anyone use the SQL option for saving log info ? > http://www.ISAserver.org > > > b) I am not sure if you can compress the database. You can probably > use the > Windows 2000 disk manager to compress your partition where your > database > sits on. > c) With SQL Server 2000 If you right click on a table in the Enterprise > Manager and select Open Table->Query, you get a graphical query builder > that > will build and execute SQL commands for you. This will not help you if > you > are looking for formatted reports. I would build a quick ASP page if I > needed a more professional looking report. > > Mark Herzig > InfoLibria Inc. > www.infolibria.com > > > > -----Original Message----- > > From: FRAEYE MIKE [SMTP:Mike.Fraeye@xxxxxx] > > Sent: Monday, April 22, 2002 10:22 AM > > To: [ISAserver.org Discussion List] > > Subject: [isalist] Does anyone use the SQL option for saving log info > > ? > > > > http://www.ISAserver.org > > > > > > Goodafternoon you all, > > > > If anyone can help me with this please, I'd be very greatfull. > > > > I'm using an SQL server to save log information. This data file is > growing > > quite fast, now about 150 MB after 4 days. > > Question : > > > > a) Is this behaviour normal ? > > b) Can I do something to compress this database ? > > c) Does anyone has usefull Access or other reporting tools to query > the > > SQL server ? > > > > Mant thanks in advance, > > Mikey > > > > > > Mike > Fraeye____________________________________________________________ > > Microsoft Backoffice Support Center > > > > Siemens Business Services > > Guido Gezellestraat 121 > > B- 1654 Huizingen > > > > Fax : +32(0)2 536 34 58 > > > * E-mail : mike.fraeye@xxxxxx > > > _______________________________________________________________________ > __ > > > > > > > > ------------------------------------------------------ > > You are currently subscribed to this ISAserver.org Discussion List > as: > > mherzig@xxxxxxxxxxxxxx > > To unsubscribe send a blank email to > $subst('Email.Unsub') > > ------------------------------------------------------ > You are currently subscribed to this ISAserver.org Discussion List as: > florinb@xxxxxxxxxxx > To unsubscribe send a blank email to > $subst('Email.Unsub')