how to shutdown database server

• rishi anjali

  SSC-Addicted

  Points: 434

  More actions

  September 15, 2010 at 2:34 am

  #224062

  hi all,

  could you help me in shutting down the database server.

  how to shutdown database server?

  please tel me the steps to do the same

  regards,

  anjali

• Mike John

  SSCertifiable

  Points: 7216

  More actions

  September 15, 2010 at 2:40 am

  #1221180

  Various options - it runs as a Windows Service so the services applet in control panel is one way.

  Or Net Stop MSSQLSERVER from a command prompt

  or Shutdown command in TSQL

  Details of all the above can be found in BOL.

  Mike