Swindows Server 2012 DFS and Access Databases

He have a environment of 2 virtual DC's that also have our network shares on these machines the setup is DFS so if one goes down the other will be up, but we have been experiencing so data issues with access databases.  Not sure how but have conflicts and when one file is chosen from the conflicts data from the second files is not carried over to the final choice and lost ,Any Ideas?

Thanks
cameljoe121Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob StoneCommented:
If the access files are open then you can experience replication issues:
http://technet.microsoft.com/en-us/library/cc773238%28v=ws.10%29.aspx#BKMK_050
0
cameljoe121Author Commented:
Your correct when seems to be the issue is that I have 2 Dc's that are VM's on different physical hosts.  Both Dc1 and Dc2 have a copy of our DFS shares on them.  They system was set up by a consultant, the idea was that any user could connect to which ever DC was up and access information from the share when the other DC was down for maintenance or had a Failure.  It appears that some of the end clients are connecting to DC1 and some to DC2 I thought we wanted to be one or the other, but since both house these access databases data is being lost for them being open on both servers at the same time when DFS goes to replicate to data its deleting info it should not any ideas
0
Rob StoneCommented:
If you want High Availability on the Access files then you will need to configure a failover cluster. You'll need some shared storage between the nodes (like a SAN) for this.  However, as these are your DC's too it's not something that is recommended.  

I would look to either move the Access files out of DFS or remove the replication on the Access folder in DFS (and remove the target against the secondary DFS server) and put a scheduled task to mirror the contents on DC1 to DC2 every 'x' minutes/hours.

Robocopy or Richcopy can do this, but practice with some test files/folders first! The mirror switch used in the wrong direction will have bad consequences.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.