Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
black_tupa
Starting Member
2 Posts |
 Posted - 2007-10-24 : 04:53:02
|
| Hello,I'm trying to create a custom error page for sql server under maintenance but having trouble finding how to flag if the sql server is under maintenance or just unreachable. does sql have a status code or error code for servers under maintenance? thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-24 : 05:02:06
|
| What do you define as "under maintenance"?If the SQL Service is stopped then the port it listens on will appear to be unreachable.We just redirect to a "server down" type page if SQL Server is unreachable. We presume that it was reachable when the site was built! and therefore unreachable is equivalent of Server DownKristen |
 |
|
|
black_tupa
Starting Member
2 Posts |
Posted - 2007-10-24 : 07:44:02
|
| thanks for the reply...what i meant of under maintenance is an upgrade to the server that requires it to be shutdown totally. thanks again. =) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-24 : 07:55:55
|
| Well if its shutdown totally there isn't a way to detect that ... it will just look like it isn't available / responding. Which is the route we assume, as I described above.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-24 : 23:17:09
|
| Don't think sql has that kind of status code. |
|
|
|
|
|
|
SQL Server Maintenance Status code