SQL 2008 Recovery - recovery master db

如果master db還能進入, 直接使用single user mode啟動
然後使用sqlcmd 進行backup

single-user

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn

sqlservr.exe -c -m


backup database master to disk ='c:\backups\master1.bak' with format


backup database msdb to disk ='c:\backups\msdb1.bak' with format

backup database model to disk ='c:\backups\model1.bak' with format



restore database master from disk ='c:\backups\master1.bak'

restore database msdb from disk ='c:\backups\msdb1.bak'

restore database model from disk ='c:\backups\model1.bak'


如果master db都壞了
需要進行rebuild

rebuild

1.cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release


2.setup.exe /QUIET /INSTANCENAME=mssqlserver /ACTION=rebuilddatabase /SQLSYSADMINACCOUNTS=Administrator /SAPWD=P@ssw0rd