TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Rodney, to my knowledge RealSecure has never imposed any database size
limits per se, however the databases we've relied on have. The free version
of SQL Server that ships with RealSecure 6.0 is called MSDE 2000, which has
an inherent 2GB size limit per database. There are several ways around this.
1. The most preferred method is to upgrade to a fully licensed SQL Server.
This will buy you unlimited database growth as well as many useful graphical
tools for maintaining the database such as Enterprise Manager and Query
Analyzer.
2. You may backup your data periodically using osql (see the "backup"
command in Microsoft's Transact-SQL portion of 'SQL Server Books Online) and
purge it using either the Console's facility (View --> Options -->
Enterprise Database --> Maintain) or by running the iss_truncateevents
stored procedure.
Make sure to stop ALL Event Collectors before attempting to run this stored
procedure, or you risk corrupting the database. To run it, type at a command
prompt:
osql -E -d ISSED -Q "iss_truncateevents"
3. Continuously recreate the ISSED data schema in multiple databases (each <
2GB in size). This could get quite complicated as you may have to alter ODBC
connections to point to the new databases as they are created.
Keep in mind, this information is provided without expressed warranty and
may not be supported by ISS. Use at your own risk.
--Jordan
=============================
Jordan Blake - [EMAIL PROTECTED]
Technical Product Manager
Internet Security Systems - The Power to Protect
=============================
-----Original Message-----
From: Rodney Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 11:01 AM
To: [EMAIL PROTECTED]
Subject: RealSecure6.0 DB Size Limit
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
problems!
----------------------------------------------------------------------------
I thought ISS had fixed the 2GB database size limit! Now that the database
is full and not collecting records anymore how do you purge the database a
start over?
Rodney Smith
