• 2023 SQL Premium configuration & backups

    Hello friends, We have begun working with our awesome consultant on our Sage 2023 Premium upgrade from an older Providex version of MAS. It's very exciting! We are at the point now where we need to get backups running for our new accounting system…
  • Error Number 0x80040e14 Description ALTER DATABASE failed because a lock could not be placed on database

    This is a Go-Live upgrade, so obviously the test upgrade, and a subsequent "refresh migration" were able to go through. However, now that we are trying the final migration, with just the MAS_XXX company data (no system files) we are getting this - over…
  • Sage 100c Premium (SQL) Disaster Reocvery

    I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…
  • SQL mdf / ldf locations wrong after migration (v2020)

    I did a test migration last night (v2017 Premium to v2020 Premium, same server, both SQL instances are local), with the new instance's default data directory changed to the E-drive. When I installed v2020, the MAS_ABX and MAS_SYSTEM files were properly…
  • How to Replace the "Production" Company from a Backup Company Made Using the Company Maintenance Function

    I created a copy of our production company (DUS) into another company called (BKP). Now, I want to copy the BKP company data back to the DUS company data, effectively restoring from the backup I made. When attempting to go into Company Maintenance and…
  • Cannot copy Version 2019 data to another system?

    We do most of our custom development work for clients on our own system. (Build and test VI jobs, create and modify Crystal Reports develop custom forms, data troubleshooting, etc.) For the past 20+ years we simply copy the client data folder (MAS_xxx…
  • Purge Utility vs SQL Deletion: AR History

    Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…
  • Nightly backup failing

    FormerMember
    FormerMember
    The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.
  • Paperless Office Files and restoring to another server

    We are using Sage 100 Advanced V 5.20 OS Windows Server 2012 R2 We have a backup server where we have Sage 100 installed in case of disaster recovery. We copy the data files over daily. When I first migrated the data over all the Paperless Office…
  • Sage 100 ERP advanced Experence with VM's on a large Arrays systems.

    I have a client that leases VM's on a Network Operation Center. That NOC has high end hardware such as HPE 3PAR from HP large storage array for storing the VHD's. The NOC guys tell me the hardware array itself does bit level snap shots hourly which…
  • Sage100 Premium SQL Transaction Backups

    We just upgraded to Sage100 2016 Premium (yes BL, we are no longer on v 4.2). We are setting up SQL Backups and having issues with the SQL Transactional Backups. They are enormous in size and killing our drive space. Is there anyone that can help…
  • restore the part number and description headers?

    I deleted the parts number and descriptions, therefore when I try to enter an item into the estimate, only the "cost code, Cost type, Default cost....."headers appear. Is there a way to restore the part number and description headers?
  • clear history

    One of our employees cleared the history files from our order entry module. Is there anyway we can get that information back?
  • Accidentally Deleted Vendor

    I wanted to change a vendor name from "SMITH" TO "3SMITH" however I ended up deleting the original vendor name. How can I get this information back? What I did: Modules > AP > Utilities > Delete and Change Vendors. (I used the first tab instead of the…