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

Need to shut down sql instances with out disturbing other instances... Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 4:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:18 AM
Points: 104, Visits: 401

As we have four instances in one physical server which is all are 2005 instances. In this one instance not able to shutdown propertly. But we need to shut down this instance without disturbing other three instances since these are production 24x7 critical servers. Please suggest any one...


Post #1498251
Posted Wednesday, September 25, 2013 4:57 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 39,952, Visits: 36,306
Go into SQL configuration manager, right click that SQL service and select Stop.


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 #1498254
Posted Monday, September 30, 2013 7:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:18 AM
Points: 104, Visits: 401
As I have tried from all the options as configuration manager,command prompt and services.msc , but there is no chance to stop/shutdown the SQL. Can you please provide any other ways to stop the sql with out any distrubances to other instances.

Thanks in advance....
Post #1500004
Posted Monday, September 30, 2013 8:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 39,952, Visits: 36,306
What do you mean there's no chance? That's how you stop the SQL Server service, from there (preferably) or from services.


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 #1500021
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse