?
Solved

SQL Server Reboot - ASPX App

Posted on 2011-09-14
1
Medium Priority
?
289 Views
Last Modified: 2012-05-12
Is there a way to automatically take a web app off line when the SQL servers being rebooted?  This reboot occurs everyday at a precise time (scheduled event) and generation 15 - 20 error messages when external customers try connect via the web site.
0
Comment
Question by:TimSweet220
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
manishkungwani earned 2000 total points
ID: 36537379
If you take the app offline, the errors will be uglier.
I will suggest that in the masterpage, check for the DB availability and if down, show a single Error page.
You can configure the same in the Global.asax file.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question