{"id":746,"date":"2014-09-02T13:47:14","date_gmt":"2014-09-02T11:47:14","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=746"},"modified":"2014-09-02T13:47:14","modified_gmt":"2014-09-02T11:47:14","slug":"exclusive-access-could-not-be-obtained-because-the-database-is-in-use-hatasi","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2014\/09\/exclusive-access-could-not-be-obtained-because-the-database-is-in-use-hatasi\/","title":{"rendered":"Exclusive access could not be obtained because the database is in use hatas\u0131"},"content":{"rendered":"<p>Veritaban\u0131n\u0131z\u0131 restore etmeye \u00e7al\u0131\u015f\u0131rken bu hatay\u0131 alabilirsiniz , sebebi veritaban\u0131n\u0131n o anda aktif olarak kullan\u0131lmas\u0131d\u0131r.<\/p>\n<p>Hatay\u0131 gidermek i\u00e7in <strong>Mssql Server Management Studio<\/strong> da <strong>Activity Monitor<\/strong> \u00fc a\u00e7\u0131n\u0131z.<\/p>\n<figure id=\"attachment_747\" aria-describedby=\"caption-attachment-747\" style=\"width: 231px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-activity-monitor.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-747\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-activity-monitor.jpg\" alt=\"mssql -activity-monitor\" width=\"231\" height=\"450\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-activity-monitor.jpg 231w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-activity-monitor-154x300.jpg 154w\" sizes=\"auto, (max-width: 231px) 100vw, 231px\" \/><\/a><figcaption id=\"caption-attachment-747\" class=\"wp-caption-text\">mssql -activity-monitor<\/figcaption><\/figure>\n<p>A\u00e7\u0131lan ekranda database kolonuna geliniz ve ilgili db yi se\u00e7iniz , hemen alt k\u0131s\u0131mda aktif ba\u011flant\u0131lar\u0131 g\u00f6receksiniz.<\/p>\n<p>Bunlar\u0131n \u00fczerine sa\u011f t\u0131klay\u0131p <strong>Kill Process<\/strong> e t\u0131klay\u0131n\u0131z , bu i\u015flemi bu db deki t\u00fcm aktif ba\u011flant\u0131lar i\u00e7in yap\u0131n\u0131z.<\/p>\n<figure id=\"attachment_748\" aria-describedby=\"caption-attachment-748\" style=\"width: 664px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-kill-process.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-748\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-kill-process.jpg\" alt=\"mssql-kill-process\" width=\"664\" height=\"449\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-kill-process.jpg 664w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2014\/09\/mssql-kill-process-300x202.jpg 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/a><figcaption id=\"caption-attachment-748\" class=\"wp-caption-text\">mssql-kill-process<\/figcaption><\/figure>\n<p>\u015eimdi restore i\u015flemini tekrar deneyebilirsiniz.<\/p>\n<p>Ayhan ARDA<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"Exclusive%20access%20could%20not%20be%20obtained%20because%20the%20database%20is%20in%20use%20hatas%C4%B1\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"Veritaban\u0131n\u0131z\u0131 restore etmeye \u00e7al\u0131\u015f\u0131rken bu hatay\u0131 alabilirsiniz , sebebi veritaban\u0131n\u0131n o anda aktif olarak kullan\u0131lmas\u0131d\u0131r. Hatay\u0131 gidermek i\u00e7in Mssql Server Management Studio da Activity Monitor \u00fc a\u00e7\u0131n\u0131z. A\u00e7\u0131lan ekranda database kolonuna geliniz ve ilgili db yi se\u00e7iniz , hemen alt k\u0131s\u0131mda aktif ba\u011flant\u0131lar\u0131 g\u00f6receksiniz. Bunlar\u0131n \u00fczerine sa\u011f t\u0131klay\u0131p Kill Process e t\u0131klay\u0131n\u0131z , bu i\u015flemi [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[482],"tags":[557,432,556,558,555],"class_list":["post-746","post","type-post","status-publish","format-standard","hentry","category-mssql-2","tag-exclusive-access","tag-mssql","tag-mssql-in-use","tag-mssql-kill","tag-mssql-restore"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=746"}],"version-history":[{"count":1,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/746\/revisions"}],"predecessor-version":[{"id":749,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/746\/revisions\/749"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}