Solved

Folder Replication

Posted on 2016-09-23
4
63 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 39

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 57

Accepted Solution

by:
Cliff Galiher earned 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

786 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