SqlSever 系统数据库迁移（其他数据库迁移方式一样）

一、更改系统数据库路径

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数据库，需要更新启动参数

 

四、重启服务 数据库迁移完成！