ASP problem after restarting SQL Service service
am 02.11.2004 12:09:32 von markHi 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?