Database Configuration

Before upgrading to EO 8.10 from XE we are going to be upgrading our infrastructure along with re-configuring our database structure. Currently we have a single business data production database with one database file associated with it (MS SQL 2000). Seeing that we have 5 companies running Financials off this one database file if something should happen to say company 1 (for example) company 2, 3, 4, and 5 will be down while we fix company 1’s database problem. To eliminate this single point of failure the thought is to have 1 JDE database but create separate MDF files for each company that way if company 1 goes down 2, 3, 4, and 5 can still work.

Is this a good idea to do? What impact will this have on financials? Do i have any other options?

Thanks in advance!

Dave

XE SP22 Win2K SQL 2000 Citrix XP FR3

We too use multiple companies and strictly use Enterprise One for Financials only. We are a life insurance company. Personally your plan does not make sense as all sub-ledger detail records are in one F0911 table and the summary records are in F0902. In the case of saying that company 1 is down I am assuming that everything is not balancing. If that is the case, either your F0911 or F0902 table is damaged therefore it potentialy affects every company. In most cases you can nail down the problem to a company or an account. If this is the case then you can work with other companys and\or accounts until you can fix the data. You can re-balance the F0902 by company, date, account or a combination. Most fixes get applied to F0911 and then the rebalancing is done. Sometimes it may be difficult to nail down the problem and you end up restoring from the previous night. Splitting this data into multiple data sources is just going to be a big headache.

Another thing, our company did not structure their Financials properly from the beginning and a looking at restructuring but this is a huge job. Someone else may provide some feedback on some of these details. I am a CNC.

You can not split the database tables based on company. MDF files hold individual tables. If you are worried about the Database going down just make sure you have use a server with lots of redundancy. If the database get corrupted having it split into many MDF files is not going to be a very big help thats what backups of the database are for.