-- -- 1 - Find system databases (msdb, model, tempdb, distribution) -- SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id IN ( DB_ID(N'msdb'), DB_ID(N'model'), DB_ID(N'tempdb'), DB_ID(N'distribution') ) -- -- 2 - Update the file location -- ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'c:\mssql\data\model.mdf' ); ALTER DATABASE model MODIFY FILE ( NAME = modellog , FILENAME = 'c:\mssql\log\model.ldf' ); ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev , FILENAME = 'c:\mssql\data\tempdb.mdf' ); ALTER DATABASE tempdb MODIFY FILE ( NAME = templog , FILENAME = 'c:\mssql\log\tempdb.ldf' ); ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData , FILENAME = 'c:\mssql\data\MSDBData.mdf' ); ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog , FILENAME = 'c:\mssql\log\MSDBLog.ldf' ); -- -- 3 - Stop services (database engine, sql agent & sql browser() -- -- NET STOP "SQL Server Browser" -- NET STOP "SQL Server Agent (MSSQLSERVER)" -- NET STOP "SQL Server (MSSQLSERVER)" -- NET STOP "SQL Server Integration Services 10.0" -- NET STOP "SQL Server Analysis Services (MSSQLSERVER)" -- NET STOP "SQL Server Reporting Services (MSSQLSERVER)" -- -- 4 - Copy files to new homes -- -- -- 5 - Start services (database engine, sql agent & sql browser() -- -- NET START "SQL Server (MSSQLSERVER)" -- NET START "SQL Server Browser" -- NET START "SQL Server Agent (MSSQLSERVER)" -- NET START "SQL Server Integration Services 10.0" -- NET START "SQL Server Analysis Services (MSSQLSERVER)" -- NET START "SQL Server Reporting Services (MSSQLSERVER)" -- -- 6 - Msdb was moved, dbmail is on, make sure broker is enabled. -- SELECT is_broker_enabled FROM sys.databases WHERE name = N'msdb';