Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Data files and log files on seperate servers

Author  Topic 

jhappy
Starting Member

3 Posts

Posted - 2006-04-25 : 13:44:06
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?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-25 : 13:50:59
That isn't true. What's true is splitting the files onto separate drives. So they would still be on the same server. Besides, what you described isn't possible anyway.

Tara Kizer
aka tduggan
Go to Top of Page

jhappy
Starting Member

3 Posts

Posted - 2006-04-25 : 14:16:43
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.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-04-25 : 14:19:35
Damn duplicates [:-(]

I answered over at: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65189
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-25 : 14:42:07
jhappy, yes it is impossible to configure the databases that way. We put the mdfs on one drive and the ldfs on a different drive. Kristen provides the RAID information in the other thread.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -