{"id":2448,"date":"2018-09-01T13:52:06","date_gmt":"2018-09-01T13:52:06","guid":{"rendered":"http:\/\/dbtut.com\/?p=2448"},"modified":"2019-03-21T20:44:43","modified_gmt":"2019-03-21T20:44:43","slug":"how-to-detach-and-attach-a-database-containing-filestream-data","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/","title":{"rendered":"How To Detach and Attach a Database Containing FileStream Data"},"content":{"rendered":"<p>You may want to move a database containing &#8220;File Stream&#8221; data to another disk with the detach attach method.<\/p>\n<p>Moving a database containing &#8220;File Stream&#8221; data with the detach attach method is slightly different from the normal detach attach method.<\/p>\n<p>In the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/02\/how-to-change-the-disk-of-database-files-on-sql-serverdetach-attach-backup-restore-methods\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Change The Disk Files On Database Files<\/a>&#8220;, I explained the process of changing the database&#8217;s disks with the detach attach method.<\/p>\n<p>In this article we will also do this for databases that contain file stream data.<\/p>\n<p>Before reading this article, I recommend you read the article titled &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/11\/what-is-file-stream-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is File Stream in SQL Server<\/a>&#8220;.<\/p>\n<p>In some cases, there may not be space on the discs where the database files are located.<\/p>\n<p>For this reason, you may need to transfer some or all of the database files to other disks.<\/p>\n<p>There are several ways to do this. We will talk about the two most commonly used ways in this article.<\/p>\n<p>Before you do detach, you need to save the result of the following script in order to save database file&#8217;s paths.<\/p>\n<pre class=\"lang:default decode:true\">use FileStreamDB\nGO\nselect * from sys.database_files<\/pre>\n<p>As shown in the following figure, right click on the database and select detach from the task tab to disconnect the database from the sql server first.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/557.png\" width=\"538\" height=\"408\" \/><\/p>\n<p>If we click on the Detach tab and there is a connection on the database, we need to select Drop Connections as below so that these connections are terminated before detach.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/983.png\" width=\"581\" height=\"516\" \/><\/p>\n<p>If detach is not performed again, you should run the above script by clicking on the Script and adding the following script to the top of the script created by SQL Server.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE [AdventureWorks2012] SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/pre>\n<p>Before detach, you need to make sure that there are no requests for the application.<\/p>\n<p>The best way to be sure of this is to discuss with application developers, ask them to stop the application, and then disable Login.<\/p>\n<p>From the Security-&gt; Logins tab of SQL Server Management Studio, right-click the login using the application and select Properties.<\/p>\n<p>Then from the pop-up, we select Disabled from the Status tab as shown below and press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/181.png\" width=\"623\" height=\"556\" \/><\/p>\n<p>After the detach process is finished, you need to move the database files using the copy paste method.<\/p>\n<p>If we want to attach in normal ways after the move is finished, we will get an error like below.<\/p>\n<p>Because when we want to Attach on SSMS, the FileStream data does not appear.<\/p>\n<p><em>Msg 5120, Level 16, State 105, Line 3<\/em><\/p>\n<p><span style=\"color: #ff0000;\"><em>Unable to open the physical file &#8220;C:\\MSSQL\\FileStreamVeri&#8221;. Operating system error 2: &#8220;2(The system can not find the specified file.)&#8221;.<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 5105, Level 16, State 14, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>A file activation error occurred. The physical file name &#8216;C:\\MSSQL\\FileStreamVeri&#8217; may be incorrect. Diagnose and correct additional errors, and retry the operation.<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 1813, Level 16, State 2, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Could not open new database &#8216;FileStreamDB&#8217;. CREATE DATABASE is aborted.<\/em><\/span><\/p>\n<p>Therefore, we need to perform this operation with the help of the following script.<\/p>\n<p>In our example, we moved the filestream data from the &#8220;C:\\MSSQL&#8221; folder to the &#8220;C:\\MSSQL\\FileStreamUpdate&#8221; folder and later attached it.<\/p>\n<pre class=\"lang:default decode:true\">USE [master]\nGO\nCREATE DATABASE [FileStreamDB] ON\n( FILENAME = N'C:\\MSSQL\\FileStreamDB.mdf' ),\n( FILENAME = N'C:\\MSSQL\\FileStreamDB_log.ldf' ),\n( FILENAME = N'C:\\MSSQL\\FileStreamYeni\\FileStreamVeri')\n\u00a0FOR ATTACH\nGO\n<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2448\" class=\"pvc_stats all  \" data-element-id=\"2448\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>You may want to move a database containing &#8220;File Stream&#8221; data to another disk with the detach attach method. Moving a database containing &#8220;File Stream&#8221; data with the detach attach method is slightly different from the normal detach attach method. In the article titled &#8220;How To Change The Disk Files On Database Files&#8220;, I explained &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2448\" class=\"pvc_stats all  \" data-element-id=\"2448\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":10870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1524],"tags":[2687,2683,2684,2686,2685],"class_list":["post-2448","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","category-windows","tag-a-file-activation-error-occurred","tag-attach-database-with-filestream","tag-detach-and-attach-database-with-filestream","tag-the-system-can-not-find-the-specified-file","tag-unable-to-open-the-physical-file"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":1699,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Detach and Attach a Database Containing FileStream Data - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Detach and Attach a Database Containing FileStream Data\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Detach and Attach a Database Containing FileStream Data - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Detach and Attach a Database Containing FileStream Data\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-01T13:52:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-21T20:44:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png\" \/>\n\t<meta property=\"og:image:width\" content=\"639\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Detach and Attach a Database Containing FileStream Data\",\"datePublished\":\"2018-09-01T13:52:06+00:00\",\"dateModified\":\"2019-03-21T20:44:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\"},\"wordCount\":510,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png\",\"keywords\":[\"A file activation error occurred\",\"attach database with filestream\",\"detach and attach database with filestream\",\"The system can not find the specified file\",\"Unable to open the physical file\"],\"articleSection\":[\"MSSQL\",\"Windows\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\",\"name\":\"How To Detach and Attach a Database Containing FileStream Data - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png\",\"datePublished\":\"2018-09-01T13:52:06+00:00\",\"dateModified\":\"2019-03-21T20:44:43+00:00\",\"description\":\"How To Detach and Attach a Database Containing FileStream Data\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png\",\"width\":639,\"height\":346},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Detach and Attach a Database Containing FileStream Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Detach and Attach a Database Containing FileStream Data - Database Tutorials","description":"How To Detach and Attach a Database Containing FileStream Data","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:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/","og_locale":"en_US","og_type":"article","og_title":"How To Detach and Attach a Database Containing FileStream Data - Database Tutorials","og_description":"How To Detach and Attach a Database Containing FileStream Data","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-01T13:52:06+00:00","article_modified_time":"2019-03-21T20:44:43+00:00","og_image":[{"width":639,"height":346,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Detach and Attach a Database Containing FileStream Data","datePublished":"2018-09-01T13:52:06+00:00","dateModified":"2019-03-21T20:44:43+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/"},"wordCount":510,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png","keywords":["A file activation error occurred","attach database with filestream","detach and attach database with filestream","The system can not find the specified file","Unable to open the physical file"],"articleSection":["MSSQL","Windows"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/","name":"How To Detach and Attach a Database Containing FileStream Data - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png","datePublished":"2018-09-01T13:52:06+00:00","dateModified":"2019-03-21T20:44:43+00:00","description":"How To Detach and Attach a Database Containing FileStream Data","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/Ads\u0131z.png","width":639,"height":346},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Detach and Attach a Database Containing FileStream Data"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2448"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2448\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/10870"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}