• Hmm, I'm a little confused...

    I assumed the question was talking about files from any arbitrary database - but the "ALTER DATABASE ... MODIFY FILE" clause can only (if I understand correctly) be used to move tempdb files, not arbitrary files (not only that, but it also requires a server restart, which is not mentioned).

    If this tempdb-limited answer is valid, then the startup with "-D" for moving master databases should also be valid, right?

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.