TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
Have a look at DBMS - The DataBase Maintenance Service is a graphical utility that interacts with RealSecure and SiteProtector databases for scheduling flexible data purges, backups and other database maintenance tasks. http://www.iss.net/support/product_utilities/realsecure_tech_center/utilitie s/index.php Grant > -----Original Message----- > From: Don Liew [mailto:[EMAIL PROTECTED]] > Sent: Saturday, 30 March 2002 2:25 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Enterprise Database Housekeeping in MS SQL 2000 > > > > TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of > your message to [EMAIL PROTECTED] Contact > [EMAIL PROTECTED] for help with any problems! > -------------------------------------------------------------- > -------------- > > Hi Vic, > > I don't think ISS has such a feature built-in. I have written > something to do this for my company. However, this is > subjected to terms and conditions by my company. > > Should you require this program, I can try to provide you for > free as long you abide to the terms and conditions. Would > also appreciate if you can send us your company name and address. > > If you are interested please kindly drop me an email. > > regards, > > Don Liew > Consultant > TriSecurity Pte Ltd, Singapore > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of vico gav > Sent: Friday, March 29, 2002 5:32 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Enterprise Database Housekeeping in MS SQL 2000 > > > > TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of > your message to [EMAIL PROTECTED] Contact > [EMAIL PROTECTED] for help with any problems! > -------------------------------------------------------------- > -------------- > > Good day all, > > I am currently running RS6.5's Enterprise Database on MS SQL > Server 2000; and plan to schedule backups/purging of the > ISSED database using the SQL Server Enterprise Manager. > > There are options to backup, restore and shrink the database > in the SQL Server Enterprise manager; however, I could not > find any options to purge the database. Does that mean I have > to write my own T-SQL scripts to purge data? > > Besides using the ISSED utilities provided by ISS, are there > any other standard ways of backups and purges? To be more > precise, is there an option to the a "log-switch (CheckPoint > LogViewer terminology)" type of method where the ISSED data > is backed-up/archived in a different location and the active > ISSED database is cleared/purged completely? > > Previewing Reports (eg. Top 20 Events) is painfully slow on > the RealSecure Console (approx.10 minutes) eventhough the > console is running separately from the Enterprise DB+Asset > DB+EventCollector on a P4-256MB_Ram box with only the > RealSecure Console services installed. That is why I came to > a conclusion that besides being an IDS admin, I have to be a > database admin as well. > > > Cheerios, > > Vic > > > See Dave Matthews Band live or win a signed guitar > http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.co m/lycos_020201 /splash.asp
