Vlad-207446 (6/10/2013)
I don't get it.
Read my article it will expalin in more detail.
Vlad-207446 (6/10/2013)
stop the db, detach files , move them and attach them back work as well?
that is what MS recomends after all
http://support.microsoft.com/kb/224071%5B/quote%5D
You can't always just detach the database, it may be replicated for instance. This article details moving the files via the ALTER DATABASE command is the supported route from Microsoft.
You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you had to detach a user db to move it as the alter database command was only valid for tempdb files
My article provides a lot more detail behind all this.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉