Sage Construction & Real Estate

I am trying to determine the best possible backup solutions for Sage 300 CRE. Is it possible to restore single Sage files from a Microsoft Shadow Copy? If so, what is the correct way to do that without disrupting the database? Is it possible to…

I cannot find specific instructions to move OLD databases to a location where they can be safely stored without the required updating of the database when a new update arrives. I have databases going back to 2012 and it takes way too long to upgrade them…

Is there a way to recover a deleted change order?

We create a copy of the current year database every year so we're able to have access to GL information older than two years, if needed. I would like to archieve some of the old databases so the system will run faster. Has anyone had any experience with…

I want to make a copy of my Sage 100 DB so we can start user acceptance testing. When I copied my LIVE database that contains financials and job, etc, my copy doesn't have any financials. It's like the copy function only selected certain tables (vendor…

I'm not able to create full image backup of my sage machine, so I'm planning on recreating it in another server. The issue being, when I open up System Administrator and I click my company folder, it says, "You have not selected all of your company folders…

Manually performing a company backup works fine but the scheduled backup does not backup the CompanyData folder. Is this a permissions issue as the scheduled backup is running the scheduled task as SYSTEM?

Hello! Is there any way to inactivate terminated employees or get them to stop pulling into reports- same question applies to closing jobs? Currently we are archiving terminated employees (and jobs) to a separate data folder as they will pull into reports…

So I am trying to switch over to using System Administrator to do the backups (we just started using SQL Replicator) and the first back up failed because someone left Sage open at their desktop and I got an error about Master.qlm being open. This will…

I mistakenly upgraded all of my files from 9.8 to 13.1. In the process, a number of files could not be "renamed" and thus did not upgrade. I am unable to access job cost records and unable to process payments in Accounts Payable. The File Doctor report…

I would like to remove some of the archived data companies in SQL. When ever I upgrade or update the product, I have to update the older Archived databases. Is there a method for removing those companies and storing? I may at some point in the future…

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

So, I have been experimenting with Backup-Restore functions of the SQL databases. I was able to restore backup files from my primary workstation with its own SQL Instance to the emergency workstation with its own Instance of SQL Server. It went well enough…

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

Restoring from a System Administrator backup file from two days ago, using the System Administrator restore function, but as soon as the file is chosen, it kicks to a non-responsive state. I have let it run at least 5 hours and can't tell if anything…

I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…

Hello my system is running very slow and it seems things aren't posting very quickly-especially in AR. Someone stated that I needed to Archive my old data. Would someone know how to help me through this? Thank you.

Sage 100 Contractor nightly back up has failed every night since we did our archive of prior year general ledger. How do find out what the problem is so that we can get the backups performing successfully again?

I am curious if anyone else is having issues with the Automatic Backup Feature failing in the System Administrator. I can backup manually just fine, but the auto backup gives me this error: 2018-12-25 20:00:00 Starting backup 2018-12-25 20:00:15 Folder…

Every time I open Sage Contractor 100 (version 21.3.39.0) I get an error saying that the Sage file did not backup. Though when i check the backup schedule it is set to backup every night. And i can see the backup files in the backup folder. Is this…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

Sitting down to do all the year end stuff and I updated sage and upgraded my databases before closing the payroll year. Will this mess me up? What if anything should I do?

Can I delete printouts? Will this effect anything or cause loss of data? Is this a data file or simply an entry report for printing?

I'm running Sage 300 Construction and Real Eestate version 18 without SQL and tried to do a restore to eliminate an accounting error and received this 2018-08-15 14:36:46 Using backup file E:\backup180815_125258.zip 2018-08-15 14:36:46 Restoring global…

Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…