Hi, I am using MS SQL as database for my ISS RealSecure network sensors and server sensors event log. In order to control the database size, I need to truncate the ISS tables (events, eventresponse etc) every month to clear the logged data. However, I also need to keep the last week data in the table for reporting purpose. Is there any good way to keep the last week data after truncating the tables? How can I temporary select & store the last week data into some temporary tables and insert the last week data back to the ISS tables after truncation?
Following are the tables that I run monthly for clearing the logged data. ---- SQL script start -------------------------------- truncate table events truncate table eventresponse truncate table eventparams truncate table eventupdates truncate table eventrawdata truncate table eventsrejected truncate table eventresponserejected truncate table eventparamsrejected truncate table eventupdatesrejected ---- SQL script end -------------------------------- Thanks for helping in advance. Michael Liu _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
