Can MDF/LDF live on another machine?

[bperry]

Can the physical database files be on another machine (on the network) other than where SQL Server is installed?

 

[essa2000]

I think , No !

 

[williamu]

Yes and that is of course the ideal way to do it.

William
Software Engineer
ICQ No. 56047340

 

[williamu]

What I meant was that ideally the MDF and LDF files should be on individual hard drives as well. As for my original (possibly hasty) statement err well...)

In Oracle the ideal disk plan involves 27 hard disks if I recall correctly.
William
Software Engineer
ICQ No. 56047340

 

[tlbroadbent]

SQL Server doesn't allow database or log files to reside on anaother server. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Guest_imported]

Hi Terry,
what do you mean "SQL Server doesn't allow database or log files to reside on anaother server"?

 

[tlbroadbent]

SQL 2000 BOL states, "The path in os_file_name must specify a directory on an instance of SQL Server."

SQL 7 BOL states, "The path in os_file_name must specify a directory on the server in which SQL Server is installed."

This indicates that the data and logs must be on local drives. However, I've just read a FAQ by Neil Pike and a knowledgebase article that indicates that you can create databases on Netork drives. However, this is not recommended primarily because data integrity can be compromised and performance will be poor.

See the following links.

SQL FAQ: Can I create SQL Server databases on network drives?

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14285

MS Knowledgebase: INF: Support for Network Database Files

http://www.microsoft.com/technet/support/kb.asp?ID=304261

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.