Hi, Have come across this before. If you check on the details for this error you will find that it is missing a back up device. You have to manually add the backupdevice (whatever it maybe) via the Sql Query tool. Once this is done your error will disappear. If you need the exact syntax to add the backup device contact me or put a support call in to ISS
regards Jeff Ames mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buelna, Derek Sent: 14 February 2005 15:43 To: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] '; '[email protected] ' Subject: RE: [ISSForum] SP DB error. Pls help?? I suggest that you go into sql manager and look at the jobs that may have failed and the log. I've experienced similar issues and it's usually the database. We had to configure the database to autogrow and to process the transaction logs more frequently then the default. You may be able to fix this by increasing the available space of the db and then manually running one or more jobs job that failed. The sql log should give you some insight into the situation at least. -Derek -----Original Message----- From: [EMAIL PROTECTED] To: [email protected] Sent: 2/13/2005 3:08 PM Subject: [ISSForum] SP DB error. Pls help?? Hi everyone. Relatively new to working with Real Secure Site Protector (1 month) and new to this discussion forum/list. I am hoping someone can help me. I have one of my consoles showing the SP DB "error" as its' status. Below, I have included the details from the DB. Anyone have experience with this or know where I can find the answer as to how to fix this?? Any guidance or help would be greatly appreciated!!! Also, we have a lot of extra events coming in, so I am wondering if this could be the catalyst for the error status?? The other 4 consoles I monitor are NOT set to auto purge or auto maintenance. Thank you for your valuable time, Traci License State Key Good Sensor Status Error - Loading:Error: The event collector is not properly registered to request a working set Data File Status 26% Full Transaction Log Status 1% Full SQL Server Agent Status Running. Data Load Status 0 rows were loaded on Feb 13 2005 10:39PM. 39 SensorData rows were rejected. 18 SensorDataAVP rows were rejected. Analysis Purge Status Purge Status: Complete; LastUpdated: Feb 8 2005 12:01AM (GMT) Status Description: Complete. No errors. SensorData Purge Status Purge Status: Complete; LastUpdated: Feb 8 2005 12:01AM (GMT) Status Description: Complete. No errors. Data Used (MB) 767 MB Metrics Last Loaded Feb 13 2005 7:00AM Auto Maintenance Job Job Enabled; Last Run Succeeded; Last Run Time: Feb 13 2005 10:32PM Auto Purge Setting ON Auto Maint Setting ON Defragment Index Setting ON Health Status Last Checked At 2005-02-13 22:47:12 (GMT) Version 2.0 (SP 1.3:XPU 1.50) Available XPU Yes Last Installed XPU SP 1.3 Site Name w/held for security reasons Install Date Jun 28 2004 11:27AM XPU Date None Option Flag Default Logging Level Informational Last Modified By Sensor Controller(w/held for security reasons) at 2005-02-13 16:47:34.567(GMT) _______________________________________________ ISSForum mailing list [email protected] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328. _______________________________________________ ISSForum mailing list [email protected] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 _______________________________________________ ISSForum mailing list [email protected] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum To contact the ISSForum Moderator, send email to [EMAIL PROTECTED] The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
