TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
If you are using SQL then open the Enterprise Manager, click on Tools and select SQL Query Analyzer. Next select the ISSED database and in the box type iss_truncateevents. This will clear out the database and you will now be able to shrink it back to its original size. Regards Devonne > -----Original Message----- > From: [EMAIL PROTECTED] > [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 17, 2002 6: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. > > ****************************************************************** This communication is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. Any retransmission, dissemination, use of, or taking any action in reliance upon, this communication by persons other than the intended recipient(s) is prohibited and may be unlawful. If you have received this in error, please notify the sender and delete the material from any computer. WARNING: whilst we take reasonable precautions to ensure that any attachment has been swept for viruses, we cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment. See our website at http://www.bankofbutterfield.com
