• Standards are important, mainly to make things easy to find. We've got 60+ SQL Servers, 30 of which I manage. We have a standard hardware setup, 3 physical arrays min for all db servers. So we have

    c: - OS and SQL

    z: - SQL data and backups

    y: - SQL Logs

    arguably it should be different, but it works. We then have \mssql\data for all mdf files, \mssql\logs for ldfs, and \mssql\backup for backups with a sub for each db. \mssql\logs holds the logs and maint reports.

    This is an easy way that ensures that we know where everything is. Need a report? map to \\servername\z$\mssql\logs and I've got reports. Easy to manage and find things.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net