Re: SQL Server hangs every night

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 12:23:44 -0500

Is the database set to single user/dbo use only mode? 

-- 
Keith
"Ron Hinds" <__NoSpam@__NoSpamramac.com> wrote in message
news:u$JROSclEHA.3968@TK2MSFTNGP11.phx.gbl...
> Well actually the SQL Server isn't "hanging" - it's only one database on
the
> server that for some reason won't allow any more connections each morning.
> The error the users get (using Access front end) is ODBC call failed or
> sometimes network error. SQL Server 2000 SP3a EE running on Windows 2000
> Server SP4. Another database on the same server has no problems. No errors
> are reported in the SQL Server logs or the Event Viewer. The only other
> symptom is two of the three jobs scheduled to run nightly did not run. One
> says failed - the other says nothing at all! The three jobs are 1)
Integrity
> check - succeeds & runs first at 1:00 AM; 2) Optimizations - scheduled to
> run at 1:30 AM & shows failed as of last Friday, but no other failure
> messages since; and 3) Complete Backup - scheduled to run at 3:30 AM &
shows
> succeeded as of last Friday, but no other failure messages since. Can
anyone
> give me any clues as to where to start troubleshooting this?
>
>

Relevant Pages