<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
1、停止数据库服务,以单用户模式启动数据库,方法是在命令提示符下输入:
sqlservr-c-f-m
2、进入查询分析器,运行如下命令:
restoredatabasemasterfromdisk='c:/master'
注意:恢复系统数据库的顺序为:master->msdb->model
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
1、停止数据库服务,以单用户模式启动数据库,方法是在命令提示符下输入:
sqlservr-c-f-m
2、进入查询分析器,运行如下命令:
restoredatabasemasterfromdisk='c:/master'
注意:恢复系统数据库的顺序为:master->msdb->model
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>