No, because I keep my patches up to date. Have you run the slammer removal tool?
Moving the database to another machine only infects the next machine. If all else fails, Set up a clean install, newly formatted drive. apply all the security patches. Set up a unique port for SQL communication, and avoid the default port 1434 Restore a known clean copy of the database from a backup from before the infection. Re- enter any data missing from the date of the backup to the current date. ===================================== Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org ===================================== ----- Original Message ----- From: "Buddy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 12:51 PM Subject: SQL SP3 and CF5 Crashtacular!!!!! | Hi everyone. | I have been away from the group for a while. I hope all has been going well. | I have a problem and I am hoping that y'all can help me sort it out. We had | an application server and a sql server server running very nicely until the | sql slammer virus hit a few weeks ago, during the chaos of that day the | application server died, of unrelated causes. We moved the application to a | new box (still talking to the same, but newly patched sql server), but it | was unreliable. It kept going down and we were unable to figure out why. So | we moved the code to another box. It did okay there for a while, but as the | load increases a snowball effect starts where there are some unresponsive | threads and then there are more and more and more, and then the cf server | restarts itself and tries again, and it all happens over again. Thinking | that it could be problems on the db box we just replaced that, and we are | still having the same problem. Have any of you guys encountered a similar | problem? | | Thanks in advance for your help. | Buddy | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
