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

Re: [ISSForum] Database shrink for RSDB



Try this script. It gets todays date.  and deletes records from 150 to 20
days ago. You can play with the number of days to keep and you might need
to increase from 150 days ago if your database is large.

Don't forget to reorg and shrink the database after. You may also need to
sort out your log file if removing thousands of records in one go.

declare @today datetime
declare @fromdate datetime
declare @todate datetime
select @today= getdate()
select @fromdate= @today - 150
select @todate= @today-20
exec iss_PurgeEvents @fromdate , @todate , 100


Paul Hamilton



                                                                           
             "Poppi, Sandro"                                               
             <Sandro.Poppi@wac                                             
             ker.com>                                                   To 
             Sent by:                  "ISSforum (E-Mail)"                 
             issforum-bounces@         <issforum@xxxxxxx>                  
             iss.net                                                    cc 
                                                                           
                                                                   Subject 
             24/08/2004 09:11          [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.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
 ______________________________________________________________________



________________________________________________________________________
The information contained in this email message may be privileged and 
confidential. If the reader is not the intended recipient, or the agent of the intended recipient, any unauthorised use, disclosure, copying, distribution or dissemination is strictly prohibited.  If you have
received this communication in error, please notify the sender immediately by telephoning +44 20 7283 4646 and return this message to the above address.  Thank you.

This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information visit http://www.messagelabs.com/stats.asp

This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________
_______________________________________________
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.