ASP problem after restarting SQL Service service

ASP problem after restarting SQL Service service

am 02.11.2004 12:09:32 von mark

Hi all,

SQL server data is backed up every night - the services stop (SQL
server + agent), the backup runs, then the service starts again. This
worked fine until recently.

Now what happens is after SQL restarts IIS is really slow or times out
trying to get a page, so I have to restart the web service (www
publishing) to get it working.

But after restarting the web services I get random 0x800A01FB errors
with An exception occurred: 'conn.Open'. This happens maybe 1 in 10
times when requesting a page - I keep hitting refresh and it will
occur.

The code is fine, connections/objects are closed as they should be.

The solution is to keep restarting the web service until it eventually
works.

Has anyone seen this or can offer a solution/suggestion?