RE: SQL Logging DB Size
- From: "SNELL,BEN (HP-UnitedKingdom,ex1)" <ben_snell@xxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Fri, 17 May 2002 17:45:04 +0100
You can set up Stored Procs that can then be scheduled which will allow you
to either delete the data (you need to do a DBCC to regain disk space). If
you wish to keep the data then you can dump it to disk or tape before
deleting the data from the DB
Ben
Ben Snell
Technical Consultant
HP Consulting
Tel: +44 (0) 1344 365754
<https://ecardfile.com/id/ben_snell> https://ecardfile.com/id/ben_snell
-----Original Message-----
From: Rogers, Brian [mailto:RogersB@xxxxxxxxxxxxxx]
Sent: Friday, May 17, 2002 5:38 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] SQL Logging DB Size
http://www.ISAserver.org
Just curious as to the maintenance and or size limitations of logging ISA
services to SQL Server.
I just switched over to this and within a minute the database is already at
15 megs. While this isn't large, at this rate it will become insanely large
in a matter of weeks/months.
Is the procedure to just backup the database then clear out the old data
after X amount of days?
Logging to text files creates some rather large files, but at least they got
deleted after a week or so.
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
ben_snell@xxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')
Other related posts:
