• Not that I care, but it is one confusing question & answer

    I have actually done this, and this is my SQL script for all-system-DB's-except-master and they did work, no trace flags used

    --http://msdn2.microsoft.com/en-us/library/ms345408.aspx

    -- STEP 1Run and STOP SQL Server

    -- model

    ALTER DATABASE model MODIFY FILE ( NAME = modeldev, FILENAME = 'X:\SQLDATA\model.mdf')

    ALTER DATABASE model MODIFY FILE ( NAME = modellog, FILENAME = 'Y:\SQLLOGS\modellog.ldf')

    -- msdb

    ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData, FILENAME = 'X:\SQLDATA\msdbdata.mdf')

    ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog, FILENAME = 'Y:\SQLLOGS\msdblog.ldf')

    --tempdb

    --USE master

    ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'X:\SQLDATA\tempdb.mdf')

    ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'Y:\SQLLOGS\templog.ldf')

    -- STEP 2COPY physical files

    -- STEP 3Start SQL Server

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005