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 |
modest
Starting Member
32 Posts |
Posted - 2006-08-29 : 13:27:56
|
As you know, security updates and SPs are part and parcel of Windows Operating system.Here is my question:Every month after applying the patches we have to restart our windows 2k3 server so that the patches applied are in effect. Now before restarting, how can we make sure that no one is logged on our website (otherwise the user's work will get lost if we restart our servers in middle of user's session) and using database or some functionality. Generally we do it at late nights over weekend where chances of anybody logged in are less. Right now in order to make sure that no one is using our website, we check our awstats log. Is there any other convinient method to do the same?We are using SQL2k5, IIS 6.0 on windows 2k3 platform.Thanks |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-29 : 15:15:57
|
This seems like an IIS administration question, not a SQL Server administration question.CODO ERGO SUM |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-29 : 15:19:18
|
I agree with Michael. IIS will be connected to the SQL Server even if no user is accessing the web site, so you won't be able to determine this from the SQL Server side.Tara Kizer |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-29 : 15:50:18
|
standard procedure for performing maintenance on a webserver is to put up a "sorry" page while the system is unavailable. This then completely disconnects users from your web app, making your upgrade easier.-ec |
|
|
|
|
|