--- title: How to Back Up Your Sage 300 ERP Database description: Step-by-step instructions for performing a Database Dump and backup in Sage 300 ERP. --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # How to Back Up Your Sage 300 ERP Database **twitter **linkedin **facebook There are a number of reasons to backup a database. Perhaps you need to "Create New Year" in the general ledger, upgrade to a newer version of [Sage 300 ERP](https://www.equationtech.us/sage_erp_accpac/) (Accpac), or maybe you want to load your database onto a test company.  Whatever the reason, this post offers a bit of guidance and instruction.  You will need to have the Admin password to Sage 300 in order to accomplish this goal.  1.    Go to your Start Menu > Program Files > Sage 300 > Tools > Database Dump ![Sage 300 ERP - Database Dump](https://www.equationtech.us/hs-fs/file-14052929-jpg/images/eqt_-_database_dump_1.jpg)                           2.   Enter the Sage 300 Admin Password   ![Sage 300 ERP - Database Dump 2](https://www.equationtech.us/hs-fs/file-14053331-jpg/images/eqt_database_dump_2.jpg)   3.   Select the Database you'd like to dump and click on "Set Directory" ![Sage 300 ERP - Database Dump 3](https://www.equationtech.us/hs-fs/file-14052956-jpg/images/eqt_-_database_dump_3.jpg)   4.   Browse to where you want your DB (Database) Dump to be stored.   **Note:**  If you store it in the same location as an existing DB Dump, you will override the previous data. Depending on the space available and your needs, consider making a new folder to put the DB Dump and name the folder so that it is easily identifiable as to the why & when of the DB Dump.   Click Ok > Dump to Begin. ![Sage 300 ERP - Database Dump 4](https://www.equationtech.us/hs-fs/file-14052985-jpg/images/eqt_-_database_dump_4.jpg)   ![Sage 300 ERP - Database Dump 5](https://www.equationtech.us/hs-fs/file-14053017-jpg/images/eqt_-_database_dump_5.jpg)   5.   If your DB Dump has any errors, there is a high probability that your data has been corrupted (perhaps after a server crash).  Contact your Sage partner representative immediately to see if data recovery is possible.  If you aren't working with a Sage partner, please feel free to contact us for [Sage 300 Support](https://www.equationtech.us/support/).   6.   Keep in mind that your DB Dump may take a while to process depending on the size of your Database and the hardware you are using.  You can just let the database run in the background and continue working as normal.   7.   When the DB Dump is complete, you will see the following box.  Enter a description if you like and click Done.   ![Sage 300 ERP - Database Dump 6](https://www.equationtech.us/hs-fs/file-14053057-jpg/images/eqt_-_database_dump_6.jpg)   8.   When you look in the folder that you pushed the database dump to, you will see a DCT file and a folder.  These 2 items must be kept together as they are in order to perform a DB Load from the DB Dump.   Performing a Database Dump is only one of the ways to backup your database.  The other way is through a SQL backup, but that would need to be done by your IT personnel as the tables are too sensitive for most access.   This is a way that anyone in your organization (who has Admin rights) may make sure that they have a backup of their data when necessary.   No matter what, please ensure that you do have a process in place to take regular backups (whether by DBDump or by a SQL Backup).  ## Need Help? [Contact](https://www.equationtech.us/contact/) the Sage 300 experts at Equation Technologies if you need Sage 300 support, training, or any other guidance. ### Related Articles ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ##### [How to Simplify Payroll and Job Costing with Sage 300](https://www.equationtech.us/sage-accpac-blog/how-to-simplify-payroll-and-job-costing-with-sage-300) Getting payroll to play nice with your job costing system is like fitting a square peg into a round... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "Mark Badran" }, "dateModified" : "Wed, Oct 17, 2012", "datePublished" : "Wed, Oct 17, 2012", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "How to Back Up Your Sage 300 ERP Database", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/bid/90267/how-to-back-up-your-sage-300-erp-database", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```