Search the knowledge base for KB 2345 for general database maintenance. This will point you to KB 1146 for purge options.
https://iss.custhelp.com/cgi-bin/iss.cfg/php/enduser/std_adp.php?p_sid=aL6MrEvh&p_lva=1039&p_faqid=2345&p_created=1080931007&p_sp=cF9zcmNoPTEmcF9ncmlkc29ydD0mcF9yb3dfY250PTEwMiZwX3NlYXJjaF90ZXh0PWRhdGFiYXNlIGZ1bGwmcF9zZWFyY2hfdHlwZT0zJnBfcHJvZF9sdmwxPTI5JnBfcHJvZF9sdmwyPX5hbnl_JnBfY2F0X2x2bDE9fmFueX4mcF9zb3J0X2J5PWRmbHQmcF9wYWdlPTE*&p_li= DMZSecure On Tue, 11 Jan 2005 17:25:57 +0300, Sergey V Soldatov <[EMAIL PROTECTED]> wrote: > > To purge SP DB I use the following script (everyday sqlserver job): > /* > * DB Purge, svsoldatov 24.06.2004 > */ > > USE RealSecureDB > > declare @today datetime --today date > declare @deltaSD int --how long SensorSata have to be stored > declare @deltaObs int --how long Observances have to be stored > declare @edgeSD datetime --oldest date in SensorData > declare @edgeObs datetime --oldest date in Obserances > select @deltaSD = -120 > select @deltaObs = -150 > > select @today = getdate() > select @edgeSD = DATEADD ( day , @deltaSD, @today) > select @edgeObs = DATEADD ( day , @deltaObs, @today) > --select @today as 'Today', @edgeSD as 'Edge of SensorData', @edgeObs as > 'Edge of Observances' > --select min(AlertDateTime) as 'Min', max(AlertDateTime)as 'Max' from > SensorData > > exec iss_PurgeSD @edgeSD > exec iss_PurgeObs @edgeObs > > If someone find mistakes, PLEASE, let me know how to correct them. I do not > like use DB maintenance, because I found that it doesn't work correctly in > some circumstances (may be now all problems are fixed, but I still trust my > simple script more). > > Thank you all for probable reply. > > --- > Best regards, Sergey V. Soldatov. > Information security department. > > "Steven Nichols" > <[EMAIL PROTECTED]> To: <[email protected]> > Sent by: cc: > [EMAIL PROTECTED] Subject: [ISSForum] Event Collector > > 05.01.2005 21:03 > > > Can anyone tell me how to purge the database? > The RealSecureDB.mdf is 7.6G. I can't find any faq or how to. > Thanks > > ======================== > > Steven Nichols > > Senior Network Administrator > direct line: 503.352.1139 > cell phone: 503.807.9624 > e-mail: [EMAIL PROTECTED] > > ---------------------------------- > > LDC Design Group > 20085 NW Tanasbourne Drive > Hillsboro, Oregon 97124 > t: 503.858.4242 > f: 503.645.5500 > e: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > w: www.ldcdesign.com <http://www.ldcdesign.com/> > > OR: Hillsboro, Tillamook | WA: Vancouver, Bellevue | ID: Coeur d' Alene > | CA: Sacramento | FL: Clermont > > DISCLAIMER: This message is intended for the sole use of the individual > to whom it is addressed, and may contain information that is privileged, > confidential and exempt from disclosure under applicable law. If you are > not the addressee you are hereby notified that you may not use, copy, > disclose, or distribute to anyone the message or any information > contained in the message. If you have received this message in error, > please immediately advise the sender by reply email and delete this > message. > > _______________________________________________ > 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.
