{"id":616,"date":"2023-03-30T08:44:27","date_gmt":"2023-03-30T06:44:27","guid":{"rendered":"https:\/\/blog.exterra-services.cz\/?p=616"},"modified":"2023-03-30T08:44:29","modified_gmt":"2023-03-30T06:44:29","slug":"obnova-sql-databaze-do-jine-instance","status":"publish","type":"post","link":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/","title":{"rendered":"Obnova SQL datab\u00e1ze do jin\u00e9 instance"},"content":{"rendered":"\n<p>Obnova SQL datab\u00e1z\u00ed prost\u0159edky SQL Management Studia je relativn\u011b trivi\u00e1ln\u00ed z\u00e1le\u017eitost, pokud ov\u0161em nemus\u00edte obnovu prov\u00e9st na jin\u00fd SQL server nebo do jin\u00e9 instance. \u0158e\u0161en\u00ed nen\u00ed slo\u017eit\u00e9, ale je to trocha ru\u010dn\u00ed pr\u00e1ce.<\/p>\n\n\n\n<p>Nejrpve mus\u00edte vytvo\u0159it &#8222;backup device&#8220; typu &#8222;file&#8220;.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">USE master\nexec master.dbo.Sp_addumpdevice\n    @devtype = N'disk',\n    @logicalname = N'Sklad_KN_backup',\n    @physicalname = N'E:\\SQLBck\\Sklad_KN_backup_2023_03_24_030002_8650379.bak'<\/pre>\n\n\n\n<p>Nyn\u00ed provedete obnovu s p\u0159em\u00edst\u011bn\u00edm datov\u00e9ho souboru a transak\u010dn\u00edho logu do jin\u00fdch cest.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">RESTORE FILELISTONLY FROM Sklad_KN_backup;\nRESTORE DATABASE Sklad_KN FROM Sklad_KN_backup WITH RECOVERY,\n    MOVE 'Sklad_KN' TO 'F:\\SQL\\Sklad_KN.mdf', MOVE 'Sklad_KN_log' TO 'F:\\SQL\\Log\\Sklad_KN_log.ldf';  \nGO\n<\/pre>\n\n\n\n<p>Tento \u010dl\u00e1nek jsem poskl\u00e1dal z n\u011bkolika u\u017eite\u010dn\u00fdch informa\u010dn\u00edch zdroj\u016f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/define-a-logical-backup-device-for-a-disk-file-sql-server?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Define a Logical Backup Device for a Disk File (SQL Server)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/restore-a-database-to-a-new-location-sql-server?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Restore a Database to a New Location (SQL Server)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sqlbak.com\/blog\/complete-guide-to-sql-server-backup-and-restore-using-the-command-line\" target=\"_blank\" rel=\"noreferrer noopener\">Complete Guide to SQL Server Backup and Restore Using the Command Line<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Obnova SQL datab\u00e1z\u00ed prost\u0159edky SQL Management Studia je relativn\u011b trivi\u00e1ln\u00ed z\u00e1le\u017eitost, pokud ov\u0161em nemus\u00edte obnovu prov\u00e9st na jin\u00fd SQL server nebo do jin\u00e9 instance. \u0158e\u0161en\u00ed nen\u00ed slo\u017eit\u00e9, ale je to trocha ru\u010dn\u00ed pr\u00e1ce. Nejrpve mus\u00edte vytvo\u0159it &#8222;backup device&#8220; typu &#8222;file&#8220;. USE master exec master.dbo.Sp_addumpdevice @devtype = N&#8217;disk&#8216;, @logicalname = N&#8217;Sklad_KN_backup&#8216;, @physicalname = N&#8217;E:\\SQLBck\\Sklad_KN_backup_2023_03_24_030002_8650379.bak&#8216; Nyn\u00ed provedete [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","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":"0","ocean_second_sidebar":"0","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":"0","ocean_custom_header_template":"0","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":"0","ocean_menu_typo_font_family":"0","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":"0","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":"off","ocean_gallery_id":[],"footnotes":""},"categories":[5],"tags":[],"class_list":["post-616","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>Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot<\/title>\n<meta name=\"description\" content=\"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.\" \/>\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\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot\" \/>\n<meta property=\"og:description\" content=\"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"Coffeespot\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-30T06:44:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-30T06:44:29+00:00\" \/>\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=\"1 minuta\" \/>\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\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\"},\"author\":{\"name\":\"Petr \u0160antr\u016f\u010dek\",\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\"},\"headline\":\"Obnova SQL datab\u00e1ze do jin\u00e9 instance\",\"datePublished\":\"2023-03-30T06:44:27+00:00\",\"dateModified\":\"2023-03-30T06:44:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\"},\"wordCount\":131,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788\"},\"articleSection\":[\"Technologie\"],\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\",\"url\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\",\"name\":\"Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot\",\"isPartOf\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/#website\"},\"datePublished\":\"2023-03-30T06:44:27+00:00\",\"dateModified\":\"2023-03-30T06:44:29+00:00\",\"description\":\"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.exterra-services.cz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Obnova SQL datab\u00e1ze do jin\u00e9 instance\"}]},{\"@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":"Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot","description":"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.","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\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/","og_locale":"cs_CZ","og_type":"article","og_title":"Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot","og_description":"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.","og_url":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/","og_site_name":"Coffeespot","article_published_time":"2023-03-30T06:44:27+00:00","article_modified_time":"2023-03-30T06:44:29+00:00","author":"Petr \u0160antr\u016f\u010dek","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Petr \u0160antr\u016f\u010dek","Odhadovan\u00e1 doba \u010dten\u00ed":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#article","isPartOf":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/"},"author":{"name":"Petr \u0160antr\u016f\u010dek","@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788"},"headline":"Obnova SQL datab\u00e1ze do jin\u00e9 instance","datePublished":"2023-03-30T06:44:27+00:00","dateModified":"2023-03-30T06:44:29+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/"},"wordCount":131,"commentCount":0,"publisher":{"@id":"https:\/\/blog.exterra-services.cz\/#\/schema\/person\/9d7d8c191f609a8a425d4c493eeee788"},"articleSection":["Technologie"],"inLanguage":"cs","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/","url":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/","name":"Obnova SQL datab\u00e1ze do jin\u00e9 instance | Coffeespot","isPartOf":{"@id":"https:\/\/blog.exterra-services.cz\/#website"},"datePublished":"2023-03-30T06:44:27+00:00","dateModified":"2023-03-30T06:44:29+00:00","description":"Obnova SQL datab\u00e1ze na jin\u00fd server nebo do jin\u00e9 instance je relativn\u011b snadn\u00e1, ale jde o trochu ru\u010dn\u00ed pr\u00e1ce.","breadcrumb":{"@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.exterra-services.cz\/index.php\/2023\/03\/30\/obnova-sql-databaze-do-jine-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.exterra-services.cz\/"},{"@type":"ListItem","position":2,"name":"Obnova SQL datab\u00e1ze do jin\u00e9 instance"}]},{"@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\/616","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=616"}],"version-history":[{"count":1,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/posts\/616\/revisions"}],"predecessor-version":[{"id":617,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/posts\/616\/revisions\/617"}],"wp:attachment":[{"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/media?parent=616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/categories?post=616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.exterra-services.cz\/index.php\/wp-json\/wp\/v2\/tags?post=616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}