1. You can use purge DB manually by means of iss_PurgeSD and iss_PurgeObs stored procedures ixecuting them from Query Analyzer. Information about how to use them is available in ISS knowledge base article ## 1146
2. You also should configure automatic db maintenance from SP Console: right click on SiteProtector Database component -> SiteProtector Database -> Database Maintenance. Use online help for references. 3. Before DB maintenance became to be working well I used self-written script that also works on SP 2.0 sp5+. I don't use it any more. Here it is: /* * DB Purge, svsoldatov 24.08.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 select min(AlertDateTime) as 'Min', max(AlertDateTime)as 'Max' from SensorData Good luck! > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Cesar Farro Flores > Sent: Tuesday, April 05, 2005 11:57 PM > To: [email protected] > Subject: [ISSForum] tempdev and templog full > > Hi guys : > > My scenario : > - Two IPS G200 > - HPML 350 Application Server > - HPML 350 Event Collector and Data Base (Hard Disk is 76 GB - > > C : 40 GB and D :30 GB ) > * La Base de datos esta el unidad C. > - HPML 110 Securitu Fusion > - Workstation - SPConsole > > Problem : > Today I could�nt enter to my Application Server because in my Event > Collector DataBase i t was disk full , basically the following files > were : > C:\Program Files\Microsoft SQL Server\MSSQL\Data : > - templog.ldf -> 34GB > - tempdb.mdf -> 6GB > Then we removed the data and modified the initial values by "SQL > Server > Enterprise Manager " : LOCAL \ Databases\tempdb -> Properties : > - Data Files -> File Name : tempdev - > Maximum file size : > Restrict > file growth (MB) : 8000 - File Growth by Percent 10 > - Data Files -> File Name : templog - > Maximum file size : > Restrict file growth (MB) : 8000 - File Growth by Percent 10 > > Then we could enter to my application server , but it is a temporal > solution because rigth now we have only one IPS working the next week we > will have working two IPS inline with high traffic, So the file > growth > will execeed my hard disk , are there documentation to prevent it ? > > I will appreciate your help, > > Cesar F. > > > > > > _______________________________________________ > 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.
