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