RE: Does anyone use the SQL option for saving log info ?
- From: "Herzig, Mark" <mherzig@xxxxxxxxxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Mon, 22 Apr 2002 10:36:58 -0400
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')
Other related posts:
