MSSQL服务丢失后,恢复mssql服务的方法

已为老胡 2022-08-12 PM 1047℃ 0条

  服务器突然MSSQL的服务丢了,用下面这个方法,不用重装MSSQLserver了

  sc create MSSQLSERVER binpath= "\"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe\" -sMSSQLSERVER" displayname= "SQL Server (MSSQLSERVER)" depend= Tcpip start= auto

  sc create SQLSERVERAGENT binpath= "\"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE\" -i MSSQLSERVER" displayname= "SQL Server Agent (MSSQLSERVER)" depend= Tcpip start= auto


标签: none

非特殊说明,本博所有文章均为博主原创。

评论啦~