重新生成系統數據庫,重新生成master數據庫
發布時間:2025/2/7 19:54:53 作者:Admin 閱讀:8
廣告:
第一個方法:
start /wait e:\setup.exe INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=DBM001
setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=accounts [ /SAPWD= DBM001 ] [ /SQLCOLLATION=CollationName ]
setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=HWSQLDBB\Administrator
第二個方法:
setup /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=HWSQLDBB\Administrator
https://learn.microsoft.com/zh-cn/sql/relational-databases/databases/rebuild-system-databases?view=sql-server-ver16&redirectedfrom=MSDN
廣告:
相關文章