一、更改系统数据库路径
USE master;
GO
ALTER DATABASE [master]
MODIFY FILE (NAME = mastlog, FILENAME = 'D:\DATA\mastlog.ldf');
GO
ALTER DATABASE [master]
MODIFY FILE (NAME = master, FILENAME = 'D:\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
ALTER DATABASE tempdb MODIFY FILE (NAME= tempdev , FILENAME= 'D:\tempdbdata\tempdb.mdf')
ALTER DATABASE tempdb MODIFY FILE (NAME= templog , FILENAME= 'D:\tempdbdata\templog.ldf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp2 , FILENAME= 'D:\tempdbdata\tempdb_mssql_2.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp3 , FILENAME= 'D:\tempdbdata\tempdb_mssql_3.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp4 , FILENAME= 'D:\tempdbdata\tempdb_mssql_4.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp5 , FILENAME= 'D:\tempdbdata\tempdb_mssql_5.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp6 , FILENAME= 'D:\tempdbdata\tempdb_mssql_6.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp7 , FILENAME= 'D:\tempdbdata\tempdb_mssql_7.ndf')
ALTER DATABASE tempdb MODIFY FILE (NAME= temp8 , FILENAME= 'D:\tempdbdata\tempdb_mssql_8.ndf')
二、停止数据库服务
三、将系统数据库文件 移动到新的路径下(注意:要给文件夹赋权限 )
将原路径下的文件删除,
master数据库,需要更新启动参数
四、重启服务 数据库迁移完成!