Shut down server for maintenance

Question

Shut down server for maintenance

sqlfriend

SSC Guru

Points: 52781
More actions
December 17, 2012 at 3:19 pm

#271705

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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

jasona.work SSC Guru Points: 50118 More actions · Answer 1

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

sqlfriend SSC Guru Points: 52781 More actions · Answer 2

sqlfriend

SSC Guru

Points: 52781

December 17, 2012 at 3:51 pm

#1569310

Thanks, that is what I think too.

SQL Show SSCertifiable Points: 6143 More actions · Answer 3

I would prefer a clean Sql Server shutdown , not by just windows shutdown.

http://www.sqlservercentral.com/Forums/Topic667203-146-1.aspx

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Any way you like.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

sqlfriend SSC Guru Points: 52781 More actions · Answer 5

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

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, MVP, M.Sc (Comp Sci)
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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

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;-)

sqlfriend SSC Guru Points: 52781 More actions · Answer 8

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

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, MVP, M.Sc (Comp Sci)
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