I changed the the database recovery model to 'Simple' from "Bulk logged" and then restarted SQL Server. The database size is about 12GB and the transaction log is set to 15GB. I am running the script below but it fails with the error that the database log is full. Is it because the script waits till the end to commit the transactions therefore not allowing the server to auto-truncate the log (throw out committed rows)??
-----Original Message----- From: Christo De Beer [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE: [ISSForum] re: Report generation in ISS RealSecure In SQL server enterprise manager you need to set the recovery model of the ISSED database to Simple. To do this right click the ISSED database, select Properties and then Options. You can then also run Checkpoint from Osql or shut down and restart SQL which should then truncate the transaction log. After this checkpoint should automatically truncate the transaction log. Kind regards Christo de Beer Information Specialist Sr EDS South Africa Phone: +27 11 239 2616 Fax: +27 11 239 2555 Mobile: +27 82 453 8183 E-Mail: [EMAIL PROTECTED] -----Original Message----- From: Siddhartha Jain(IT) [mailto:[EMAIL PROTECTED] Sent: 07 June 2003 17:10 To: [EMAIL PROTECTED] Subject: RE: [ISSForum] re: Report generation in ISS RealSecure I got the patch applied but have run into another problem now. The database size is about 14GB out of which 13GB is RejectedEvents table. I am trying to run the sql script provided by ISS to reload this data back into the permanent tables to generate reports but everytime the script ends in "ISSED Transaction Log full" error. I increased the ISSED transaction log size and also the tempdb size but ran into the same error several times. Is there some way MS-SQL Server can rotate the transaction logs by itself when the max capacity has been utilized? TIA, Siddhartha -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 8:40 PM To: [EMAIL PROTECTED] Subject: [ISSForum] re: Report generation in ISS RealSecure Siddhartha Check the max date on your database and ensure it is July 2012, and not July 2002. RealSecure 6.x Database Patch May 30, 2002 _______________________________________________________________ DESCRIPTION This patch corrects a condition in the RealSecure 6.x Enterprise Database that causes events occuring after July 16, 2002 to be sent to the EventsRejected table. If this patch has not been applied to an affected RealSecure 6.x Enterprise Database by July 16, 2002, a script is available from Internet Security Systems that will reload the rejected events into the permanent tables once this patch has been applied. _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo "This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the intended named recipient of this email then you should not copy it or use it for any purpose, nor disclose its contents to any other person which is strictly prohibited and unlawful" _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo IMPORTANT - THIS E-MAIL AND THE INFORMATION THAT IT CONTAINS, MAY BE CONFIDENTIAL, LEGALLY PRIVILEGED AND PROTECTED BY LAW. ACCESS BY THE INTENDED RECIPIENT ONLY IS AUTHORISED. If you are not the intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information onto any medium. Copyright in this e-mail and its attachments belongs to EDS South Africa (Pty) Ltd. _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo "This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the intended named recipient of this email then you should not copy it or use it for any purpose, nor disclose its contents to any other person which is strictly prohibited and unlawful" _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
