陈中祥的BLOG

  IT博客 :: 首页 :: 联系 :: 聚合  :: 管理
  12 Posts :: 30 Stories :: 3 Comments :: 0 Trackbacks

Restore SQL Server 2000 MASTER DatabaseThe MASTER database can only be restored when the database is in single-user mode. To place it in single user mode:
1.Stop SQL Server
    net stop MSSQLServer
2.To start SQL Server in single user mode type:
    sqlservr -m
If this is not recognised then cd to 'C:\Program Files\Microsoft SQL Server\MSSQL\BINN' and try again.
3. Start to restore the MASTER database from the backup file
Note: While SQL Server is in single user mode you should still be able to connect from SQL Server Query Analyzer if you connect using the "sa" account.
4. Once the MASTER database has been restored (the restore will have caused the database to be shutdown) start the database by issuing the following command at the command line:
net start MSSQLServerNote:Remember that the password for the 'sa' account will now be what it was at the time of the original backup.

posted on 2006-06-13 17:52 alexchen 阅读(336) 评论(0)  编辑 收藏 引用
只有注册用户登录后才能发表评论。