[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [ISSForum] Database full



Hi folks,

Thanks for all your advice. Eventually I got the problem solved. I found
that the table MaintenanceLog contained around 9 million rows. The table
content shown that the iss_PurgeHosts procedure continuously attempted
to purge unused hosts but failed. I seach the knowledgebase and found a
new iss_PurgeHosts. I replaced it and delete the huge log from
MaintenanceLog. Everything was back to normal and the DB size dropped to
around 40%.

Something strange is, the document states that SP4 has fixed the problem
but my problem came out after applying SP4. Anyway, thanks again!

Howard

-----Original Message-----
From: issforum-bounces@xxxxxxx [mailto:issforum-bounces@xxxxxxx] On
Behalf Of Ballerini, Jean Paul (ISS EMEA)
Sent: Tuesday, July 20, 2004 9:27 PM
To: Chan, Howard (Hong Kong S.A.R.); issforum@xxxxxxxxxxxxxxxx
Subject: RE: [ISSForum] Database full


Howard,

On a productive environment it is highly recommended to use the full
MSSQL Server and not MSDE.

Jean Paul

-----Original Message-----
From: issforum-bounces@xxxxxxxxxxxxxxxx On Behalf Of Chan, Howard (Hong
Kong S.A.R.)
Sent: Tuesday, July 20, 2004 3:27 AM
To: issforum@xxxxxxxxxxxxxxxx
Subject: [ISSForum] Database full

Hi,

I am using SitrProtector controlloing 6 network sensors and 12 server
sensors. I have enabled auto maintanence but I found that the MSDE
database (2GB) is full easily. The SiteProtector stop and manually purge
is needed. Do I need to upgrade to MSSQL, or is there any work around?

Thanks,
Howard


PLEASE READ: The information contained in this e-mail is confidential
and intended for the named recipient(s) only. If you are not an intended
recipient of this e-mail you must not copy, distribute or take any
further action in reliance upon it and you should delete it and notify
the sender immediately. E-mail is not a secure method of communication.
Nomura International (Hong Kong) Limited cannot accept responsibility
for the accuracy or completeness of this message or any attachment(s).
This transmission could contain viruses, be corrupted, destroyed,
incomplete, intercepted, lost or arrive late. If verification of this
e-mail is sought then please request a hard copy. Unless otherwise
stated any views or opinions presented are solely those of the author
and do not represent those of Nomura International (Hong Kong) Limited.
This e-mail is intended for information purposes only and is not a
solicitation or offer to buy or sell securities or related financial
instruments.

_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

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@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.

_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

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@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.


PLEASE READ: The information contained in this e-mail is confidential and intended for the named recipient(s) only. If you are not an intended recipient of this e-mail you must not copy, distribute or take any further action in reliance upon it and you should delete it and notify the sender immediately. E-mail is not a secure method of communication. Nomura International (Hong Kong) Limited cannot accept responsibility for the accuracy or completeness of this message or any attachment(s). This transmission could contain viruses, be corrupted, destroyed, incomplete, intercepted, lost or arrive late. If verification of this e-mail is sought then please request a hard copy. Unless otherwise stated any views or opinions presented are solely those of the author and do not represent those of Nomura International (Hong Kong) Limited. This e-mail is intended for information purposes only and is not a solicitation or offer to buy or sell securities or related financial instruments.


_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

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@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.