I read that under very heavy traffic, very heavy database useage situations, it is best to put your SQL Server 2005 log files on one Windows 2003 server and your data files on another. My question is ... does SQL Server 2005 need to be installed on both servers? Perhaps it could be installed on one but it would be best to have it installed on both?
Thanks for responding. I want to make sure I understand you. Are you saying that it is impossible to successfully configure a SQL Server database so that the log files work on one server and the data files work on another. Perhaps I misunderstood what I have been reading. You suggest that the transaction speed is gained by putting them on seperate disks (disk arrays with RAID 10) on the same machine.