修改master库文件路径

--

1,

修改参数：

-dD:\SQLDATA\master.mdf;-eD:\MSSQLSERVER\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lD:\SQLDATA\mastlog.ldf

 

2,

执行脚本：

USE master;
GO
ALTER DATABASE [master]
MODIFY FILE (NAME = mastlog, FILENAME = 'D:\SQLDATA\mastlog.ldf');
GO

ALTER DATABASE [master]
MODIFY FILE (NAME = master, FILENAME = 'D:\SQLDATA\master.mdf');
GO

--

USE model;
GO

ALTER DATABASE [model]
MODIFY FILE (NAME = modellog, FILENAME = 'D:\SQLDATA\modellog.ldf');
GO

ALTER DATABASE [model]
MODIFY FILE (NAME = modeldev, FILENAME = 'D:\SQLDATA\model.mdf');
GO
--

 

USE msdb;
GO

ALTER DATABASE [msdb]
MODIFY FILE (NAME = MSDBLog, FILENAME = 'D:\SQLDATA\MSDBLog.ldf');
GO

ALTER DATABASE [msdb]
MODIFY FILE (NAME = MSDBData, FILENAME = 'D:\SQLDATA\MSDBData.mdf');
GO

select * from sys.database_files

3，拷贝物理文件到相应位置（log，mdf）

4，

重新启动服务，over（如果是cluster，备机的master相关参数也需要修改，然后切换cluster）