注册 登录
编程论坛 SQL Server论坛

怎么启动SQL Server (MSSQLSERVER)

upan 发布于 2021-01-16 15:57, 1778 次点击
我在任务管理器关掉了SQL Server (MSSQLSERVER),之后就启动不了了,去到计算机管理的SQL Server配置管理器的SQL Server服务那里也启动不了,导致Management Studio一直连接不了服务器,有大佬可以教教我怎么启动SQL Server (MSSQLSERVER)吗

日志如下:
2021-01-16 15:00:11.13 Server      Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
    Sep 24 2019 13:48:23
    Copyright (C) 2019 Microsoft Corporation
    Express Edition (64-bit) on Windows 10 Home China 10.0 <X64> (Build 19041: )

2021-01-16 15:00:11.13 Server      UTC adjustment: 8:00
2021-01-16 15:00:11.13 Server      (c) Microsoft Corporation.
2021-01-16 15:00:11.13 Server      All rights reserved.
2021-01-16 15:00:11.13 Server      Server process ID is 9132.
2021-01-16 15:00:11.13 Server      System Manufacturer: 'ASUSTeK COMPUTER INC.', System Model: 'VivoBook S13 I330UN'.
2021-01-16 15:00:11.13 Server      Authentication mode is MIXED.
2021-01-16 15:00:11.13 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2021-01-16 15:00:11.14 Server      The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2021-01-16 15:00:11.14 Server      Registry startup parameters:
     -d C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
     -e C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
     -l C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2021-01-16 15:00:11.14 Server      Command Line Startup Parameters:
     -s "MSSQLSERVER"
2021-01-16 15:00:11.14 Server      Error: 17113, Severity: 16, State: 1.
2021-01-16 15:00:11.14 Server      Error 3(系统找不到指定的路径。) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
2 回复
#2
likeyou322021-01-17 22:32
Server配置管理器 那里的几个服务都启动不了吗 ,如果启动不了,肯定连接不上 ,真不行重启电脑试试
#3
sssooosss2021-02-23 08:37
库文件被移走了?
1