修改SQL 2008的数据文件目录
use master;
go
alter database master
modify file (name = master,filename='J:datamaster.mdf');
go
alter database master
modify file (name = mastlog,filename='J:datamastlog.ldf');
go
alter database tempdb
modify file (name = tempdev,filename='J:datatempdb.mdf');
go
alter database tempdb
modify file (name = templog,filename='J:datatemplog.ldf');
go
alter database msdb
modify file (name = msdbData,filename='J:dataMSDBData.mdf');
go
alter database msdb
modify file (name = MSDBlog,filename='J:dataMSDBLog.ldf');
go
alter database model
modify file (name = modeldev,filename='J:datamodel.mdf');
go
alter database model
modify file (name = modellog,filename='J:datamodellog.ldf');
go
最后更新于 2020-02-09 12:42:08 并被添加「sql sql2008 数据库」标签，已有 1156 位童鞋阅读过。
本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处