Purge Database:
1. First, shut down all the SiteProtector services.
2. Find the date of the of the records using the command C:\osql -E -d
RealSecureDB -Q "SELECT MIN(ObservanceTime) FROM Observances (NOLOCK)"
3. Try purging the data per day using the command C:\osql -E -d RealSecureDB -Q
"exec iss_PurgeSD '2003-10-14'" C:\osql -E -d RealSecureDB -Q "exec
iss_PurgeObs '2003-10-14'"
4. To find out how much space you have use the command C:\>osql -E -d
RealSecureDB -Q "exec sp_spaceused"
Hope this helps.
Thanks
Siva
-----Original Message-----
From: issforum-bounces@iss.net [mailto:issforum-bounces@iss.net]On
Behalf Of issforum-request@iss.net
Sent: Monday, July 25, 2005 9:30 PM
To: issforum@iss.net
Subject: ISSForum Digest, Vol 18, Issue 17
Send ISSForum mailing list submissions to
issforum@iss.net
To subscribe or unsubscribe via the World Wide Web, visit
https://atla-mm1.iss.net/mailman/listinfo/issforum
or, via email, send a message with subject or body 'help' to
issforum-request@iss.net
You can reach the person managing the list at
issforum-owner@iss.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of ISSForum digest..."
Today's Topics:
1. Probability of Bybassing Proventia G400/2000 (Mohannad S. No'man)
2. Purge Database (Brandon Liew)
----------------------------------------------------------------------
Message: 1
Date: Sun, 24 Jul 2005 19:46:10 +0300
From: "Mohannad S. No'man" <mnoman@elite.com.sa>
Subject: [ISSForum] Probability of Bybassing Proventia G400/2000
To: <issforum@iss.net>
Message-ID:
<!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAkAsGkFIpEkKoEW09ajU2TMKAAAAQAAAAjOHe4F2nAUOzc5G2GS1iyAEAAAAA@elite.com.sa>
Content-Type: text/plain; charset="us-ascii"
What is the probability for Proventia G400/2000 to be bypassed if one port
was connected to a segment located after the firewall, and another port was
connected to a segment located before the same firewall?
If the probability for that is 0%, do you have any official document that
can prove that?
Regards,
Mohannad
------------------------------
Message: 2
Date: Mon, 25 Jul 2005 09:17:01 +0800
From: Brandon Liew <brandon.liew@gmail.com>
Subject: [ISSForum] Purge Database
To: ISSForum@iss.net
Message-ID: <297fc16805072418175f8734e0@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
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.
End of ISSForum Digest, Vol 18, Issue 17
****************************************
_______________________________________________
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.
