{"id":2222,"date":"2014-12-28T15:26:53","date_gmt":"2014-12-28T14:26:53","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=2222"},"modified":"2015-07-18T18:20:14","modified_gmt":"2015-07-18T17:20:14","slug":"plan-de-reprise","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=2222","title":{"rendered":"(SQL Server) Migration SQL Server 2012 en cluster 5 noeuds + PRA"},"content":{"rendered":"<p>Migration SQL Server 2012 en cluster 5 noeuds + PRA<br \/>\nMigration de la production de SQL Server 2008 + Windows 2008R2 vers Windows 2008R2 \/ SQL Server 2012 SP1 \u00e0 90% automatis\u00e9e (Synchronisation de 6.2 To de Data, D\u00e9ploiement automatique des miroirs, r\u00e9plications, changement des routes des brokers, logshipping, changement de synonymes, serveurs li\u00e9s, activation des jobs, activation des comptes, activation de SQL Mail, en 1h30 d'arr\u00eat de service. Reprise de Synchro avec la PRA sur un autre site migr\u00e9 en SQL 2012 au pr\u00e9alable. Par manque de machine, des n\u0153uds on \u00e9t\u00e9 sortis, pour refaire un cluster sur un autre SAN, suivant les chaises musicales.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Migration SQL Server 2012 en cluster 5 noeuds + PRA Migration de la production de SQL Server 2008 + Windows 2008R2 vers Windows 2008R2 \/ SQL Server 2012 SP1 \u00e0 90% automatis\u00e9e (Synchronisation de 6.2 To de Data, D\u00e9ploiement automatique des miroirs, r\u00e9plications, changement des routes des brokers, logshipping, changement de synonymes, serveurs li\u00e9s, activation &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-2222","post","type-post","status-publish","format-standard","hentry","category-realisations","no-thumb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson<\/title>\r\n<meta name=\"description\" content=\"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.teamvidia.com\/?p=2222\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson\" \/>\r\n<meta property=\"og:description\" content=\"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=2222\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2014-12-28T14:26:53+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2015-07-18T17:20:14+00:00\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"(SQL Server) Migration SQL Server 2012 en cluster 5 noeuds + PRA\",\"datePublished\":\"2014-12-28T14:26:53+00:00\",\"dateModified\":\"2015-07-18T17:20:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222\"},\"wordCount\":111,\"articleSection\":[\"R\u00e9alisations\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222\",\"url\":\"https:\/\/www.teamvidia.com\/?p=2222\",\"name\":\"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"datePublished\":\"2014-12-28T14:26:53+00:00\",\"dateModified\":\"2015-07-18T17:20:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"description\":\"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson\",\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=2222\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=2222#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"(SQL Server) Migration SQL Server 2012 en cluster 5 noeuds + PRA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.teamvidia.com\/#website\",\"url\":\"https:\/\/www.teamvidia.com\/\",\"name\":\"TEAMVIDIA\",\"description\":\"Experts Base de Donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.teamvidia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\",\"name\":\"teamvidia\",\"url\":\"https:\/\/www.teamvidia.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","description":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","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.teamvidia.com\/?p=2222","og_locale":"fr_FR","og_type":"article","og_title":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","og_description":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","og_url":"https:\/\/www.teamvidia.com\/?p=2222","og_site_name":"TEAMVIDIA","article_published_time":"2014-12-28T14:26:53+00:00","article_modified_time":"2015-07-18T17:20:14+00:00","author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=2222#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=2222"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"(SQL Server) Migration SQL Server 2012 en cluster 5 noeuds + PRA","datePublished":"2014-12-28T14:26:53+00:00","dateModified":"2015-07-18T17:20:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=2222"},"wordCount":111,"articleSection":["R\u00e9alisations"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=2222","url":"https:\/\/www.teamvidia.com\/?p=2222","name":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"datePublished":"2014-12-28T14:26:53+00:00","dateModified":"2015-07-18T17:20:14+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"description":"Migration SQL Server 2012 en cluster 5 noeuds et son plan de reprise en alwayson","breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=2222#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=2222"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=2222#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"(SQL Server) Migration SQL Server 2012 en cluster 5 noeuds + PRA"}]},{"@type":"WebSite","@id":"https:\/\/www.teamvidia.com\/#website","url":"https:\/\/www.teamvidia.com\/","name":"TEAMVIDIA","description":"Experts Base de Donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamvidia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96","name":"teamvidia","url":"https:\/\/www.teamvidia.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2222"}],"version-history":[{"count":4,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2222\/revisions"}],"predecessor-version":[{"id":2864,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/2222\/revisions\/2864"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}