Hi Pankaj,
It is a very complicated and consuming maintenaince task. We have two distributed installations of SiteProtector, but just one of them is active (It is like a Active-Passive firewall configuration).
I switch the platform every week. I unregister the sensors from the active one and register to the passive platform. That way I always have data in two different platforms, but one of them is related to the last week. Before making the new platform switching, I have made a backup (with MS-SQL Enterprise Manager in the Database Maintenance plan), I move that backup file to a huge repository and then I uninstall ISS Software (deleting the old backuped Database). After that I reinstall ISS Software, apply the licenses, unregister sensors from the active Siteprotector and registering to the reinstalled platform.
So I don't rely on maintenance tools of ISS, but my manager manual capabilities.
Regards
Sharma, Pankaj wrote:
How you maintain this large db as the SP db maintenance utility is not that reliable?
regards
-----Original Message----- From: Lorenzo Mart�nez Rodr�guez [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 3:37 AM To: [EMAIL PROTECTED] Subject: [ISSForum] Re: Database Full
Hi Howard,
In my own experience with SiteProtector with 4 Network Sensors and 2
Gigabit Sensors listening to the traffic of an ISP, I propose that you use MS SQL Server. I collect 50 GB aproximately every week in the database.
Best regards
--
Lorenzo Mart�nez Rodr�guez Consultor de seguridad inform�tica
ISC Consultores Santa Hortensia 2 28002 Madrid
Tel +34 91 510 43 00 Fax +34 91 519 81 08
e-mail [EMAIL PROTECTED] WWW http://www.isc-consultores.com PGP Fingerprint 4914 7470 3D5B C3AD 0C22 B087 F770 0A0E 59FD BA6E _______________________________________________ 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.
