I am installing a new SQL 2008 R2 cluster and have a question about multiple instances and drives. I carved out several volumes on my SAN (TempDB-DATA, TempDB-LOG, DB1, LOGS, DTC, Quorum, etc...) which translate to mountpoints and now am ready to install another instance (doing a Lync install and Sharepoint later on).
So my question is, do I need to create another 6 or more volumes for the new instance? I was thinking I could just add another volume/mountpoint for another database (say DB2) and my log could reside on the existing LOG mountpoint in another sub-directory... but I don't know about the TempDB stuff or if I need to address anything on the DTC either. Please help.
Thanks.
So my question is, do I need to create another 6 or more volumes for the new instance? I was thinking I could just add another volume/mountpoint for another database (say DB2) and my log could reside on the existing LOG mountpoint in another sub-directory... but I don't know about the TempDB stuff or if I need to address anything on the DTC either. Please help.
Thanks.