﻿{"id":123,"date":"2020-08-14T18:19:14","date_gmt":"2020-08-14T21:19:14","guid":{"rendered":"https:\/\/blog.adsdoctor.com.br\/?p=123"},"modified":"2021-09-20T11:19:21","modified_gmt":"2021-09-20T14:19:21","slug":"saiba-como-realizar-o-backup-do-banco-de-dados","status":"publish","type":"post","link":"https:\/\/blog.adsdoctor.com.br\/?p=123","title":{"rendered":"Saiba como realizar o backup do banco de dados"},"content":{"rendered":"\n<p>O <strong>ADS SQLTools<\/strong> \u00e9 o aplicativo respons\u00e1vel pela cria\u00e7\u00e3o do backup do banco de dados, ou seja, da sua c\u00f3pia de seguran\u00e7a.<\/p>\n\n\n\n<p>Caso tenha algum problema com seu equipamento ser\u00e1 poss\u00edvel restaurar as informa\u00e7\u00f5es a partir deste arquivo. Por isso, \u00e9 muito importante que realize o backup regularmente.<\/p>\n\n\n\n<p>O ADS SQLTools \u00e9 instalado apenas no computador definido como servidor de dados do ADS Doctor.<\/p>\n\n\n\n<p>Acesse o <strong>menu iniciar do Windows<\/strong> e localize o conjunto de aplica\u00e7\u00f5es do ADS Doctor, figura 1.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"263\" height=\"470\" src=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-4.png\" alt=\"\" class=\"wp-image-146\" srcset=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-4.png 263w, https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-4-168x300.png 168w\" sizes=\"(max-width: 263px) 100vw, 263px\" \/><figcaption><strong>Figura 1<\/strong> &#8211; Localiza\u00e7\u00e3o<\/figcaption><\/figure><\/div>\n\n\n\n<p>Clique em <strong>ADS SQLTools<\/strong> e aguarde a abertura do aplicativo.<\/p>\n\n\n\n<p>O primeiro passo \u00e9 conectar ao gerenciador do banco de dados. Selecione a forma de autentica\u00e7\u00e3o, <strong>Windows<\/strong> ou <strong>SQL Server<\/strong> e clique em <strong>Conectar<\/strong>, figura 2.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"739\" height=\"493\" src=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1.png\" alt=\"\" class=\"wp-image-140\" srcset=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1.png 739w, https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-300x200.png 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><figcaption><strong>Figura 2<\/strong> &#8211; Dados de conex\u00e3o com gerenciador do banco de dados<\/figcaption><\/figure><\/div>\n\n\n\n<p><em>Para utilizar a <strong>Autentica\u00e7\u00e3o SQL Server<\/strong>, consulte os manuais ou entre em <a href=\"https:\/\/cliente.adsdoctor.com.br\" target=\"_blank\" rel=\"noreferrer noopener\">contato com o suporte t\u00e9cnico<\/a> para obter as informa\u00e7\u00f5es sobre Usu\u00e1rio e Senha.<\/em><\/p>\n\n\n\n<p>O segundo passo \u00e9 selecionar uma tarefa.<\/p>\n\n\n\n<p>Selecione a tarefa <strong>C\u00f3pia<\/strong>, localizado no canto superior esquerdo do aplicativo, figura 3.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"739\" height=\"493\" src=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-1.png\" alt=\"\" class=\"wp-image-141\" srcset=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-1.png 739w, https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-1-300x200.png 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><figcaption><strong>Figura 3<\/strong> &#8211; Sele\u00e7\u00e3o da Tarefa<\/figcaption><\/figure><\/div>\n\n\n\n<p>Repare que o aplicativo seleciona o banco de dados <strong>ADSDoctor<\/strong> e define automaticamente um nome para o seu arquivo de backup.<\/p>\n\n\n\n<p>Por padr\u00e3o, o nome do arquivo de backup conter\u00e1 o nome do banco de dados e a data da sua cria\u00e7\u00e3o, conforme o modelo abaixo.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><em><span class=\"has-inline-color has-very-dark-gray-color\"><strong>ADSDoctor_Copia_[Ano]_[Mes]_[Dia].bak<\/strong><\/span><\/em><\/p>\n\n\n\n<p>O terceiro passo ser\u00e1 selecionar o local de armazenamento do arquivo, figura 4.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"739\" height=\"493\" src=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-2.png\" alt=\"\" class=\"wp-image-143\" srcset=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-2.png 739w, https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-2-300x200.png 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><figcaption><strong>Figura 4<\/strong> &#8211; Local de Destino da C\u00f3pia de Seguran\u00e7a<\/figcaption><\/figure><\/div>\n\n\n\n<p>Recomendamos que utilize uma <em>pendrive <\/em>ou um hd externo e o mantenha em um lugar seguro. Dessa forma, caso ocorra algum dano ao seu servidor, suas c\u00f3pias estar\u00e3o protegidas.<\/p>\n\n\n\n<p>Por fim, clique no bot\u00e3o <strong>Copiar <\/strong>e aguarde a mensagem de confirma\u00e7\u00e3o, figura 5.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"737\" height=\"490\" src=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-3.png\" alt=\"\" class=\"wp-image-145\" srcset=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-3.png 737w, https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/backup1-3-300x199.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><figcaption><strong>Figura 5<\/strong> &#8211; Backup conclu\u00eddo<\/figcaption><\/figure>\n\n\n\n<p>Pronto, o backup foi realizado com sucesso.<\/p>\n\n\n\n<p><a href=\"?post=115\">Saiba qual a import\u00e2ncia de manter uma c\u00f3pia de seguran\u00e7a do seu banco de dados.<\/a><\/p>\n\n\n\n<p>Para suporte t\u00e9cnico, acesse o <a href=\"https:\/\/cliente.adsdoctor.com.br\" target=\"_blank\" rel=\"noreferrer noopener\">Portal do Cliente<\/a> ou ligue para o 0800.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>O ADS SQLTools \u00e9 o aplicativo respons\u00e1vel pela cria\u00e7\u00e3o do backup do banco de dados, ou seja, da sua c\u00f3pia de seguran\u00e7a. Caso tenha algum problema com seu equipamento ser\u00e1 poss\u00edvel restaurar as informa\u00e7\u00f5es a partir deste arquivo. Por isso, \u00e9 muito importante que realize o backup regularmente. O ADS SQLTools \u00e9 instalado apenas no [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":127,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[20,7],"tags":[8,6],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v14.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Saiba como realizar o backup do banco de dados | Blog do ADS Doctor - Prontu\u00e1rio Eletr\u00f4nico<\/title>\r\n<meta name=\"description\" content=\"Demonstra\u00e7\u00e3o passo a passo do backup do banco de dados do ADS Doctor, prontu\u00e1rio eletr\u00f4nico para cl\u00ednicas e consult\u00f3rios m\u00e9dicos.\" \/>\r\n<meta name=\"robots\" content=\"index, follow\" \/>\r\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/blog.adsdoctor.com.br\/?p=123\" \/>\r\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Saiba como realizar o backup do banco de dados | Blog do ADS Doctor - Prontu\u00e1rio Eletr\u00f4nico\" \/>\r\n<meta property=\"og:description\" content=\"Demonstra\u00e7\u00e3o passo a passo do backup do banco de dados do ADS Doctor, prontu\u00e1rio eletr\u00f4nico para cl\u00ednicas e consult\u00f3rios m\u00e9dicos.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/blog.adsdoctor.com.br\/?p=123\" \/>\r\n<meta property=\"og:site_name\" content=\"Blog do ADS Doctor - Prontu\u00e1rio Eletr\u00f4nico\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-08-14T21:19:14+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2021-09-20T14:19:21+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/Tutorial.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\r\n\t<meta property=\"og:image:height\" content=\"800\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#organization\",\"name\":\"ADS Doctor\",\"url\":\"https:\/\/blog.adsdoctor.com.br\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/ads.doctor\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#logo\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/logoEmail.png\",\"width\":250,\"height\":41,\"caption\":\"ADS Doctor\"},\"image\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#website\",\"url\":\"https:\/\/blog.adsdoctor.com.br\/\",\"name\":\"Blog do ADS Doctor\",\"description\":\"Acompanhe as \\u00faltimas novidades\",\"publisher\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/blog.adsdoctor.com.br\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/blog.adsdoctor.com.br\/wp-content\/uploads\/2020\/08\/Tutorial.png\",\"width\":1920,\"height\":800,\"caption\":\"Imagem do post\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#webpage\",\"url\":\"https:\/\/blog.adsdoctor.com.br\/?p=123\",\"name\":\"Saiba como realizar o backup do banco de dados | Blog do ADS Doctor - Prontu\\u00e1rio Eletr\\u00f4nico\",\"isPartOf\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#primaryimage\"},\"datePublished\":\"2020-08-14T21:19:14+00:00\",\"dateModified\":\"2021-09-20T14:19:21+00:00\",\"description\":\"Demonstra\\u00e7\\u00e3o passo a passo do backup do banco de dados do ADS Doctor, prontu\\u00e1rio eletr\\u00f4nico para cl\\u00ednicas e consult\\u00f3rios m\\u00e9dicos.\",\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.adsdoctor.com.br\/?p=123\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#webpage\"},\"author\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#\/schema\/person\/03464f5d4a723bb08419b07a2c063752\"},\"headline\":\"Saiba como realizar o backup do banco de dados\",\"datePublished\":\"2020-08-14T21:19:14+00:00\",\"dateModified\":\"2021-09-20T14:19:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#webpage\"},\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#organization\"},\"image\":{\"@id\":\"https:\/\/blog.adsdoctor.com.br\/?p=123#primaryimage\"},\"keywords\":\"ajuda,tutorial\",\"articleSection\":\"Desktop,Tutorial\",\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.adsdoctor.com.br\/?p=123#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#\/schema\/person\/03464f5d4a723bb08419b07a2c063752\",\"name\":\"adsnetwork\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/blog.adsdoctor.com.br\/#personlogo\",\"inLanguage\":\"pt-BR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c5a8ceeece18e77a5baf42749b89867?s=96&d=mm&r=g\",\"caption\":\"adsnetwork\"}}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/posts\/123"}],"collection":[{"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=123"}],"version-history":[{"count":13,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":238,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/posts\/123\/revisions\/238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=\/wp\/v2\/media\/127"}],"wp:attachment":[{"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.adsdoctor.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}