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

一、更改系统数据库路径

USE master;
GO
ALTER DATAbase [master]
MODIFY FILE (NAME = mastlog, FILENAME = 'D:DATAmastlog.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:SQLDATAmodellog.ldf');
GO

ALTER DATAbase [model]
MODIFY FILE (NAME = modeldev, FILENAME = 'D:SQLDATAmodel.mdf');
GO

USE msdb;
GO

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

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

ALTER DATAbase tempdb MODIFY FILE (NAME= tempdev , FILENAME= 'D:tempdbdatatempdb.mdf')
ALTER DATAbase tempdb MODIFY FILE (NAME= templog , FILENAME= 'D:tempdbdatatemplog.ldf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp2 , FILENAME= 'D:tempdbdatatempdb_mssql_2.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp3 , FILENAME= 'D:tempdbdatatempdb_mssql_3.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp4 , FILENAME= 'D:tempdbdatatempdb_mssql_4.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp5 , FILENAME= 'D:tempdbdatatempdb_mssql_5.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp6 , FILENAME= 'D:tempdbdatatempdb_mssql_6.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp7 , FILENAME= 'D:tempdbdatatempdb_mssql_7.ndf')
ALTER DATAbase tempdb MODIFY FILE (NAME= temp8 , FILENAME= 'D:tempdbdatatempdb_mssql_8.ndf')

二、停止数据库服务

三、将系统数据库文件 移动到新的路径下（注意：要给文件夹赋权限 ）

 将原路径下的文件删除，

master数据库，需要更新启动参数

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