• Joshua Perry (3/21/2008)


    Still wrong. That's the procedure for moving between servers. This is the procedure for moving the location:

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

    Also, setting trace flag 3608 at startup and running in single user mode are the same thing, so two of the answers are identical.

    If you move the master, the mssqlsystemresource has to reside in the same location ... doesn't matter if you're moving servers or to a new drive.