how to shutdown ?

Question

Post reply

how to shutdown ?

spectra

SSCarpal Tunnel

Points: 4120
More actions
September 19, 2014 at 9:45 am

#293338

How to shutdown sqlserver 2008 R2 ?
How to start after shutdown ?
My OS windows 2007

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

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

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

Safest way is through the SQL Server Configuration Manager.

Right click the database engine service and choose stop. Be aware this will immediately stop the service!

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 2

DBA From The Cold (9/19/2014)
Safest way is through the SQL Server Configuration Manager.
Right click the database engine service and choose stop. Be aware this will immediately stop the service!

what is that ? Did you mean SQL Server Management Studio ? yea..I have SQL Server Management Studio.

Please let me know if SQL Server Configuration Manager is same as SQL Server Management Studio.

Wison SSC-Addicted Points: 425 More actions · Answer 3

No. SSMS is not same as configuration manager.

if it is sql server 2008 or 2008 r2, you can type sqlservermanager10.msc

if 2012,please type sqlservermanager11.msc

Btw,there is no any operation system whose number is 2007

Steve Jones - SSC Editor SSC Guru Points: 736458 More actions · Answer 4

You can run Configuration Manager, which is a separate application in the Start menu for the system. It will allow you to shut down the instance.

You can also right click the instance in Management Studio and select "stop" or click the button in the toolbar if it is visible.

You can issue a "Shutdown" in T-SQL.

you can press stop in Services.

All of those send a shutdown command to SQL Server.

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 5

DBA From The Cold (9/19/2014)
Safest way is through the SQL Server Configuration Manager.
Right click the database engine service and choose stop. Be aware this will immediately stop the service!

There is no database engine service.

spectra SSCarpal Tunnel Points: 4120 More actions · Answer 6

Steve Jones - SSC Editor (9/20/2014)
You can also right click the instance in Management Studio and select "stop" or click the button in the toolbar if it is visible.

Thanks

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 7

spectra (9/20/2014)
DBA From The Cold (9/19/2014)
Safest way is through the SQL Server Configuration Manager.
Right click the database engine service and choose stop. Be aware this will immediately stop the service!
There is no database engine service.

Click on sqlserver services. You will get different sql server services.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 8

...or from a command promt

net stop "instance name"

😎

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 9

A clean shut down & start up is always through "SQL Configuration Manager".

Thanks.