RE: Does anyone use the SQL option for saving log info ?

  • From: "Bogdan Florin" <florinb@xxxxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Mon, 22 Apr 2002 21:07:08 +0300

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')




Other related posts: