Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Folder Replication

Posted on 2016-09-23
4
Medium Priority
?
117 Views
Last Modified: 2016-09-29
There is a back-end server that has a folder with database files. Can anyone recommend a real-time replication on the folder level? I believe the database is flat and proprietary.
0
Comment
Question by:exhuser
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 41813079
"back-end server that has a folder with database files" - what database server is that - SQL Server?
0
 

Author Comment

by:exhuser
ID: 41813184
No, I believe it is a "flat" custom-built database.
0
 
LVL 7

Expert Comment

by:Mohamed Khairy
ID: 41813190
0
 
LVL 59

Accepted Solution

by:
Cliff Galiher earned 2000 total points
ID: 41813194
I *never* recommend using folder-based replication on database files. Even "flat" (whatever that means to you) requires special handling.  Technically dBase from back in the day was just file-based. As was early implementations of the Jet engine (think Microsoft Access)  ...and yet copying them without being application aware still caused corruption. But dBase and Access support transactions, and you can copy a file mid-transaction and all hell breaks loose.

You really need to work with the database vendor to make sure you get this done right. Otherwise that "copy" is as worthless as a piece of coal in a field of diamonds.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
What we learned in Webroot's webinar on multi-vector protection.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question