• EdVassie (7/30/2013)


    Separating the data and log files are a company policy

    Once upon a time this policy did not exist. Then it got created.

    You need another company policy that says 'Leave the data and log files of SQL Server system databases master, model, resource where they are put by the install process'.

    +1

    I would go further, the default location as part of the install is C:\program files\.... that is rarely the best place for your system databases so designate a drive for them and the policy would be 'system database files are placed on drivedirectory (your choice here) as part of the install process and never shall they be moved.'

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