{"id":131,"date":"2016-03-27T13:19:22","date_gmt":"2016-03-27T11:19:22","guid":{"rendered":"https:\/\/blog.exterra-services.cz\/?p=131"},"modified":"2019-10-29T16:33:14","modified_gmt":"2019-10-29T15:33:14","slug":"replikace-databazi-ms-sql-server-prakticky","status":"publish","type":"post","link":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/","title":{"rendered":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky"},"content":{"rendered":"\n<p>\u0158e\u0161il jsem ned\u00e1vno n\u00e1sleduj\u00edc\u00ed probl\u00e9m. \u0158e\u0161en\u00ed disaster recovery (DR) s pomoc\u00ed IBM Tivoli Storage Manageru s replikac\u00ed mezi dv\u011bma TSM servery se uk\u00e1zalo jako funk\u010dn\u00ed s jedinou v\u00fdjimkou. Replikace z\u00e1loh produk\u010dn\u00edho SQL Serveru d\u00edky velikosti datab\u00e1ze nedok\u00e1zala prob\u011bhnout v rozumn\u00e9m \u010dase. \u0158e\u0161en\u00edm se uk\u00e1zala replikace datab\u00e1z\u00ed MS SQL Serveru, kter\u00e1 je i v edici Standard k dispozici. <\/p>\n\n\n\n<p>Postup jak nakonfigurovat replikaci, je n\u00e1sleduj\u00edc\u00ed: <\/p>\n\n\n\n<p>Prove\u010fte na prim\u00e1rn\u00edm SQL serveru plnou z\u00e1lohu datab\u00e1ze, kter\u00e1 bude replikov\u00e1na<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"538\" height=\"333\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\" alt=\"\" class=\"wp-image-132\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png 538w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1-300x186.png 300w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-2.png\" alt=\"\" class=\"wp-image-133\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-2.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-2-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><figcaption><br><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-3.png\" alt=\"\" class=\"wp-image-134\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-3.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-3-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><figcaption><br><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"124\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-4.png\" alt=\"\" class=\"wp-image-135\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-4.png 612w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-4-300x61.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><figcaption>V p\u0159\u00edpad\u011b \u00fasp\u011bchu z\u00e1lohy uvid\u00edte tento dialog.<br><br><\/figcaption><\/figure>\n\n\n\n<p>Na c\u00edlov\u00e9m serveru obnovte z\u00e1lohu datab\u00e1ze, ide\u00e1ln\u011b pod stejn\u00fdm jm\u00e9nem. POZOR &#8211; je t\u0159eba obnovu prov\u00e9st s volbou &#8222;RESTORE WITH NORECOVERY&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"205\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-5.png\" alt=\"\" class=\"wp-image-137\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-5.png 320w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-5-300x192.png 300w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-6.png\" alt=\"\" class=\"wp-image-138\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-6.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-6-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"362\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-7.png\" alt=\"\" class=\"wp-image-139\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-7.png 500w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-7-300x217.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-8.png\" alt=\"\" class=\"wp-image-140\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-8.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-8-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-9.png\" alt=\"\" class=\"wp-image-141\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-9.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-9-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"124\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-10.png\" alt=\"\" class=\"wp-image-142\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-10.png 612w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-10-300x61.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><figcaption>\u00dasp\u011b\u0161nost obnovy potvrzuje tento dialog. <\/figcaption><\/figure>\n\n\n\n<p>Ov\u011b\u0159te, \u017ee datab\u00e1ze na c\u00edlov\u00e9m serveru je ve stavu &#8222;Restoring&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"280\" height=\"235\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-11.png\" alt=\"\" class=\"wp-image-143\"\/><\/figure>\n\n\n\n<p>Na prim\u00e1rn\u00edm SQL serveru spus\u0165te konfiguraci mirroru volbou Tasks &#8211; Mirror <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"315\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-12.png\" alt=\"\" class=\"wp-image-144\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-12.png 542w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-12-300x174.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/figure>\n\n\n\n<p>V n\u00e1sleduj\u00edc\u00edm dialogu zvolte &#8222;Configure Security&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-13.png\" alt=\"\" class=\"wp-image-145\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-13.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-13-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<p>Spust\u00ed se wizard pro konfiguraci mirroru<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-14.png\" alt=\"\" class=\"wp-image-146\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-14.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-14-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Zvolte konfiguraci bez &#8222;Witness Serveru&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-15.png\" alt=\"\" class=\"wp-image-147\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-15.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-15-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Potvr\u010fte prim\u00e1rn\u00ed server <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-16.png\" alt=\"\" class=\"wp-image-148\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-16.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-16-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Vyberte &#8222;mirror server&#8220; a zvolte &#8222;Connect&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-17.png\" alt=\"\" class=\"wp-image-149\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-17.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-17-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Potvr\u010fte u\u017eivatele a heslo pro p\u0159ipojen\u00ed k &#8222;mirror serveru&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"308\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-18.png\" alt=\"\" class=\"wp-image-150\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-18.png 416w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-18-300x222.png 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/figure>\n\n\n\n<p>Po \u00fasp\u011b\u0161n\u00e9m p\u0159ipojen\u00ed zvolte &#8222;Next&#8220;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-19.png\" alt=\"\" class=\"wp-image-151\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-19.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-19-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Zvolte \u00fa\u010dty, pod nimi\u017e b\u011b\u017e\u00ed ob\u011b instance zrcadlen\u00fdch SQL Server\u016f <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-20.png\" alt=\"\" class=\"wp-image-152\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-20.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-20-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Zkontrolujte vybran\u00e1 nastaven\u00ed a zvolte &#8222;Finish&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-21.png\" alt=\"\" class=\"wp-image-153\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-21.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-21-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Zkontrolujte, \u017ee konfigurace obou server\u016f prob\u011bhla bez chyb. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"442\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-22.png\" alt=\"\" class=\"wp-image-154\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-22.png 494w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-22-300x268.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>Nyn\u00ed m\u016f\u017eete spustit proces zrcadlen\u00ed volbou &#8222;Start Mirroring&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"254\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-23.png\" alt=\"\" class=\"wp-image-155\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-23.png 612w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-23-300x125.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/figure>\n\n\n\n<p>Pokud se proces mirroringu spustil v po\u0159\u00e1dku, uvid\u00edte v dialogu jeho nastaven\u00ed oba servery.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"632\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-24.png\" alt=\"\" class=\"wp-image-156\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-24.png 704w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-24-300x269.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<p>Dal\u0161\u00ed kontrolou je v SQL Management Studiu stav obou datab\u00e1z\u00ed &#8211; prim\u00e1n\u00ed jako &#8222;Principal, Synchronized&#8220;, jej\u00ed zrcadlo jako &#8222;Mirror, Synchronized \/ Restoring&#8220;. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"340\" height=\"759\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-25.png\" alt=\"\" class=\"wp-image-157\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-25.png 340w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-25-134x300.png 134w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/figure>\n\n\n\n<p>Nyn\u00ed m\u00e1te k dispozici p\u0159esnou, online zrcadlenou kopii dan\u00e9 datab\u00e1ze. Ta bohu\u017eel nen\u00ed automaticky p\u0159\u00edstupn\u00e1 klient\u016fm. P\u0159i v\u00fdpadku prim\u00e1rn\u00edho serveru je t\u0159eba zrcadlenou datab\u00e1zi p\u0159epnout ze stavu &#8222;Restoring&#8220;. <\/p>\n\n\n\n<p>Zotaven\u00ed datab\u00e1ze provedete n\u00e1sleduj\u00edc\u00edm postupem: <\/p>\n\n\n\n<p>Na server se zrcadlem datab\u00e1ze se p\u0159ipojte pomoc\u00ed SQL Management studia.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"282\" height=\"238\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-26.png\" alt=\"\" class=\"wp-image-158\"\/><\/figure>\n\n\n\n<p>Zadejte p\u0159\u00edkaz &#8222;RESTORE DATABASE jmeno_database WITH RECOVERY;&#8220; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"876\" height=\"460\" src=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-27.png\" alt=\"\" class=\"wp-image-159\" srcset=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-27.png 876w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-27-300x158.png 300w, https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-27-768x403.png 768w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/figure>\n\n\n\n<p>Pokud se povedlo, v\u00fdstup p\u0159\u00edkazu je &#8222;RESTORE DATABASE successfully processed\u2026.&#8220;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0158e\u0161il jsem ned\u00e1vno n\u00e1sleduj\u00edc\u00ed probl\u00e9m. \u0158e\u0161en\u00ed disaster recovery (DR) s pomoc\u00ed IBM Tivoli Storage Manageru s replikac\u00ed mezi dv\u011bma TSM servery se uk\u00e1zalo jako funk\u010dn\u00ed s jedinou v\u00fdjimkou. Replikace z\u00e1loh produk\u010dn\u00edho SQL Serveru d\u00edky velikosti datab\u00e1ze nedok\u00e1zala prob\u011bhnout v rozumn\u00e9m \u010dase. \u0158e\u0161en\u00edm se uk\u00e1zala replikace datab\u00e1z\u00ed MS SQL Serveru, kter\u00e1 je i v edici Standard [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[5],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-technologie","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot<\/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:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot\" \/>\n<meta property=\"og:description\" content=\"\u0158e\u0161il jsem ned\u00e1vno n\u00e1sleduj\u00edc\u00ed probl\u00e9m. \u0158e\u0161en\u00ed disaster recovery (DR) s pomoc\u00ed IBM Tivoli Storage Manageru s replikac\u00ed mezi dv\u011bma TSM servery se uk\u00e1zalo jako funk\u010dn\u00ed s jedinou v\u00fdjimkou. Replikace z\u00e1loh produk\u010dn\u00edho SQL Serveru d\u00edky velikosti datab\u00e1ze nedok\u00e1zala prob\u011bhnout v rozumn\u00e9m \u010dase. \u0158e\u0161en\u00edm se uk\u00e1zala replikace datab\u00e1z\u00ed MS SQL Serveru, kter\u00e1 je i v edici Standard [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\" \/>\n<meta property=\"og:site_name\" content=\"Coffeespot\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-27T11:19:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-29T15:33:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\" \/>\n<meta name=\"author\" content=\"Petr \u0160antr\u016f\u010dek\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Petr \u0160antr\u016f\u010dek\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\"},\"author\":{\"name\":\"Petr \u0160antr\u016f\u010dek\",\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\"},\"headline\":\"Replikace datab\u00e1z\u00ed MS SQL Server prakticky\",\"datePublished\":\"2016-03-27T11:19:22+00:00\",\"dateModified\":\"2019-10-29T15:33:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\"},\"wordCount\":395,\"publisher\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\"},\"image\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\",\"articleSection\":[\"Technologie\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\",\"url\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\",\"name\":\"Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot\",\"isPartOf\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\",\"datePublished\":\"2016-03-27T11:19:22+00:00\",\"dateModified\":\"2019-10-29T15:33:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage\",\"url\":\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\",\"contentUrl\":\"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png\",\"width\":538,\"height\":333},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.exterra-services.cz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Replikace datab\u00e1z\u00ed MS SQL Server prakticky\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.exterra-services.cz\/#website\",\"url\":\"https:\/\/blog.exterra-services.cz\/\",\"name\":\"Coffeespot\",\"description\":\"novinky z IT sv\u011bta\",\"publisher\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.exterra-services.cz\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\",\"name\":\"Petr \u0160antr\u016f\u010dek\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/154c38d0d2d25a88896d979541de331f6606987733e06f398d3552a6871e5b77?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/154c38d0d2d25a88896d979541de331f6606987733e06f398d3552a6871e5b77?s=96&d=mm&r=g\",\"caption\":\"Petr \u0160antr\u016f\u010dek\"},\"logo\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.exterra-services.cz\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot","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:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/","og_locale":"cs_CZ","og_type":"article","og_title":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot","og_description":"\u0158e\u0161il jsem ned\u00e1vno n\u00e1sleduj\u00edc\u00ed probl\u00e9m. \u0158e\u0161en\u00ed disaster recovery (DR) s pomoc\u00ed IBM Tivoli Storage Manageru s replikac\u00ed mezi dv\u011bma TSM servery se uk\u00e1zalo jako funk\u010dn\u00ed s jedinou v\u00fdjimkou. Replikace z\u00e1loh produk\u010dn\u00edho SQL Serveru d\u00edky velikosti datab\u00e1ze nedok\u00e1zala prob\u011bhnout v rozumn\u00e9m \u010dase. \u0158e\u0161en\u00edm se uk\u00e1zala replikace datab\u00e1z\u00ed MS SQL Serveru, kter\u00e1 je i v edici Standard [&hellip;]","og_url":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/","og_site_name":"Coffeespot","article_published_time":"2016-03-27T11:19:22+00:00","article_modified_time":"2019-10-29T15:33:14+00:00","og_image":[{"url":"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png","type":"","width":"","height":""}],"author":"Petr \u0160antr\u016f\u010dek","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Petr \u0160antr\u016f\u010dek","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#article","isPartOf":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/"},"author":{"name":"Petr \u0160antr\u016f\u010dek","@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788"},"headline":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky","datePublished":"2016-03-27T11:19:22+00:00","dateModified":"2019-10-29T15:33:14+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/"},"wordCount":395,"publisher":{"@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788"},"image":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png","articleSection":["Technologie"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/","url":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/","name":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky | Coffeespot","isPartOf":{"@id":"https:\/\/blog.exterra-services.cz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage"},"image":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png","datePublished":"2016-03-27T11:19:22+00:00","dateModified":"2019-10-29T15:33:14+00:00","breadcrumb":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#primaryimage","url":"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png","contentUrl":"https:\/\/blog.exterra-services.cz\/wp-content\/uploads\/2019\/10\/image-1.png","width":538,"height":333},{"@type":"BreadcrumbList","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2016\/03\/27\/replikace-databazi-ms-sql-server-prakticky\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.exterra-services.cz\/"},{"@type":"ListItem","position":2,"name":"Replikace datab\u00e1z\u00ed MS SQL Server prakticky"}]},{"@type":"WebSite","@id":"https:\/\/blog.exterra-services.cz\/#website","url":"https:\/\/blog.exterra-services.cz\/","name":"Coffeespot","description":"novinky z IT sv\u011bta","publisher":{"@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.exterra-services.cz\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":["Person","Organization"],"@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788","name":"Petr \u0160antr\u016f\u010dek","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/154c38d0d2d25a88896d979541de331f6606987733e06f398d3552a6871e5b77?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/154c38d0d2d25a88896d979541de331f6606987733e06f398d3552a6871e5b77?s=96&d=mm&r=g","caption":"Petr \u0160antr\u016f\u010dek"},"logo":{"@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.exterra-services.cz"]}]}},"_links":{"self":[{"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":0,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}