Tao Klerks (7/2/2008)
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?
that was a sql 2000 restriction, alter databases can be used for any file in 2005 (except resource database). which makes this a good, educational question. Looks like a good option to move replicated databases.
---------------------------------------------------------------------