如何：停止并重新启动Microsoft SQL Server服务到SQL Server .NET的实例

本文介绍了如何：停止并重新启动Microsoft SQL Server服务到SQL Server .NET的实例的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想从visual studio 2012重新启动SQL Server 2012.根据MSDN，我定义了一个类并在其上实现了此代码。但它不起作用。事实上，该程序陷入循环。

I want to restart SQL server 2012 from visual studio 2012. According to MSDN I define a class and implemented this code on it. But it doesn''t work. In fact, the program entrap on loop.

Microsoft.SqlServer.ConnectionInfo.dll Microsoft.SqlServer.Smo.dll Microsoft.SqlServer.SqlEnum.dll Microsoft.SqlServer.Smo.WmiEnum Microsoft.SqlServer.Management.Sdk.Sfc.dll public static class SQLServer { public static void Restart() { ManagedComputer mc = new ManagedComputer(); Service svc = new Service(); svc = mc.Services["MSSQLSERVER"]; if (svc.ServiceState== ServiceState.Running) { svc.Stop(); } while (svc.ServiceState== ServiceState.Running ) { svc.Refresh(); } svc.Start(); } }

推荐答案

使用以下方法处理C＃中的服务 Use the following Method for handling Services in C# using System.ServiceProcess; public static class SQLServer { public static void Restart() { string strSVCName = "MSSQLSERVER"; ServiceController mySC = new ServiceController(strSVCName); if (mySC.Status == System.ServiceProcess.ServiceControllerStatus.Stopped) { mySC.Refresh(); } else if (mySC.Status == System.ServiceProcess.ServiceControllerStatus.Running) { mySC.Refresh(); } mySC.Start(); } }

希望这会对你有所帮助。

Hope this helps you.