asked on

DFS - Is it OK to host MYOB files (flat database files) on SBS2003 DFS?

Hi Experts..

Is it OK to host Database files on SBS2003 DFS?

I am planning a DFS implementation for a client.

Currently they have a SBS2003 domain. I am planning to add an extra "MS 2003 Standard R2" File Server to host new DFS root and replicate it to the SBS2003 DC.

The company uses several accounting databases such as MYOB and Locus (flat file databases openned by muliple clients via a mapped drive).

Is it safe to store these database files in the DFS folder structure?.

Will DFS be able to replicate these database files if open by multiple clients?

Many thanks
best
Wilson
Sydney Australia

Jeffrey Kane - TechSoEasy

I don't know this for sure, but I wouldn't think you could put any kind of Database file in a DFS folder. For the same reason you can't store a mdb file in an off-line cached file.

Databases, by their nature, require there to be a single point of synchronization, controlled by the database itself.

Jeff
TechSoEasy

wilsonkjit

ASKER

Thanks for your reply Jeff.
Glad I checked in advance
So are DFS roots only good for basic office files like .xls .doc .jpg ??

If I have an xls file open on the Sydney server DFS and someone tries to edit the same file in Singapore.. does he get a "File in use, notifiy Warning" as you would do on a normal share?

thanks again/...
Wilson

ASKER CERTIFIED SOLUTION

Jeffrey Kane - TechSoEasy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wilsonkjit

ASKER

Thanks again..
yep I agree thinking about it.. Sharepoint will match the environment well.. Thanks again.
Wilson..