Sage Construction & Real Estate

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…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

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…

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…

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…

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?

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

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…

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…

Is there a way to retrieve data if server that Sage (Timberlime) was on was hit with Ransomware?

Somehow our Current.prt file was deleted and a new one was created when we processed a payroll on January 10, 2018. Now the Current.prt file contains only the data from that payroll. We use the File Tools>Copy function to back up our transaction and master…

Hello Helpies there, I have sage 100 contractor and there are 15 total companies in it. Out of these 15 only 3 are setup for nightly backup. I am not able to find out way to add remaining 12 to backup. Can some one please help. TIA. Raj…

I am hoping to find a way to safely log users out of Sage in order to prepare my server for daily backups. Everything I have read so far seems to depend on the users taking the initiative to log out of their applications at the end of the day, and then…

I am hoping to find a way to safely log users out of Sage in order to prepare my server for daily backups. Everything I have read so far seems to depend on the users taking the initiative to log out of their applications at the end of the day, and then…

My log viewer file has grown quite enormous over the years. I can see that it is possible to archive it to an xml file but I cannot seem to find a way to delete the archived entries. Any help would be appreciated.