{"id":5489,"date":"2013-11-12T14:18:00","date_gmt":"2013-11-12T14:18:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=5489"},"modified":"2013-11-12T14:18:00","modified_gmt":"2013-11-12T14:18:00","slug":"how-to-identify-and-backup-correct-sage-crm-database","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/","title":{"rendered":"How to identify and backup correct Sage CRM Database"},"content":{"rendered":"

Here is what we would not call a great task from programmer\u2019s point of view. However when it comes to non-programmers and you have quite a few versions of CRM on server it is difficult for them to understand the correct database for backup. Here is a quick look guide for such people on what to do in this situation.
\nRelated Post:\u00a0<\/b><\/span><\/em>Steps to be remembered while moving Sage CRM database from one server to another<\/a>
\nPrerequisites:
\n<\/b>1) Sage CRM admin user password.
\n2) Microsoft SQL Server Username and Password where Sage CRM database is loaded.
\nTo do the database maintenance, one should know correct database attached to Sage CRM instance. In order to check the same, login to Sage CRM using administrator credentials and go to Administration<\/b> | System<\/b> | Database<\/b>.
\n\"DB-1\"<\/a>
\nNow Note down below items
\n<\/b>1) Default Database<\/b>: This is Sage CRM database name.
\n2) Default Database Server<\/b>: Name of SQL server where Sage CRM database is maintained.
\n3) Database User ID<\/b>: This is Username of SQL Server.
\n4) Database Password<\/b>: This is the password of SQL Server which is an encrypted format. You should know the same so that we can connect to SQL server.
\nNow to take backup open follow below steps
\n<\/b>In order to take Sage CRM database backup, you need to start SQL server and connect using username and password (mentioned in point 3).
\n1) Now, Right click on Sage CRM database and select Tasks | Back Up option.
\n\"DB-2\"
\n<\/a>2) You will get a screen to select the physical path of drive. Select Disk option and click on Add button to select Backup Destination.
\n\"DB-3\"
\n<\/a>3) Select Browse button to select drive path and click on OK<\/b> button.
\n\"DB-4\"
\n<\/a>4) Below screen will appear. Again click on OK button.
\n\"DB-5\"
\n<\/a>5) Again click on the OK button of main window to start the database backup.
\n6) Once done, you will get a confirmation message that database backup is completed successfully.
\n\"DB-6\"<\/a>
\nIt is very important to do Sage CRM database back-up regularly. If you are loading any new customizations on CRM system or if you are performing upgrades, you need to ensure that complete database back-up is taken so that you can revert back again in case if there are any unexpected error occurs.
\nAlso Read:
\n<\/strong><\/span>1)\u00a0How to access views of Different Database in CRM
\n<\/a>2)\u00a0Cannot open database requested by the login. The login failed.
\n<\/a>3)\u00a0OSQL error at the time of installing CRM
\n<\/a>4)\u00a0Quick look on Sage CRM tables
\n<\/a>5)\u00a0External database connectivity<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Here is what we would not call a great task from programmer\u2019s point of view. However when it comes to non-programmers and you have quite a few versions of CRM on server it is difficult for them to understand the correct database for backup. Here is a quick look guide for such people on what\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,102,179,332],"tags":[],"class_list":["post-5489","post","type-post","status-publish","format-standard","hentry","category-backup","category-database-sage-crm","category-identify","category-sage-crm"],"yoast_head":"\nHow to identify and backup correct Sage CRM Database - Sage CRM \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\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to identify and backup correct Sage CRM Database - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Here is what we would not call a great task from programmer\u2019s point of view. However when it comes to non-programmers and you have quite a few versions of CRM on server it is difficult for them to understand the correct database for backup. Here is a quick look guide for such people on what\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-12T14:18:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/\",\"name\":\"How to identify and backup correct Sage CRM Database - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg\",\"datePublished\":\"2013-11-12T14:18:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to identify and backup correct Sage CRM Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to identify and backup correct Sage CRM Database - Sage CRM \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\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/","og_locale":"en_US","og_type":"article","og_title":"How to identify and backup correct Sage CRM Database - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Here is what we would not call a great task from programmer\u2019s point of view. However when it comes to non-programmers and you have quite a few versions of CRM on server it is difficult for them to understand the correct database for backup. Here is a quick look guide for such people on what\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-11-12T14:18:00+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/","name":"How to identify and backup correct Sage CRM Database - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg","datePublished":"2013-11-12T14:18:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/11\/DB-11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/11\/12\/how-to-identify-and-backup-correct-sage-crm-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"How to identify and backup correct Sage CRM Database"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=5489"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5489\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=5489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=5489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=5489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}