Skip to content

SQL数据库

2009/10/13
by
灾难恢复
 
排他访问权
 
将数据库还原到新位置
 
还原master数据库
 
系统数据库的移动:
  • master
    • 更改master启动参数
    • 重起SQL服务
  • model
    • 启动SQL服务使用-T3608参数
    • 分离, 附加数据库
  • msdb
    • 启动SQL服务使用-T3608参数
    • 分离, 附加数据库
  • tempdb
    • 更改指向文件

 

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: