Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shut down server for maintenance Expand / Collapse
Author
Message
Posted Monday, December 17, 2012 3:19 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 1,792, Visits: 3,262
We have some server maintenance needed at weekend.

We plan to shut down web server first, then application server, then sql server.

My question is when we shut down SQL server, does it matter to shut down the OS directly or need to shut down SQL server services first then shut down the OS?

Thanks
Post #1397443
Posted Monday, December 17, 2012 3:45 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 12:06 PM
Points: 752, Visits: 5,531
I would expect you could just do a normal Windows shutdown. If you want to be paranoid, then shut down the SQL services first through the SQL Server Configuration Manager.

Of course, also make sure you've got a good backup of your databases beforehand, and not on the server you're working on!

Jason
Post #1397453
Posted Monday, December 17, 2012 3:51 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 1,792, Visits: 3,262
Thanks, that is what I think too.
Post #1397456
Posted Monday, December 17, 2012 9:04 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
I would prefer a clean Sql Server shutdown , not by just windows shutdown.

http://www.sqlservercentral.com/Forums/Topic667203-146-1.aspx
Post #1397531
Posted Tuesday, December 18, 2012 2:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
Any way you like.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1397609
Posted Tuesday, December 18, 2012 3:30 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 1,792, Visits: 3,262
Thanks all.
Also the following is a related question.

Because we are going to do a data center maintenance for a lot of servers, we help networks group to shut down servers.
We have some of the servers have dependency, for example , we need to shut down web server first, then application server, then SQL server. when bringing it back, the opposite order.

But for some applications they only have web server, or sql server, how do we know they have a dependency.

If we start web server first, then SQl server, is it going to be a problem to connect after that?

thanks
Post #1398076
Posted Tuesday, December 18, 2012 3:54 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
sqlfriends (12/18/2012)
If we start web server first, then SQl server, is it going to be a problem to connect after that?


Depends on how the application is written. Ask your developers.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1398084
Posted Tuesday, December 18, 2012 11:11 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:16 AM
Points: 2,840, Visits: 3,983
sqlfriends (12/18/2012)
If we start web server first, then SQl server, is it going to be a problem to connect after that?
Application needs database connection first .So database server should be UP first


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1398180
Posted Wednesday, December 19, 2012 9:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 1,792, Visits: 3,262
Thanks, I understand that.

But in most cases, even SQL server is up later than application server, the application still works.

I just want to know why this happens?

thanks
Post #1398504
Posted Wednesday, December 19, 2012 9:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
sqlfriends (12/19/2012)
I just want to know why this happens?


The developers implemented retry logic. The app doesn't keep persisted connections. The app uses a disconnected model. Many other possibilities.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1398508
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse