Welcome to TechNet Blogs Sign in | Join | Help

How to check the status of SQL Server Services remotely?

There is windows “SC” utility and  the following “Heart Beat” approach.

http://www.databasejournal.com/features/mssql/print.php/3347241

 

You can use SC query and look for string RUNNING

 

SC \\machineName query  MSSQLSERVER ! findstr “RUNNING”

 

Published Tuesday, March 06, 2007 9:39 AM by vishah
Filed under:

Comments

Anonymous comments are disabled
 
Page view tracker