sql server master恢复

sql server master恢复2014-03-14----故障1：master有备份

1.backup database for master

backup database master to disk="e:master.bkf" with format

2.stop mssqlserver service

net stop mssqlserver

3.start sqlserver with single user mode

C:>cd C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlservr -c -f -m

4.restore master database from backup files

C:Documents and SettingsAdministrator>sqlcmd

1> restore database master from disk="e:master.bkf"

2> go

已为数据库 "master"，文件 "master" （位于文件 1 上）处理了 376 页。

已为数据库 "master"，文件 "mastlog" （位于文件 1 上）处理了 3 页。

已成功地还原了 master 数据库。正在关闭 SQL Server。

SQL Server 正在终止此进程。

5.start the sqlserver in normal

C:Documents and SettingsAdministrator>net start mssqlserver

SQL Server （MSSQLSERVER）服务正在启动 ..

SQL Server （MSSQLSERVER）服务已经启动成功。

---故障2：master只是数据库文件名或路劲不对

1.停止mssqlserver服务

net stop mssqlserver

2.修改master的mdf名字

cd C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData

ren master.mdf master01.mdf

3.net start mssqlserver

4.查看error文件

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG：

2010-02-08 12:02:00.88 Server Error: 17113, Severity: 16, State: 1.

2010-02-08 12:02:00.88 Server Error 2（系统找不到指定的文件。） occurred while opening file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf" to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

5.按照errorlog提示修改文件名

ren master01.mdf master.mdf

6.启动

net start mssqlserver

---故障3：master没有备份

start /wait d:setup.exe /qn instancename=mssqlserver reinstall=sql_engine rebuilddatabase=1 sapwd=sa sqlbrowserpassword=chinese_prc_bin