OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
From: Paul Van Gurp (Paul.VanGurp_at_pwgsc.gc.ca)
Date: Thu Jul 18 2002 - 06:23:03 CDT

  • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

    TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
    majordomoiss.net Contact issforum-owneriss.net 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: andres.friedlich.pwcglobal.com
    [mailto:andres.friedlich.pwcglobal.com]
    Sent: Wednesday, July 17, 2002 5:53 AM
    To: issforumiss.net
    Cc: ahedkuc01.kuniv.edu.kw
    Subject: Re: MS SQL - Problem

    TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
    majordomoiss.net Contact issforum-owneriss.net 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:

                          <ahedkuc01.kuni cc:

                          v.edu.kw> Subject: MS SQL - Problem

                          Sent by:

                          owner-issforumi

                          ss.net

     

     

                          16.07.2002 07:17

     

     

    TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
    majordomoiss.net Contact issforum-owneriss.net 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.