Try this script. It gets todays date. and deletes records from 150 to 20
days ago. You can play with the number of days to keep and you might need
to increase from 150 days ago if your database is large.
Don't forget to reorg and shrink the database after. You may also need to
sort out your log file if removing thousands of records in one go.
declare @today datetime
declare @fromdate datetime
declare @todate datetime
select @today= getdate()
select @fromdate= @today - 150
select @todate= @today-20
exec iss_PurgeEvents @fromdate , @todate , 100
Paul Hamilton
"Poppi, Sandro"
<Sandro.Poppi@wac
ker.com> To
Sent by: "ISSforum (E-Mail)"
issforum-bounces@ <issforum@iss.net>
iss.net cc
Subject
24/08/2004 09:11 [ISSForum] Database shrink for RSDB
Hi there,
I'm trying to shrink the RealSecure SiteProtector (SP4.1) db which is about
11 GB (!).
I first used the Database Maintenance feature in SP Console with
autopurge/autoshrink enabled, no luck.
Then I followed KB#1146 to purge the db using the following sql procedure:
USE RealSecureDB
Go
EXEC iss_PurgeObs '1/1/2004'
EXEC iss_PurgeMetrics '1/1/2004'
EXEC iss_PurgeSD '1/1/2004'
followed by KB#2342:
DBCC SHRINKDATABASE (RealSecureDB, 10)
also with no luck.
As I'm not an MS SQL guru I hope to get some hints from you guys.
Thank you in advance,
Sandro
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
________________________________________________________________________
The information contained in this email message may be privileged and
confidential. If the reader is not the intended recipient, or the agent of the
intended recipient, any unauthorised use, disclosure, copying, distribution or
dissemination is strictly prohibited. If you have
received this communication in error, please notify the sender immediately by
telephoning +44 20 7283 4646 and return this message to the above address.
Thank you.
This message has been checked for all known viruses by the MessageLabs Virus
Scanning Service. For further information visit
http://www.messagelabs.com/stats.asp
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security Systems,
6303 Barfield Road, Atlanta, Georgia, USA 30328.
