52

SQL SERVER数据库master数据库恢复-侯良金-51CTO博客

 6 years ago
source link: http://blog.51cto.com/houliangjin/2067089
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQL SERVER数据库master数据库恢复一、实验步骤大概1、先创建一个数据库和表,用来做恢复之后的验证。2、把master数据库提前做好备份。3、模拟master数据库删除,在服务里边关闭SQL server服务然后才能删除master数据库。4、重启SQL server服务,发现无法启动!5、重建数据库。6、进入单用户模式,恢复master数据库。7、再次重启,进入数据库查看之前创建的数据库和表已经恢复,发现恢复正常!

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK