Browse By Tags

I've just started supporting a Sage FAS Network install, and am working out how to make cold backups. When I go to the backup utility, I find that we have 20-ish databases, each with only one company. Did my predecessor set things up weird, or is there…

Hello, Mistakenly updated Sage 100 Contractor to the wrong update version without the payroll year closed. I rolled back the program on the computers which is fine. It now states the tax table for this year. Do I need to roll back on the server…

Hi all, During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot. Can anyone help me please? Thank you.

Client uses Sage 300 2014 & SQL 2012, on separate servers. They have provided 2 new 2019 servers for us to begin the upgrade -- but first, I want to make sure that everything works as it does now, before installing version 2022. The DBA restored the SQL…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

Hello, Long story short I am purging closed clients and it's going unbelievably slowly. I am trying to purge the database from everything from our closed clients. When I run the purge, I select "Closed" clients and nothing else, no other filters…

I accidentally created multiple new databases based on our existing database. I have deleted the .FDB files but the deleted databases still show up in the dialog box when I select "File>Open Database." How can I delete them from showing up in the…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.

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…

Hi, While i'm creating a record due to some issue i lost the data in table maintenance ,can any one help me out to get lost data?

Hello Sagers, I was trying to connect Sage x3 to a virtual database ( always on ) and this virtual SQL database is pointing to two other Physical SQL database instances this to have online hot swappable database recovery. But the console is not seeing…

MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…