• Vlad-207446 (6/10/2013)


    I don't get it.

    Read my article it will expalin in more detail.

    Vlad-207446 (6/10/2013)


    but if you have to physicaly move the files your self anyway, than wouldn't just

    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" 😉