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

[ISSForum] Database shrink for RSDB



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