It Depends. If the app servers are going to be looking to the SQL Server for a connection you may want to put of a "sitedown" page to let users know the site/application will be unavailable
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience