How To Move System DB's to another drive.

How To Move System DB's to another drive.

1) Master
1) Check the existing path using sp_helpdb 'master'
2) Go to SQL Server Configuration Manager
3) Navigate to the sql server service.
4) Go to sql server properties.
5) copy startup parameter for .mdf and .ldf file.
6) Update that parameter to the location that you wish to move.
7) Apply those changes.
8) Copy .mdf and .ldf files of the master database to the new location.
7) Start sql server services.

2) MSDB

1) Go to SSMS.
2) Check the existing path using sp_helpdb.
2) Use the below query to modify system catalog:

ALTER DATABASE msdb
MODIFY FILE (NAME = MSDBData, FILENAME = 'Path of the filename');
GO
ALTER DATABASE msdb
MODIFY FILE (NAME = MSDBLog, FILENAME = 'Path of the filename');
GO
3) Stop the SQL Server Servies.
4) Move .mdf and .ldf file to the new directory.
5) Start sql server services.

Use the same procedure to move MODEL and TEMPDB.