|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: [ISSForum] Purge Database
From: Bruetsch, Markus (ISS California) (MBruetsch
iss.net)
Date: Mon Jul 25 2005 - 12:34:21 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]