SQLDBA360 (2/11/2013)
Nice artical, I must admit i'm still a fan of detatching the databases to move files
No longer necessary to detach the database. The ALTER DATABASE ... MODIFY FILE command is the preferred way to perform these actions.
SQLDBA360 (2/11/2013)
(plus i'm prone to the odd typ0).
Type slower and always check your work 😉
SQLDBA360 (2/11/2013)
One other thing, prob obvious to most readers, is that you can't do this method if your moiving the master or resource databases MS has an artical on this at http://msdn.microsoft.com/en-us/library/ms345408%28v=sql.90%29.aspx this one is for 2005 but the other versions are available using the other version drop down.
In the article I make references to user databases only 😉
However, i appreciate your point and could have made it clearer.
Note also that for the resource database you do still need to issue an
ALTER DATABASE ... MODIFY FILE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉