[:pt]O momento que sabemos que h\u00e1-de acontecer mais tarde ou mais cedo mas que temos sempre a esperan\u00e7a que n\u00e3o aconte\u00e7a, aconteceu: O meu servidor de SQL morreu completa e definitivamente!<\/p>\n
Este servidor tinha as bases de dados de TODOS os programas da empresa onde trabalho e podia ter sido um grande problema n\u00e3o tivesse eu as c\u00f3pias de seguran\u00e7a todas em dia. Com elas, o downtime<\/em> foi pequeno e a recupera\u00e7\u00e3o completa e sem necessidade de qualquer esp\u00e9cie de altera\u00e7\u00e3o na rede, no servidor ou nos clientes. Foi um caso de 99.99% de sucesso, e tudo gra\u00e7as \u00e0s ditas c\u00f3pias de seguran\u00e7a.<\/p>\n Das in\u00fameras c\u00f3pias de todos os formatos e feitios que fa\u00e7o, as que usei no processo de recupera\u00e7\u00e3o foram:<\/p>\n > imagem do servidor, com 2 a 3 meses, feito com o vmware<\/em> converter<\/em>; O vmware<\/em> converter<\/em><\/a> (gratuito) permite copiar um computador real\/f\u00edsico para um conjunto de ficheiros – que no seu conjunto fazem um computador virtual – sem necessidade de interromper o funcionamento desse computador. Eu fa\u00e7o regularmente, de 3 em 3 meses, imagens\/computadores virtuais dos meus servidores \u00a0para um disco externo USB. Essas imagens\/computadores virtuais\u00a0podem ser executadas com o software vmware player<\/em><\/a> (gratuito) em qualquer PC.<\/p>\n Para voltar a colocar o servidor a funcionar basta copiar os ficheiros para um computador que tenha o vmware player<\/em> instalado e execut\u00e1-lo. Eu n\u00e3o tinha nenhum servidor com capacidade extra suficiente, por isso, usei o meu port\u00e1til<\/strong> para executar o servidor virtual. O processo \u00e9 r\u00e1pido e simples, e em menos de 2\/3 horas o servidor estava de novo online<\/em> sem haver a necessidade de qualquer altera\u00e7\u00e3o no servidor, na rede ou nos clientes… minto! precisei de alterar o endere\u00e7o IP do servidor virtual. A placa de rede do servidor f\u00edsico \u00e9 diferente da placa de rede do servidor virtual, por isso a configura\u00e7\u00e3o IP que est\u00e1 no servidor f\u00edsico perde-se com a passagem para virtual, e precisamos de manualmente configura-la.<\/p>\n Depois do servidor a funcionar repus\u00a0todas as c\u00f3pias do SQL o que me demorou mais 2\/3 horas. No fim do processo, que demorou cerca de um dia, tinha o servidor operacional e com todos os dados recuperados.<\/p>\n Com tudo a funcionar pude, calmamente, escolher e encomendar um servidor novo para alojar o servidor perdido.<\/p>\n Passar um servidor virtual de novo a servidor f\u00edsico \u00e9 mais complicado – nem sei se \u00e9 poss\u00edvel -e sinceramente n\u00e3o me parecia que valesse a pena. Por isso tive o cuidado de escolher um servidor que suportasse o vmware<\/em> ESXi<\/em><\/a> (gratuito) que \u00e9 um hypervisor<\/em><\/a> – uma esp\u00e9cie de sistema operativo que executa m\u00e1quinas virtual, ou por outras palavras um vmware<\/em> player<\/em> que n\u00e3o precisa de sistema operativo – e copiei para l\u00e1 o meu servidor virtual.<\/p>\n Neste momento, passados v\u00e1rios meses, posso dizer que o servidor funciona normalmente e inclusive\u00a0j\u00e1 usei o mesmo m\u00e9todo – virtualizar com o vmware converter<\/em> – em mais dois servidores e sempre sem qualquer esp\u00e9cie de problemas. \u00c9 a melhor solu\u00e7\u00e3o (gratuita) de c\u00f3pias de seguran\u00e7a que usei.<\/p>\n Aconselho vivamente adicionarem este m\u00e9todo ao vosso portf\u00f3lio de c\u00f3pias de seguran\u00e7a.[:en]The moment that we know have to happen sooner or later but we always hope that does not happen, happened: My SQL server died completely and permanently!<\/p>\n This server had the databases of all programs of the company where I work and could have been a big problem \u00a0had I not the backups done daily. With them, the downtime was small therecovery as complete and no need for any kind of change in the network, the server or the client. It was a case of 99.99% of success, and all thanks to those backups.<\/p>\n Of the many copies of all shapes I do, those used in the recovery process were:<\/p>\n > Image from the server, with 2 to 3 months, done with the VMware converter; vmware<\/em> converter<\/em><\/a> (free) lets you copy a real \/ physical\u00a0computer for a set of files – that the in whole are virtual computer – with no need to interrupt the operation of it. I do regularly, 3 in 3 months, images \/ virtual\u00a0computer of my servers to a USB external disk. These images \/ virtual computers can run with the vmware player<\/em><\/a> software (free) on any PC.<\/p>\n To get the server online I just copied the files to a computer that has the VMware Player installed and run it. I had no server with enough extra capacity, so I used my laptop <\/strong>to run the virtual server. The process is fast and simple, and less than 2 \/ 3 hours the server was online again without the need for any change in server, network or on customers …ok, i’m liying! I needed to change the IP address of the virtual server. The network adapter of the server is different from the physical network card of the virtual server, so the IP configuration that is in the physical server is lost with the move to virtual, and we need to manually configure it.<\/p>\n After the server running i restored all copies of the SQL that I took over 2 \/ 3 hours. At the end of the process, which took about a day, I had the server online with all data recovered.<\/p>\n With everytinh working, I could choose and order a new server to host the lost. one<\/p>\n Transfer a virtual server to a physical server is more complicated – I do not know if you can, and honestly I actually\u00a0don’t think it’s worth. So I was careful to choose a server that supports the vmware<\/em> ESXi<\/em><\/a> (free) which is a hypervisor<\/a> <\/em>– a kind of operating system that runs virtual machines, or in other words a VMware Player that does not require operating system – and copied my virtual server to it.<\/p>\n Today, after several months, I can say that the server operates normally and even have used the same method – virtualizing with VMware converter – in two servers and always without any kind of problems. It is the best (free) backup I ever used.<\/p>\n I Strongly advise this method to add your portfolio to back up.[:]<\/p>\n\n\n [:pt]O que fazer quando a motherboard de um servidor queima e leva os discos com ela?[:en]What to do when the motherboard burns and kills the hard drives in the process?[:]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[24,17,19,18,20],"class_list":["post-162","post","type-post","status-publish","format-standard","hentry","category-networking","tag-redes","tag-backup","tag-free","tag-sql","tag-virtualization","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/posts\/162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":14,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"predecessor-version":[{"id":363,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/posts\/162\/revisions\/363"}],"wp:attachment":[{"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/work.claudiotereso.com\/en\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
> c\u00f3pias completas semanais + c\u00f3pias incrementais di\u00e1rias + \u00a0c\u00f3pias de logs hor\u00e1rias, do SQL <\/em>Server<\/em>;<\/p>\n
> Full copies weekly + daily + copies incremental copies of hourly logs, SQL Server;<\/p>\n