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