SQL 2008 還原Master

cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=administrator /SAPWD=xxxxxxxx

cd C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn
sqlservr.exe -m

sqlcmd
USE MSDB
GO
RESTORE DATABASE master
FROM disk='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\master.bak'
GO

發佈留言

*