重新生成系統(tǒng)數(shù)據(jù)庫,重新生成master數(shù)據(jù)庫
發(fā)布時間:2025/2/7 19:54:53 作者:Admin 閱讀:12
廣告:
第一個方法:
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
廣告:
相關(guān)文章