重建后什么都没有了,重建前一定要备份。
重新生成系统数据库 - SQL Server | Microsoft Learn
C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\SQLServer2022
setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=accounts /SAPWD= StrongPassword
这是更改服务器排序规则方法:
C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019>
setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" /SAPWD= "" /SQLCOLLATION=Chinese_PRC_CI_AI
在系统管理员被锁定时连接到 SQL Server - SQL Server | Microsoft Learn
rebuid之后没有数据库账号:
以单用户模式启动数据库:
NET STOP MSSQLSERVER
NET START MSSQLSERVER /m (或者在资源管理器右键,添加-m)
打开SQL Server Management Studio,不要进入资源浏览器,直接点击“New Query”
这时候如果有进程占用,那么用sqlcmd kill:(sqlcmd go生效)
sqlcmd 实用工具 - SQL Server | Microsoft Learn
Sqlcmd -S -U -P
CREATE LOGIN TempLogin WITH PASSWORD = '$strong_password';
ALTER SERVER ROLE sysadmin ADD MEMBER TempLogin;
在系统管理员被锁定时连接到 SQL Server - SQL Server | Microsoft Learn
NET STOP MSSQLSERVER
NET START MSSQLSERVER
再恢复备份好的mater数据库
10.122.197.116 更改成功:(因为镜像挂载在F:,之前一直在
C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\SQLServer2022就失败
结果在C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log summary.txt里面看)
F:\>setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="sa" /SAPWD="abcdabcd" /SQLCOLLATION=Japanese_CI_AS
Microsoft (R) SQL Server 2022 16.00.1000.06
Copyright (c) 2022 Microsoft. All rights reserved.
SQL Server 2022 transmits information about your installation experience, as well as other usage and performance data, to Microsoft to help improve the product. To learn more about SQL Server 2022 data processing and privacy controls, please see the Privacy Statement.
F:\>