Hi, We have SP 1.2 SP 2.0 in production. Overall it works.
I cant comment on migrating a database, I have never had to do this. However, on grooming, ISS have an unsupported SQL tool that performs automated grooming. Have a look on their utilities page. I use this to purge low priority events once week (again this is an organisational choice, not for all). It works. The only red flag I would waive....use it locally on the SQL Database, not over the network as the SQL procedures that it executes take a long time to finish, dependant on the volume of data being purged. I do not like to think what would happen if there was a network outage. Stephen >>> "Avi Ganon" <[EMAIL PROTECTED]> Thursday 16, January, 2003 16:41:18 >>> Hi all, I am working with SP 1.2 for a while and I hop that SP2.0 will solve migration database issue. One of main issue is enterprise database migrate to another database. You can't copy / migrate real secure database without reinstalling SP and it is a problem. I am working with my preproduction system, testing all around Sp1.2. After deciding upgrading to production for larger database I have found that I can't change the eventcollector password. In version 6.5 you can change the location of your database only by adding new ODBC connection And reenter the eventcollector user name or password. This feature does not exist in SP 1.2, "since the passwords for these users are created dynamically you cannot recreate the users on the new database since no one knows what the passwords are." "So that is why you will need to reinstall Site Protector if you wish to migrate it to another database." This is Technical ISS Support quoting. Another thing you can't install enterprise database without ids server on the same machine. "When you install the Enterprise database it will always install the IDS server. There is no way around this issue" So before installing or upgrading to SP 1.2 "RTFM" Thanks Best Regards Avi Ganon Information Security Tel: 972-9-9614540 Cell: 972-58-741717 -----Original Message----- From: Lanzilotta, Chris S. (MBS) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 00:02 To: 'Wong, Kin (ISS Philadelphia)'; '[EMAIL PROTECTED]' Cc: Sprague, Michael (ISS Pennsylvania) Subject: [ISSForum] SiteProtector Database Grooming Has anyone else been struggling with Database Grooming issues and the lack of any ones useful in the product? Has anyone developed any SQL jobs worth sharing? Has anyone heard if this will be enhanced in SP 2.0? ************************************************************************ ************************** The contents of this email and any attachments are confidential. It is intended for the named recipient(s) only. If you have received this email in error please notify the system manager or the sender immediately and do not disclose the contents to any one or make copies. ** eSafe scanned this email for viruses, vandals and malicious content ** ************************************************************************ ************************** --------------------------------------------------------------------------------------------------------------- This e-mail message may contain confidential, commercial and privileged information or data that constitute proprietary information of Cellcom Israel Ltd. Any review or distribution by others is strictly prohibited. If you are not the intended recipient you are hereby notified that any use of this information or data by any other person is absolutely prohibited. If you are not the intended recipient, please delete all copies and contact us by e-mailing to: [EMAIL PROTECTED] Thank You. DISCLAIMER: Any e-mail messages from the Bank for International Settlements are sent in good faith, but shall not be binding nor construed as constituting any obligation on the part of the Bank. CONFIDENTIALITY NOTICE: This e-mail contains confidential information, which is intended only for the use of the recipient(s) named above. If you have received this communication in error, please notify the sender immediately via e-mail and return the entire message. Thank you for your assistance. _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
