Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to shutdown with nowait on a clustered instance? I want to delay recovery to when the instance starts, and I want to shut down as quickly as possible without issuing checkpoints to my clustered instances. If I issue a SHUTDOWN WITH NOWAIT, SQL Server sends a SERVICE_CONTROL_STOP message which causes it to go into a Failed state. The cluster service then starts it up, which is not what I want.

Ideas?

share|improve this question
    
Why do you want to do that ? SHUTDOWN WITH NOWAIT is like pulling power cable out of your server. –  Kin Aug 28 '13 at 13:05
    
Ideas? -- Yes: stop doing that. –  Jon Seigel Aug 28 '13 at 15:29
    
I've done some testing on this and discovered that SQL Server in a cluster ALWAYS does a SHUTDOWN WITH NOWAIT. Interesting, in that you CAN'T do a graceful shutdown on a cluster. Kind of surprised me... And if you don't believe me test it yourself. BEGIN TRAN, change some data and then take your SQL Server service offline in cluster manager. Start up and see if your transaction is there... –  Moo MinTroll Aug 28 '13 at 15:49
    
@MooMinTroll Whether the changes made by your transaction are present after it starts again has do with whether your transaction was committed, not whether SQL Server shut down with NOWAIT. –  James Aug 28 '13 at 18:42
    
@MooMinTroll the WITH NOWAIT option --> Shuts down SQL Server without performing checkpoints in every database. SQL Server exits after attempting to terminate all user processes. When the server restarts, a rollback operation occurs for uncompleted transactions. –  Kin Aug 28 '13 at 19:14
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.