• Steve Jones - Editor (3/21/2008)


    I'll reword and change it around.

    Hi Steve,

    I hope everything went allright with the kid's tooth 🙂

    I have to agree with Joshua Perry on the new version of the question. All answer possibilities involve detaching and attaching - and whereas it IS possible to move a system database in that way, and I did indeed post a link to an MSKB article describing some gotchas with that approach, there is a far easier way documented in Books Online:

    1) ALTER DATABASE to modify the files for msdb;

    2) Shutdown the server;

    3) Physically move the database files;

    4) Restart the server;

    5) Check that all has gone right.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/