{"id":10636,"date":"2015-04-27T07:19:19","date_gmt":"2015-04-27T07:19:19","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=10636"},"modified":"2019-11-12T09:05:10","modified_gmt":"2019-11-12T09:05:10","slug":"restore-your-company-database-backup-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/","title":{"rendered":"Restoring your Sage 300 ERP Company Database Backup"},"content":{"rendered":"

Database is one of the most crucial things that every organization relies on. There are many reasons, why one needs to restore a backup.
\nIn our last blog we discussed about Backup your Company Database in Sage 300 ERP<\/a>. In this blog, we would discuss about the steps to restore a backup in Sage 300 ERP.
\nSage 300 ERP allows users to take database backup using database dump. Similarly it allows users to restore a data using database load. Following are the steps needed to be followed while restoring data.
\nThe New Stuff:<\/em><\/strong><\/span> <\/em>Data Activation Error in Sage 300 ERP<\/em><\/a>
\nNote:<\/strong> To restore a data in Sage 300 ERP, Sage 300 user must have administrator rights.
\nHence, login to Sage 300 ERP with Admin\\Administrator user and follow below steps:
\n1. Navigate to Start menu >> Program Files >> Sage >> Sage 300 ERP >> Tools >> Database Load
\n\"1<\/a>
\n 
\n2.<\/strong> Enter admin\u2019s password and click on OK button
\n\"2<\/a>
\n3.<\/strong>Once user clicks on OK, list of previously backed up databases will be displayed.
\n 
\n\"3<\/a>
\n4.<\/strong>Click on Set Directory option and browse to the directory where the data to be restored is saved.
\n\"4<\/a>
\n\"5<\/a>
\n5. <\/strong>After you get the desired data, select the system file of your data set and click on Next option. In the below case  it is SDCSYS.DCT<\/strong>
\n <\/strong>
\n\"6<\/a>
\n6<\/strong>. A list of already created databases will be displayed . Select the database in which you want to load your data set and click on Next.
\n\"7<\/a><\/strong>
\n 
\n7<\/strong>. Now click on Finish to start loading your data set’s system file in the system file of the above selected database.
\n\"8<\/a>
\n8 <\/strong>.If your database already has some data set loaded into it, you will be asked the below question. Click on OK to go ahead.
\n 
\n 
\n\"9<\/a>
\n9 <\/strong>. After successful restoration of the system file, the below screen appears. Click on Next to go ahead and load the Company file.
\n 
\n\"10<\/a>
\n10 <\/strong>.  After clicking on Next the below screen appears. Now , select the company file to load the company data and click on Next. In the below case the company file is SDCCOM.DCT<\/strong>
\n\"11<\/a>
\n11<\/strong>. Select the database’s company file into which you want to load your data set’s company file and click on Next.
\n 
\n\"12<\/a>
\n12<\/strong>.  Click Finish to start loading your Company file in the the database.
\n 
\n\"13<\/a>
\n13<\/strong>. Again click on OK to continue.
\n\"14<\/a>
\n14. <\/strong>After the company file has been restored successfully, click on Cancel button to exit.
\n 
\n\"15<\/a>
\n 
\n14. <\/strong>Go to Sage 300 ERP and open the database in which you loaded your data set, you will get the above restored data
\n 
\n\"16<\/a>
\nAlso Read:<\/strong>
\n <\/strong>
\n1)      Migrate Sales Order from Sage 50 (US) to Sage 300 ERP<\/a>
\n2)      Migrate Sales Person from Sage 50 (CAD) to Sage 300 ERP<\/a>
\n3)      Migrate Items from Sage 50 (CAD) to Sage 300 ERP<\/a>
\n4)      Migrate GL Accounts Transactions from Sage 50 US to Sage 300 ERP<\/a>
\n5)     Migrate Purchase Orders from Sage 50 (US) to Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Database is one of the most crucial things that every organization relies on. There are many reasons, why one needs to restore a backup. In our last blog we discussed about Backup your Company Database in Sage 300 ERP. In this blog, we would discuss about the steps to restore a backup in Sage 300 ERP.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[79,700,2357,2513],"class_list":["post-10636","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac","tag-data-migration","tag-sage-300-erp","tag-sage-pro-erp"],"yoast_head":"\nRestoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Database is one of the most crucial things that every organization relies on. There are many reasons, why one needs to restore a backup. In our last blog we discussed about Backup your Company Database in Sage 300 ERP. In this blog, we would discuss about the steps to restore a backup in Sage 300 ERP.\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-27T07:19:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T09:05:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/\",\"name\":\"Restoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg\",\"datePublished\":\"2015-04-27T07:19:19+00:00\",\"dateModified\":\"2019-11-12T09:05:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Restoring your Sage 300 ERP Company Database Backup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Restoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Database is one of the most crucial things that every organization relies on. There are many reasons, why one needs to restore a backup. In our last blog we discussed about Backup your Company Database in Sage 300 ERP. In this blog, we would discuss about the steps to restore a backup in Sage 300 ERP.\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-04-27T07:19:19+00:00","article_modified_time":"2019-11-12T09:05:10+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/","name":"Restoring your Sage 300 ERP Company Database Backup - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg","datePublished":"2015-04-27T07:19:19+00:00","dateModified":"2019-11-12T09:05:10+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/1-pic.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/27\/restore-your-company-database-backup-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Restoring your Sage 300 ERP Company Database Backup"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=10636"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10636\/revisions"}],"predecessor-version":[{"id":27337,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10636\/revisions\/27337"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=10636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=10636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=10636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}