How to move the master
and msdb
databases ands their logfiles to a new location. I used L:\
as my log disk, and E:\
as my database disk.
USE master
Go
ALTER DATABASE model
MODIFY FILE ( NAME = 'modeldev' , FILENAME = E:\MSSQL\DATA\model.mdf' );
Go
ALTER DATABASE model
MODIFY FILE ( NAME = 'modellog' , FILENAME = L:\MSSQL\DATA\modellog.ldf' );
Go
ALTER DATABASE msdb
MODIFY FILE ( NAME = 'MSDBData' , FILENAME = 'E:\MSSQL\DATA\MSDBData.mdf' );
Go
ALTER DATABASE msdb
MODIFY FILE ( NAME = 'MSDBLog' , FILENAME = 'L:\MSSQL\DATA\MSDBLog.ldf' );
Go
See where your system dbs are located:
USE master
Go
SELECT
DB_NAME(database_id) AS "Database Name"
, name AS "Logical File Name"
, physical_name AS "Physical File Location"
, state_desc AS "State"
FROM
sys.master_files
WHERE
database_id IN (DB_ID(N'msdb'), DB_ID(N'model'), DB_ID(N'temp'))
ORDER BY
DB_NAME(database_id);
Go