I am wondering whether it is a good idea to separate the database installation media from the actual data files.
In our current environment we have:
- C: - Windows Server
- D: - MS SQL Installation & DB Data Files
- E: - Backups
- L: - Log files
Would it be a good idea to separate out our D:
- Drive 1: MS SQL installation
- Drive 2: DB Data Files
There are similar questions already posted, but nothing specifically relating to the separation of DB software and DB data files. (similar questions ask whether it is a good idea to separate OS and DB).