SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Data files and log files on seperate servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jhappy
Starting Member

3 Posts

Posted - 04/25/2006 :  13:44:06  Show Profile  Reply with Quote
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

USA
37132 Posts

Posted - 04/25/2006 :  13:50:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 04/25/2006 :  14:16:43  Show Profile  Reply with Quote
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

United Kingdom
22415 Posts

Posted - 04/25/2006 :  14:19:35  Show Profile  Reply with Quote
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

USA
37132 Posts

Posted - 04/25/2006 :  14:42:07  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000