Dear Sandro:
I was going through this with the support today. Your purge might not be
working if your database is full and has no space in it. In order for
the purge to work, I think you need at least 100 Mb of free space. If
you don't have it, try increasing the database size and then try
purging. It can also be useful if at the beginning you try purging a few
days since your installation (purge just a few days from the database)
and then repeat incrementally. That worked for me
Best regards;
__________________________________________________
Sherine Barakat
Information Security Engineer
sbarakat@iss.net
Internet Security Systems - UAE and Oman
Dubai Internet City - Building 12, Office 203
Phone: +9714 3912836
Fax: +9714 3912905
Mob: +9715 05581779
Roaming Mob: +2 010 3888536
www.iss.net
Internet Security Systems(tm) - Home of the X-Force(tm)
-----Original Message-----
From: issforum-bounces@atla-mm1.iss.net On Behalf Of Massimo
Sent: Saturday, August 28, 2004 11:11 AM
To: Poppi, Sandro
Cc: issforum@atla-mm1.iss.net
Subject: Re: [ISSForum] Database shrink for RSDB
Try to fully reindex the db to eliminate fragmented index from the sql
server console. Do it from the SQL console and not only using ISS stored
procedure, because ISS sp "optimize" only some table.
Give a look also to this KB article:
https://iss.custhelp.com/cgi-bin/iss.cfg/php/enduser/std_adp.php?p_admin
=1&p_userid=184&p_passwd=pELDWQpVuQbUNfAU1&p_faqid=2480&p_created=108732
1141
Best Regards,
Max
Poppi, Sandro wrote:
Hi there,
I'm trying to shrink the RealSecure SiteProtector (SP4.1) db which is
about
11 GB (!).
I first used the Database Maintenance feature in SP Console with
autopurge/autoshrink enabled, no luck.
Then I followed KB#1146 to purge the db using the following sql
procedure:
USE RealSecureDB
Go
EXEC iss_PurgeObs '1/1/2004'
EXEC iss_PurgeMetrics '1/1/2004'
EXEC iss_PurgeSD '1/1/2004'
followed by KB#2342:
DBCC SHRINKDATABASE (RealSecureDB, 10)
also with no luck.
As I'm not an MS SQL guru I hope to get some hints from you guys.
Thank you in advance,
Sandro
_______________________________________________
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.
---
[Quipo ISP - Questa E-mail e' stata controllata dal programma Declude
Virus]
[Quipo ISP - This E-mail was scanned for viruses by Declude Virus]
_______________________________________________
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.
_______________________________________________
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.
