Hi,
I run this script
every week:
use
issed
Declare @EndDate datetime
select
@Enddate = eventdate from
events where
datediff(day,eventdate,getdate()) > '30'
exec
iss_purgeevents '01-01-2002', @EndDate, '1000'
It clears out all
events that are between 01-01-2002 and 30 days ago. So you will be keeping
data for 30 days.
If you want to
keep more, just increase the amount of days.
I also backup
the db's on a daily bases, and backup the logs every 6 hours,
which truncates them.
Ruud Peeters
e-Commerce
Engineering Europe
Office Depot International
-----Original Message-----
From:
syesilyurt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January
09, 2003 08:55
To: [EMAIL PROTECTED]
Subject: [ISSForum]
Trouble with ISSED database in MS SQL 2000
Hi,
I have a problem with ISSED database whose size
increases and tables cannot be truncated.
The ISSED database managed by MS
SQL Server 2000, saves the logs created by the software RealSecure version
7.0.2002.
Its size has reached up to 10 GB which is near to the disk
capacity. I want to clean up the rows in the ISSED DB tables but cannot
achieve due to the referenced tables. There are too many tables and I do not
know which table to begin truncate without violating the referencing
constraints.
When I truncate tables with the sql command "truncate table
table_name;", I see an error about violating the referencing
constraints.
What shall I do for cleaning up the ISSED database tables
without dropping the DB or tables after backup? Is there a script to truncate
tables or delete rows? Isn't there any way other than dropping
database?
thanks.
Selman YESILYURT, IT Security Administrator
Tel : 90-312-402 2398 ANKARA/TURKEY
