I would like to know if its good practice to put the distribution DB files under same drive as that of the master, msdb, tempdb files or have it in the user database drive, both configs are RAID 10 but on seperate physical LUNS.
If it should be on same drive as the master database, my replication is setup dynamically and I was wondering how I can get the folder where the master DB is located in, I know I can query sysaltfiles for this, but it needs to be the folder where the master
DB file is located.
Any ideas ?
View Complete Post