• EdVassie (1/14/2014)


    IMHO moving a system database on a test server can be a useful part of educating yourself in how SQL Server works, what can break, and what needs to be done to fix it.

    Moving a system database on a production server is not necessary, adds risk to your installation, and takes time away from doing productive tasks.

    Just IMHO, not cast in stone...

    It isn't necessary until it is 😉

    I've had to move tempdb due to space issues (for example, on a production server where the drive space for tempdb wasn't allocated large enough) and it's a good idea to at least know how to move them, just in case.

    The instructions here work like a charm: