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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 check if some1 is logged on website b4 restarting

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -