TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
Hi Vic, I don't think ISS has such a feature built-in. I have written something to do this for my company. However, this is subjected to terms and conditions by my company. Should you require this program, I can try to provide you for free as long you abide to the terms and conditions. Would also appreciate if you can send us your company name and address. If you are interested please kindly drop me an email. regards, Don Liew Consultant TriSecurity Pte Ltd, Singapore -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of vico gav Sent: Friday, March 29, 2002 5:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Enterprise Database Housekeeping in MS SQL 2000 TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ---------------------------------------------------------------------------- Good day all, I am currently running RS6.5's Enterprise Database on MS SQL Server 2000; and plan to schedule backups/purging of the ISSED database using the SQL Server Enterprise Manager. There are options to backup, restore and shrink the database in the SQL Server Enterprise manager; however, I could not find any options to purge the database. Does that mean I have to write my own T-SQL scripts to purge data? Besides using the ISSED utilities provided by ISS, are there any other standard ways of backups and purges? To be more precise, is there an option to the a "log-switch (CheckPoint LogViewer terminology)" type of method where the ISSED data is backed-up/archived in a different location and the active ISSED database is cleared/purged completely? Previewing Reports (eg. Top 20 Events) is painfully slow on the RealSecure Console (approx.10 minutes) eventhough the console is running separately from the Enterprise DB+Asset DB+EventCollector on a P4-256MB_Ram box with only the RealSecure Console services installed. That is why I came to a conclusion that besides being an IDS admin, I have to be a database admin as well. Cheerios, Vic See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201 /splash.asp
