A very insightful bit of writing by Richar Seroter on what happens to BizTalk Web Service receive locations when the DB goes bye bye. When the SQL Server goes off line, take down the IIS service on your BizTalk servers.  This is really kind of scary.  When the SQL Server goes offline, the BizTalk web services return 202's which is just as good as a 200 to most - and the message is lost.  I need to think this one through and see how to deal with it.  We don't lose our database alot, but it has gone offline on enough occasions to make this a real concern.  Anybody have expereince handling this one?