{"id":8715,"date":"2016-08-19T07:52:29","date_gmt":"2016-08-19T05:52:29","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/"},"modified":"2016-08-19T07:52:29","modified_gmt":"2016-08-19T05:52:29","slug":"neue-datenbank-konsole-befehle-dbcc-clonedatabase","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/","title":{"rendered":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE"},"content":{"rendered":"<p>Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE.<\/p>\n<p>\u201eDBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen zu untersuchen.\u201c MSDN Quelle finden wir <a title=\"https:\/\/support.microsoft.com\/de-de\/kb\/3177838\" href=\"https:\/\/support.microsoft.com\/de-de\/kb\/3177838\" target=\"_blank\">hier. <\/a><\/p>\n<p>Dieser Befehl kann nur Benutzedatenbanken klonen.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10222 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01.png\" alt=\"Clonedatabase01\" width=\"759\" height=\"495\" \/><\/a><\/p>\n<p>Wie Sie sehen, f\u00fcr die Systemdatenbanken ist es nicht m\u00f6glich, denn es treten Fehlermeldungen auf:<br \/>\n<span style=\"color: red\"><em>Msg 12603, Level 16, State 1, Line 5<\/em><br \/>\n<em>DBCC CLONEDATABASE does not support cloning system databases.<\/em><\/span><\/p>\n<p>Mit DBCC CLONEDATABASE wird eine neue Datenbank erstellet. Es ist ein interner Snapshot der die Systemmetadaten, alle Schemas und alle Statistiken f\u00fcr alle Indizes kopiert. Deswegen, ist die Datenbank leer und ist im Read-Only Modus.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10223 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase02.png\" alt=\"Clonedatabase02\" width=\"794\" height=\"465\" \/><\/a><\/p>\n<p>Die Schemas sind kopiert\u2026 Ok, ich werde jetzt mit SQL Server Data Tools (SSDT) ein \u00abSchemavergleich\u00bb durchf\u00fchren:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10224 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase03.png\" alt=\"Clonedatabase03\" width=\"981\" height=\"617\" \/><\/a><\/p>\n<p>Alle Schemas sind in der geklonten Databank. Die \u00c4nderungen sind f\u00fcr den Fulltext und die Daten im XML Schema, wie zum Beispiel der MileRangeType mit seiner Bedeutung.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10225 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase04.png\" alt=\"Clonedatabase04\" width=\"760\" height=\"567\" \/><\/a><\/p>\n<p>Ich habe mit meinem Freund Michel \u00fcber diese Funktionalit\u00e4t gesprochen und er hat mir gefragt wie verhaltet es sich mit den Daten?<br \/>\nMein erster Schritt ist es die Betrachtung der Dateistruktur nach dem Klonen :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10226 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase05.png\" alt=\"Clonedatabase05\" width=\"1051\" height=\"515\" \/><\/a><br \/>\nSie k\u00f6nnen feststellen, dass meine geklonte Datenbank weder die Benutzerdatenbank noch die Modeldatenbank \u00fcbernommen hat.<br \/>\nIch richte eine neue Filegroup [FG_Employees] ein, mit ein neue File AdventureWorks2014_Employees.ndf<br \/>\nIch \u00e4ndere mein Clustered Indize PK_Employee_BusinessEntityID zu dieser neuen Filegroup:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [master]\nGO\nALTER DATABASE [AdventureWorks2014] ADD FILEGROUP [FG_Employees]\nGO\nALTER DATABASE [AdventureWorks2014]\nADD FILE ( NAME = N'AdventureWorks2014_Employees',\nFILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL12.TEST\\MSSQL\\DATA\\AdventureWorks2014_Employees.ndf'\n, SIZE = 16384KB , FILEGROWTH = 8192KB ) TO FILEGROUP [FG_Employees]\nGO\nUSE [AdventureWorks2014];\nGO\nCREATE UNIQUE CLUSTERED INDEX PK_Employee_BusinessEntityID\n    ON HumanResources.Employee(BusinessEntityID)\nWITH (DROP_EXISTING =  ON )\nON [FG_Employees]<\/pre>\n<p>Und jetzt, klone ich wieder meine Datenbank:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10227 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase06.png\" alt=\"Clonedatabase06\" width=\"1291\" height=\"563\" \/><\/a><br \/>\nDie Dateistruktur ist kopiert, cool!<br \/>\nKann ich die Datenbank auf Read-Only \u00e4ndern und Datei importieren?<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [master]\nGO\nALTER DATABASE [AdventureWorks2014_clone] SET  READ_WRITE WITH NO_WAIT\nGO\nINSERT INTO [AdventureWorks2014_clone].[Sales].[Currency]\nSELECT *  FROM [AdventureWorks2014].[Sales].[Currency]<\/pre>\n<p>Kein Problem, die Daten sind direkt kopiert.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-10228 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase07.png\" alt=\"Clonedatabase07\" width=\"545\" height=\"268\" \/><\/a><\/p>\n<p>Diese neue Funktionalit\u00e4t ist wirklich einfach zu verwenden.<br \/>\nIch hoffen dass im n\u00e4chsten Service Pack von SQL Server 2012 und SQL Server 2016 die CLONEDATABASE Funktion auch integriert wird. F\u00fcr mehr Information, MSDN link<a title=\"https:\/\/support.microsoft.com\/de-de\/kb\/3177838\" href=\"https:\/\/support.microsoft.com\/de-de\/kb\/3177838\" target=\"_blank\"> hier<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. \u201eDBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen zu untersuchen.\u201c MSDN Quelle finden wir hier. Dieser Befehl kann nur Benutzedatenbanken klonen. Wie Sie [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":8723,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,48],"tags":[897,49,51,52],"type_dbi":[],"class_list":["post-8715","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-technology-survey","tag-clo","tag-microsoft","tag-sql-server","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE - dbi Blog<\/title>\n<meta name=\"description\" content=\"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE\" \/>\n<meta property=\"og:description\" content=\"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-19T05:52:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"759\" \/>\n\t<meta property=\"og:image:height\" content=\"495\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE\",\"datePublished\":\"2016-08-19T05:52:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/\"},\"wordCount\":311,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Clonedatabase01-1.png\",\"keywords\":[\"clo\",\"Microsoft\",\"SQL Server\",\"SQL Server 2014\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/\",\"name\":\"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Clonedatabase01-1.png\",\"datePublished\":\"2016-08-19T05:52:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Clonedatabase01-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Clonedatabase01-1.png\",\"width\":759,\"height\":495},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE - dbi Blog","description":"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.","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.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/","og_locale":"en_US","og_type":"article","og_title":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE","og_description":"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.","og_url":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/","og_site_name":"dbi Blog","article_published_time":"2016-08-19T05:52:29+00:00","og_image":[{"width":759,"height":495,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE","datePublished":"2016-08-19T05:52:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/"},"wordCount":311,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png","keywords":["clo","Microsoft","SQL Server","SQL Server 2014"],"articleSection":["Database Administration &amp; Monitoring","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/","url":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/","name":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png","datePublished":"2016-08-19T05:52:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: DBCC CLONEDATABASE.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Clonedatabase01-1.png","width":759,"height":495},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/neue-datenbank-konsole-befehle-dbcc-clonedatabase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8715"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8715\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8723"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8715"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}