Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I created a set of batch scripts that use sc.exe to do just this. They are attached below. To run these scripts, <strong>you should be a user with administration rights on the target machine and running this from a computer that is a member of the same domain</strong>. It's possible to set it up to be able to run from outside of the domain (like from a VPN) but there are a lot of layers of security to work through involving firewalls, DCOM and security credentials.</p> <p>One of these days, I'm going to figure out the PowerShell equivalent, which should be much easier.</p> <h2>safeServiceStart.bat</h2> <pre><code>@echo off :: This script originally authored by Eric Falsken IF [%1]==[] GOTO usage IF [%2]==[] GOTO usage ping -n 1 %1 | FIND "TTL=" &gt;NUL IF errorlevel 1 GOTO SystemOffline SC \\%1 query %2 | FIND "STATE" &gt;NUL IF errorlevel 1 GOTO SystemOffline :ResolveInitialState SC \\%1 query %2 | FIND "STATE" | FIND "STOPPED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StartService SC \\%1 query %2 | FIND "STATE" | FIND "RUNNING" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StartedService SC \\%1 query %2 | FIND "STATE" | FIND "PAUSED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO SystemOffline echo Service State is changing, waiting for service to resolve its state before making changes sc \\%1 query %2 | Find "STATE" timeout /t 2 /nobreak &gt;NUL GOTO ResolveInitialState :StartService echo Starting %2 on \\%1 sc \\%1 start %2 &gt;NUL GOTO StartingService :StartingServiceDelay echo Waiting for %2 to start timeout /t 2 /nobreak &gt;NUL :StartingService SC \\%1 query %2 | FIND "STATE" | FIND "RUNNING" &gt;NUL IF errorlevel 1 GOTO StartingServiceDelay :StartedService echo %2 on \\%1 is started GOTO:eof :SystemOffline echo Server \\%1 is not accessible or is offline GOTO:eof :usage echo %0 [system name] [service name] echo Example: %0 server1 MyService echo. GOTO:eof </code></pre> <h2>safeServiceStop.bat</h2> <pre><code>@echo off :: This script originally authored by Eric Falsken IF [%1]==[] GOTO usage IF [%2]==[] GOTO usage ping -n 1 %1 | FIND "TTL=" &gt;NUL IF errorlevel 1 GOTO SystemOffline SC \\%1 query %2 | FIND "STATE" &gt;NUL IF errorlevel 1 GOTO SystemOffline :ResolveInitialState SC \\%1 query %2 | FIND "STATE" | FIND "RUNNING" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StopService SC \\%1 query %2 | FIND "STATE" | FIND "STOPPED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StopedService SC \\%1 query %2 | FIND "STATE" | FIND "PAUSED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO SystemOffline echo Service State is changing, waiting for service to resolve its state before making changes sc \\%1 query %2 | Find "STATE" timeout /t 2 /nobreak &gt;NUL GOTO ResolveInitialState :StopService echo Stopping %2 on \\%1 sc \\%1 stop %2 %3 &gt;NUL GOTO StopingService :StopingServiceDelay echo Waiting for %2 to stop timeout /t 2 /nobreak &gt;NUL :StopingService SC \\%1 query %2 | FIND "STATE" | FIND "STOPPED" &gt;NUL IF errorlevel 1 GOTO StopingServiceDelay :StopedService echo %2 on \\%1 is stopped GOTO:eof :SystemOffline echo Server \\%1 or service %2 is not accessible or is offline GOTO:eof :usage echo Will cause a remote service to STOP (if not already stopped). echo This script will waiting for the service to enter the stopped state if necessary. echo. echo %0 [system name] [service name] {reason} echo Example: %0 server1 MyService echo. echo For reason codes, run "sc stop" GOTO:eof </code></pre> <h2>safeServiceRestart.bat</h2> <pre><code>@echo off :: This script originally authored by Eric Falsken if [%1]==[] GOTO usage if [%2]==[] GOTO usage ping -n 1 %1 | FIND "TTL=" &gt;NUL IF errorlevel 1 GOTO SystemOffline SC \\%1 query %2 | FIND "STATE" &gt;NUL IF errorlevel 1 GOTO SystemOffline :ResolveInitialState SC \\%1 query %2 | FIND "STATE" | FIND "RUNNING" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StopService SC \\%1 query %2 | FIND "STATE" | FIND "STOPPED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO StartService SC \\%1 query %2 | FIND "STATE" | FIND "PAUSED" &gt;NUL IF errorlevel 0 IF NOT errorlevel 1 GOTO SystemOffline echo Service State is changing, waiting for service to resolve its state before making changes sc \\%1 query %2 | Find "STATE" timeout /t 2 /nobreak &gt;NUL GOTO ResolveInitialState :StopService echo Stopping %2 on \\%1 sc \\%1 stop %2 %3 &gt;NUL GOTO StopingService :StopingServiceDelay echo Waiting for %2 to stop timeout /t 2 /nobreak &gt;NUL :StopingService SC \\%1 query %2 | FIND "STATE" | FIND "STOPPED" &gt;NUL IF errorlevel 1 GOTO StopingServiceDelay :StopedService echo %2 on \\%1 is stopped GOTO StartService :StartService echo Starting %2 on \\%1 sc \\%1 start %2 &gt;NUL GOTO StartingService :StartingServiceDelay echo Waiting for %2 to start timeout /t 2 /nobreak &gt;NUL :StartingService SC \\%1 query %2 | FIND "STATE" | FIND "RUNNING" &gt;NUL IF errorlevel 1 GOTO StartingServiceDelay :StartedService echo %2 on \\%1 is started GOTO:eof :SystemOffline echo Server \\%1 or service %2 is not accessible or is offline GOTO:eof :usage echo Will restart a remote service, waiting for the service to stop/start (if necessary) echo. echo %0 [system name] [service name] {reason} echo Example: %0 server1 MyService echo. echo For reason codes, run "sc stop" GOTO:eof </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POStopping/Starting a remote Windows service and waiting for it to open/close
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNux
    1. USEric Falsken
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POStopping/Starting a remote Windows service and waiting for it to open/close
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONote that the timeout command is only available in Vista and Server 2003 (and newer). On Windows XP, use the SLEEP command found in the NT Resource Kit. (Thanks James)
      singulars
      1. PO
      1. USEric Falsken
    2. COAlso note that the ping command to check for the availability of the server assumes that the server is on IPv4. Probably would be better to include the '-4' switch to force ping to use IPv4.
      singulars
      1. PO
      1. USBenjamin Wegman
    3. COKudos for useful scripts! Note that if you have some other FIND command in your path, e.g. a Unix `find` from cygwin, it'll trip this script up.
      singulars
      1. PO
      1. USLarsH
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload