First of all: Thanks to everyone who sent hints! I had partially success. My db is down to 7 GB but only after setting the date to Aug 15:
USE RealSecureDB Go EXEC iss_PurgeObs '8/15/2004' EXEC iss_PurgeMetrics '8/15/2004' EXEC iss_PurgeSD '8/15/2004' and an additional DBCC SHRINKDATABASE (RealSecureDB, 10) I also followed KB#2600. I wonder how I could reduce it more since I have only about 12000 events shown. Is there a chance to e.g. remove data for Internet Scanner or RealSecure Sensor because we only use RSDP without having side effects? Thanks again, Sandro > > > I think that it's better to use iss_PurgeObs and iss_PurgeSD > procedures. > More information is available in ISS Knowledge base, Answer ID 2345 > --- > Best regards, Sergey V. Soldatov. > tel/fax +7 095 745 89 50 (2663) > > > > > [EMAIL PROTECTED] > > com To: > "ISSforum (E-Mail)" <[EMAIL PROTECTED]> > Sent by: cc: > > [EMAIL PROTECTED] Subject: > Re: [ISSForum] Database shrink for RSDB > > > > > 24.08.2004 16:35 > > > > > > > > > > > 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" > <[EMAIL PROTECTED] > ker.com> > To > Sent by: "ISSforum (E-Mail)" > issforum-bounces@ <[EMAIL PROTECTED]> > 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 > [EMAIL PROTECTED] > > TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to > https://atla-mm1.iss.net/mailman/listinfo/issforum > > To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] > > 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 > [EMAIL PROTECTED] > > TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to > https://atla-mm1.iss.net/mailman/listinfo/issforum > > To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] > > The ISSForum mailing list is hosted and managed by Internet Security > Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328. > > > > > > _______________________________________________ > ISSForum mailing list > [EMAIL PROTECTED] > > TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328. _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
