Brandon,
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 need to turn on Database Management and enable emergency purge in the
SiteProtector Database, Database Maintenance.
3: If you are running MSDE, use the following command from an MS DOS prompt on
the database machine:
osql -E -d realsecuredb -i <path to file>\iss_truncatetables.sql
4. Refer to the ISS KB: 2048, 2345
Regards,
Markus
-
Markus Brütsch, CISSP, CISM
TZ: US Pacific
mailto:mbruetsch%40iss%2enet
Office: 805 241 6282
...when you have eliminated the impossible, whatever remains, however
improbable, must be the truth.
Sherlock Holmes
-----Original Message-----
From: issforum-bounces@atla-mm1.iss.net On Behalf Of Brandon Liew
Sent: Sunday, July 24, 2005 18:17
To: issforum@atla-mm1.iss.net
Subject: [ISSForum] Purge Database
Hi,
Can anyone tell me how to purge the database?
The RealSecureDB.mdf is 2.G. I can't find any faq or how to.
My DB is running on MSDE 2000 SP3 which support 2 gigabytes.
Thanks
--
Regards
Brandon Liew
CONFIDENTIAL POLICY:
"THIS E-MAIL AND ANY FILES TRANSMITTED WITH IT CONTAINS INFORMATION WHICH MAY
BE CONFIDENTIAL IT IS INTENDED SOLELY FOR THE USE OF THE INDIVIDUAL OR THE
ENTITY TO WHOM THEY ARE ADDRESSED. IF YOU ARE NOT THE INTENDED RECIPIENT,
PLEASE BE ADVISED THAT YOU HAVE RECEIVED THIS E-MAIL IN ERROR AND THAT ANY USE,
DISSEMINATION, FORWARDING OR PRINTING OF THIS E-MAIL IS STRICTLY PROHIBITED. IF
YOU HAVE RECEIVED THIS E-MAIL IN ERROR, PLEASE NOTIFY US BY RETURN E-MAIL AT
THE ADDRESS ABOVE AND DELETE THE E-MAIL FROM YOUR FILES. THANK YOU FOR YOUR
CO-OPERATION."
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security Systems,
6303 Barfield Road, Atlanta, Georgia, USA 30328.
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security Systems,
6303 Barfield Road, Atlanta, Georgia, USA 30328.
