Two BE, one with data and the other to save the data

[Mylton]

Good afternoon

I would like to clarify a doubt.
If I have an App with BE and FE.
Where the tables are in BE.
However, the information takes up space in this BE.
I thought about saving in another BE, calling it BE2.
The connection is not difficult.
The question would be two:
1) how to protect the system?


2) madness? Or valid? What opinion?

Thanks.

[orange]

Mylton,

a)What exactly is your concern?
b)What exactly is the purpose and content of BE2?

c)Have you considered a BACKUP STRATEGY ---daily/weekly/monthly... or some (automated) frequency?

[June7]

You have hit 2GB limit in backend? Even after Compact & Repair?

SQLServer Express has 10GB limit and is free.

MySQL (an Oracle product) is also free and might allow larger file size.

I was able to setup SQLServer Express but failed with MySQL.

[Bulzie]

That will be a nightmare to make sure you have the new records saved to BE2. Plus what happens when both get filled up, you create a BE3? As other said, best to get SQL if you can. Also what is causing the data to fill up fast? If you are saving images, you can save those in a network folder and just have a link to them, etc.