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
[EMAIL PROTECTED]

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to 
https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to [EMAIL PROTECTED]

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

Reply via email to