Allocate database file away from MS SQL application Server

My boss is asking me this question. Can we separate the MS SQL application and the database file into 2 servers? Means, 1 server is hosting the MS SQL Server application, and another one is store the individual database log file and other related files.

Can it be done? how? I have totally no idea!!! Please help
LVL 1
cwteohAsked:
Who is Participating?
 
ram2098Commented:
You mean, you want to setup SQL Server on one machine and put database files on another machine. If yes, you cannot do that.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the application connecting to the sql server database can be on other servers.
this includes the sql server manager, query analyser (sql 2000) resp . the sql server management studio (sql server 2005)

the sql server engine, the databases and hence the database files need to be on 1 server.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>You mean, you want to setup SQL Server on one machine and put database files on another machine. If yes, you cannot do that.
actually, you can (with a specific startup option), but it's highly disrecommended...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
Scott PletcherSenior DBACommented:
SAN drives would be a better option, if available.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I would like to point out that the accepted answer is wrong (as I posted in my second comment):
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

but as already pointed out, this procedure is not recommended at all...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.