• Manie Verster (6/10/2013)


    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

    Perry, I don't know why you say this is an ancient article because after having had a look at it again I saw SQL Server 2012 at the top of the page??????:hehe::hehe:[/QUOTE]

    Since you feel the need to mock, it might pay you to read properly the article links

    The link here details this!!

    Microsoft KB


    Article ID: 224071 - Last Review: July 16, 2012 - Revision: 19.0

    Applies to

    •Microsoft SQL Server 2005 Standard Edition

    •Microsoft SQL Server 2005 Enterprise Edition

    •Microsoft SQL Server 2005 Developer Edition

    •Microsoft SQL Server 2005 Workgroup Edition

    •Microsoft SQL Server 2005 Express Edition

    •Microsoft SQL Server 2000 Standard Edition

    •Microsoft SQL Server 7.0 Standard Edition

    Keywords: kbsqlsetup kbinfo KB224071

    Manie Verster (6/10/2013)


    I would, however, like to know what is actually the best to do. Move or detach an attach taking in consideration that there is no replication on the database to be moved?

    If you bother to read my article[/url] instead of mocking you'll see that ALTER DATABASE is the supported option. In SQL Server 7.0 and 2000 you had to detach as ALTER DATABASE did not support user databases!!

    This is the correct KB article from Microsoft.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉