On 11/9/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > Is the database server itself running in single-user mode, or is the > specific database in question set to single-user mode? I can't see how > deadlocks, no matter how frequent, would cause either. Typically, this might > be caused by a database maintenance plan or some other sort of maintenance > operation.
I'm honestly not sure off-hand whether it is the database or the server that is switching to single user. (That's what the boss told me was the reason that he wrote the script and he's not available right now for me to ask. Something about sleep.) The most frequently run maintenance plan is a backup of the transaction logs that happens every 4 hours. But the restarts happen less than every 2.5 hours and not on a regular schedule (at least not that I've noticed so far. I am building up logs to track this so I can see if there are restarts at certain times of day). The rest of the maintenance plans are running every night or every week, and succeeding, which I find totally astounding. Thanks for the input! -- "If Dag thinks that the only way to contain this is to boil her, then I'm backing him 110%. That means I can backtrack 10% and I'd still be completely behind him!" Garth Marenghi's Darkplace Now blogging.... http://www.blivit.org/blog/index.cfm http://www.blivit.org/mr_urc/index.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Server/message.cfm/messageid:6162 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
