[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ISSForum] Database shrink for RSDB
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:
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,
ISSForum mailing list
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.