TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to [EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems! ----------------------------------------------------------------------------
Hi Don, I tried the utility and it works great for me. I could backup and purge the logfiles just like what I had intend to do. >From the pics you attached in the mail, you specified the server as 127.0.0.1; in my >configuration I put the netbios name of the server and it did not encounter any >errors. I assume the enterprise database is installed on the same machine (ie.127.0.0.1); therefore the "Dependant on Local MSQL" checkbox should be ticked when you first launch and install the issDbms service. I hope this helps! Cheerios, Vic -- On Tue, 2 Apr 2002 17:20:13 Don Liew wrote: >Hi Grant, > >THanks for your program. However I keep getting this error whenever I click >on the PERFORM NOW button. >Have I done anything wrong? > >Can I also check with you. What are the files to back up, is it just >ISSED_DATA.mdf alone? What about ISSED_LOG.mdf? >I think basically the question is what does your program backup? Also how do >we restore the database for audit purpose? > >regards, >Don. > > > > > > > > > >-----Original Message----- >From: Slender, Grant (ISS Australia) [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 02, 2002 7:36 AM >To: 'Don Liew'; [EMAIL PROTECTED]; [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: RE: Enterprise Database Housekeeping in MS SQL 2000 > > >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 > > > > > See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp
