本文共 849 字,大约阅读时间需要 2 分钟。
--
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'); GOALTER DATABASE [master]
MODIFY FILE (NAME = master, FILENAME = 'D:\SQLDATA\master.mdf'); GO--
USE model;
GOALTER DATABASE [model]
MODIFY FILE (NAME = modellog, FILENAME = 'D:\SQLDATA\modellog.ldf'); GOALTER DATABASE [model]
MODIFY FILE (NAME = modeldev, FILENAME = 'D:\SQLDATA\model.mdf'); GO --
USE msdb;
GOALTER DATABASE [msdb]
MODIFY FILE (NAME = MSDBLog, FILENAME = 'D:\SQLDATA\MSDBLog.ldf'); GOALTER DATABASE [msdb]
MODIFY FILE (NAME = MSDBData, FILENAME = 'D:\SQLDATA\MSDBData.mdf'); GOselect * from sys.database_files
3,拷贝物理文件到相应位置(log,mdf)
4,
重新启动服务,over(如果是cluster,备机的master相关参数也需要修改,然后切换cluster)
转载地址:http://pafmi.baihongyu.com/