{"id":267,"date":"2010-10-26T05:57:00","date_gmt":"2010-10-26T05:57:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=267"},"modified":"2010-10-26T05:57:00","modified_gmt":"2010-10-26T05:57:00","slug":"crm-database-daily-backup","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/","title":{"rendered":"CRM database daily backup"},"content":{"rendered":"

Backup task is something that is very much required to be done every day in order to maintain working system over the time and recover through potential system crashes. However scheduling the one is not a great task, but needs accuracy in execution<\/p>\n

Through my observations of the processes I would not recommend third party tools performing backup tasks as they don\u2019t work well for large database sometimes. Also taking the task away from SQL means inviting more security concerns to the data. SSIS package is one of the best ways to go for this task. You can design backup tasks and as the process runs on SQL server it saves time without hampering the security concerns. Another way to do this is through queries. I have noted down some steps below that you can add to SQL job and perform backup tasks seamlessly.<\/p>\n

These methods make use of xp_cmdshell <\/strong>command and hence they need to be enabled first in SQL. For that you can use below command.<\/p>\n

— To allow advanced options to be changed.<\/span>
EXEC<\/span> sp_configure<\/span> ‘show advanced options’<\/span>, 1
GO<\/span>
— To update the currently configured value for advanced options.<\/span>
RECONFIGURE<\/span>
— To enable the feature.<\/span>
EXEC<\/span> sp_configure<\/span> ‘xp_cmdshell’<\/span>, 1
GO<\/span>
— To update the currently configured value for this feature.<\/span><\/p>\n

RECONFIGURE<\/span>
GO<\/span><\/p>\n

Then you can create WINRAR compressed file for the backup file by running below mentioned commands<\/p>\n

— BACKUP<\/span>
BACKUP DATABASE<\/span> [DARS] TO DISK<\/span> = N’C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupCRM.BAK’ <\/span><\/p>\n

— GENERATE RAR FILE <\/span>
DECLARE<\/span> @SERVER VARCHAR<\/span> (100), @COMMAND VARCHAR<\/span> (100), @FILE VARCHAR<\/span>(100)
SET<\/span> @SERVER = @@SERVERNAME<\/span>
SET<\/span> @COMMAND = ‘”C:Program FilesWinRARRAR.exe” A “C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupCRM.BAK”‘<\/span>
EXEC<\/span> XP_CMDSHELL<\/span> @COMMAND<\/p>\n

— DELETE BACKUP FILE<\/span>
EXEC<\/span> XP_CMDSHELL<\/span> ‘DEL “C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupCRM.BAK”‘<\/span><\/p>\n

For queries regarding the functionality, please feel free to drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Backup task is something that is very much required to be done every day in order to maintain working system over the time and recover through potential system crashes. However scheduling the one is not a great task, but needs accuracy in execution Through my observations of the processes I would not recommend third party\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":[332],"tags":[606,921],"class_list":["post-267","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-backup","tag-database"],"yoast_head":"\nCRM database daily backup - 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\/2010\/10\/26\/crm-database-daily-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRM database daily backup - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Backup task is something that is very much required to be done every day in order to maintain working system over the time and recover through potential system crashes. However scheduling the one is not a great task, but needs accuracy in execution Through my observations of the processes I would not recommend third party\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-10-26T05:57:00+00:00\" \/>\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\/2010\/10\/26\/crm-database-daily-backup\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/\",\"name\":\"CRM database daily backup - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-10-26T05:57:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRM database daily backup\"}]},{\"@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":"CRM database daily backup - 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\/2010\/10\/26\/crm-database-daily-backup\/","og_locale":"en_US","og_type":"article","og_title":"CRM database daily backup - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Backup task is something that is very much required to be done every day in order to maintain working system over the time and recover through potential system crashes. However scheduling the one is not a great task, but needs accuracy in execution Through my observations of the processes I would not recommend third party\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-10-26T05:57:00+00:00","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\/2010\/10\/26\/crm-database-daily-backup\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/","name":"CRM database daily backup - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-10-26T05:57:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/10\/26\/crm-database-daily-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"CRM database daily backup"}]},{"@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\/267","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=267"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}