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

Re: [ISSForum] Database shrink for RSDB



I think that it's better to use iss_PurgeObs and iss_PurgeSD procedures.
More information is available in ISS Knowledge base, Answer ID 2345
---
Best regards, Sergey V. Soldatov.
tel/fax +7 095 745 89 50 (2663)


                                                                                                                      
              Paul.Hamilton@thomasmiller.                                                                             
              com                                To:       "ISSforum (E-Mail)" <issforum@xxxxxxx>                     
              Sent by:                           cc:                                                                  
              issforum-bounces@xxxxxxx           Subject:  Re: [ISSForum] Database shrink for RSDB                    
                                                                                                                      
                                                                                                                      
              24.08.2004 16:35                                                                                        
                                                                                                                      
                                                                                                                      





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.





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