TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
There is a utility provided by ISS but which is not currently supported by ISS. It is called DBMS and it works beautifully allowing you to purge data, backup, restore, and schedule certain events to occur at regular intervals. Go to their support site and look at their utilities... http://www.iss.net/support/product_utilities/realsecure_tech_center/utilitie s/index.php Have fun but remember that some of the other solutions may be better for you since this utility is not supported...but I have not had any problems with it...YET :-) Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 5:53 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MS SQL - Problem TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ---------------------------------------------------------------------------- Yo I had the exact same problem yesterday, as I tried to delete 1.6GByte of events out of the ISSED database. Using the 'maintain' GUI from the RS Console, it takes about one hour to do so... ISS: Isn't there a kind of 'purge' function or so to do so?!? I find the RS Console SQL database handling capabilities extremely rudimentary.... not all RS users are SQL gurus you know... Regards Andres "Eng. Ahed M. Okasha" To: <[EMAIL PROTECTED] cc: v.edu.kw> Subject: MS SQL - Problem Sent by: owner-issforum@i ss.net 16.07.2002 07:17 TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ---------------------------------------------------------------------------- Hi again, My other problem is regarding the Database, I'm using MS SQL 2000 as my Database for RS 6.5 console, and I have 3 NS active and Sending data to it. My question is how to delete the records in The database after backing it up? (Not using The RS Console Configuration -> Enterprise Database Configuration) I want it using SQL commands or A 3rd party software. Thanks, Eng. Ahed M. Okasha IT Security _________________________________________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
