{"id":62,"date":"2009-08-21T18:07:00","date_gmt":"2009-08-21T16:07:00","guid":{"rendered":"\/post\/Attach-edilen-veritabanlarc4b1nda-kullanc4b1cc4b1larc4b1-eslestirmek.aspx"},"modified":"2009-08-21T18:07:00","modified_gmt":"2009-08-21T16:07:00","slug":"attach-edilen-veritabanlarinda-kullanicilari-eslestirmek","status":"publish","type":"post","link":"https:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/","title":{"rendered":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek"},"content":{"rendered":"<p>&nbsp; MSSql veritabanlar\u0131 ile u\u011fra\u015f\u0131rken yedek alma i\u015flemi zaman zaman s\u0131k\u0131nt\u0131l\u0131 olabiliyor. Benim yedek alma konusunda tercihim, e\u011fer sunucuya do\u011frudan ula\u015fabiliyorsam veri dosyalar\u0131n\u0131 direkt olarak kopyalamakt\u0131r. Tabi ki bunu yapmak i\u00e7in \u00f6ncelikle veritaban\u0131n\u0131n kullan\u0131mda olmamas\u0131 bir \u00f6n ko\u015ful.<\/p>\n\n\n\n<p>&nbsp;&nbsp; Bu y\u00f6ntemle gayet kolay ve h\u0131zl\u0131 olarak yedek almak m\u00fcmk\u00fcn; fakat i\u015f bu yede\u011fi veritaban\u0131na yeniden ekleme (attach etmek) noktas\u0131na geldi\u011finizde eminim ki kullan\u0131c\u0131 yetkileri ile ilgili olarak bir s\u0131k\u0131nt\u0131 oldu\u011funu farkedeceksiniz. Farkl\u0131 bir veritaban\u0131 sunucusunda eski sunucunuzdaki ile ayn\u0131 isimlerle kullan\u0131c\u0131lar a\u00e7san\u0131z bile attach edilen veritaban\u0131nda bu iki kullan\u0131c\u0131 farkl\u0131 olarak g\u00f6r\u00fclecektir; ama \u00fcz\u00fclmeyin, \u00e7\u00f6z\u00fcm\u00fc basit&#8230;<\/p>\n\n\n\n<p>&nbsp;&nbsp; Yapman\u0131z gereken a\u015fa\u011f\u0131daki tsql&#8217;leri e\u015fle\u015ftirmek istedi\u011finiz kullan\u0131c\u0131 isimiyle \u00fczerinde \u00e7al\u0131\u015ft\u0131rmak:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">USE &lt;veritaban\u0131 ad\u0131>\nGO\nEXEC sp_change_users_login 'update_one', '&lt;kullan\u0131c\u0131 ad\u0131>', '&lt;kullan\u0131c\u0131 ad\u0131>'\nGO<\/pre>\n\n\n\n<p>Burada &#8220;&lt;veritaban\u0131 ad\u0131&gt;&#8221;&nbsp; alan\u0131na i\u015flemin ger\u00e7ekle\u015fece\u011fi veritaban\u0131, &#8220;&lt;kullan\u0131c\u0131 ad\u0131&gt;&#8221; alan\u0131na ise e\u015fle\u015ftirmek istedi\u011finiz kullan\u0131c\u0131 ad\u0131n\u0131 yazman\u0131z gerekli.<\/p>","protected":false},"excerpt":{"rendered":"<p>&nbsp; MSSql veritabanlar\u0131 ile u\u011fra\u015f\u0131rken yedek alma i\u015flemi zaman zaman s\u0131k\u0131nt\u0131l\u0131 olabiliyor. Benim yedek alma konusunda tercihim, e\u011fer sunucuya do\u011frudan ula\u015fabiliyorsam veri dosyalar\u0131n\u0131 direkt olarak kopyalamakt\u0131r. Tabi ki bunu yapmak i\u00e7in \u00f6ncelikle veritaban\u0131n\u0131n kullan\u0131mda olmamas\u0131 bir \u00f6n ko\u015ful. &nbsp;&nbsp; Bu y\u00f6ntemle gayet kolay ve h\u0131zl\u0131 olarak yedek almak m\u00fcmk\u00fcn; fakat i\u015f bu yede\u011fi veritaban\u0131na yeniden&#8230;<\/p>\n<p><a class=\"read-more\" href=\"https:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\">Read More<\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[88],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-turkce","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy<\/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:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy\" \/>\n<meta property=\"og:description\" content=\"&nbsp; MSSql veritabanlar\u0131 ile u\u011fra\u015f\u0131rken yedek alma i\u015flemi zaman zaman s\u0131k\u0131nt\u0131l\u0131 olabiliyor. Benim yedek alma konusunda tercihim, e\u011fer sunucuya do\u011frudan ula\u015fabiliyorsam veri dosyalar\u0131n\u0131 direkt olarak kopyalamakt\u0131r. Tabi ki bunu yapmak i\u00e7in \u00f6ncelikle veritaban\u0131n\u0131n kullan\u0131mda olmamas\u0131 bir \u00f6n ko\u015ful. &nbsp;&nbsp; Bu y\u00f6ntemle gayet kolay ve h\u0131zl\u0131 olarak yedek almak m\u00fcmk\u00fcn; fakat i\u015f bu yede\u011fi veritaban\u0131na yeniden...Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\" \/>\n<meta property=\"og:site_name\" content=\"Fatih Boy\" \/>\n<meta property=\"article:published_time\" content=\"2009-08-21T16:07:00+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Boy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Boy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\"},\"author\":{\"name\":\"Fatih Boy\",\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158\"},\"headline\":\"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek\",\"datePublished\":\"2009-08-21T16:07:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\"},\"wordCount\":202,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158\"},\"keywords\":[\"SQL Server\"],\"articleSection\":[\"T\u00fcrk\u00e7e\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\",\"url\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\",\"name\":\"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy\",\"isPartOf\":{\"@id\":\"https:\/\/fatihboy.com\/#website\"},\"datePublished\":\"2009-08-21T16:07:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fatihboy.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihboy.com\/#website\",\"url\":\"https:\/\/fatihboy.com\/\",\"name\":\"Fatih Boy\",\"description\":\"Ki\u015fisel Web Sitesi\",\"publisher\":{\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihboy.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158\",\"name\":\"Fatih Boy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5b3de123ad95a2ffe30b75a54cee98b55f65185c6d6805b35088a3d945f2feb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5b3de123ad95a2ffe30b75a54cee98b55f65185c6d6805b35088a3d945f2feb4?s=96&d=mm&r=g\",\"caption\":\"Fatih Boy\"},\"logo\":{\"@id\":\"https:\/\/fatihboy.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/fatihboy.com\"],\"url\":\"https:\/\/fatihboy.com\/en\/author\/fatih\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy","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:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/","og_locale":"en_US","og_type":"article","og_title":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy","og_description":"&nbsp; MSSql veritabanlar\u0131 ile u\u011fra\u015f\u0131rken yedek alma i\u015flemi zaman zaman s\u0131k\u0131nt\u0131l\u0131 olabiliyor. Benim yedek alma konusunda tercihim, e\u011fer sunucuya do\u011frudan ula\u015fabiliyorsam veri dosyalar\u0131n\u0131 direkt olarak kopyalamakt\u0131r. Tabi ki bunu yapmak i\u00e7in \u00f6ncelikle veritaban\u0131n\u0131n kullan\u0131mda olmamas\u0131 bir \u00f6n ko\u015ful. &nbsp;&nbsp; Bu y\u00f6ntemle gayet kolay ve h\u0131zl\u0131 olarak yedek almak m\u00fcmk\u00fcn; fakat i\u015f bu yede\u011fi veritaban\u0131na yeniden...Read More","og_url":"https:\/\/fatihboy.com\/en\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/","og_site_name":"Fatih Boy","article_published_time":"2009-08-21T16:07:00+00:00","author":"Fatih Boy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Fatih Boy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#article","isPartOf":{"@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/"},"author":{"name":"Fatih Boy","@id":"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158"},"headline":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek","datePublished":"2009-08-21T16:07:00+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/"},"wordCount":202,"commentCount":0,"publisher":{"@id":"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158"},"keywords":["SQL Server"],"articleSection":["T\u00fcrk\u00e7e"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/","url":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/","name":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek - Fatih Boy","isPartOf":{"@id":"https:\/\/fatihboy.com\/#website"},"datePublished":"2009-08-21T16:07:00+00:00","breadcrumb":{"@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihboy.com\/attach-edilen-veritabanlarinda-kullanicilari-eslestirmek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fatihboy.com\/"},{"@type":"ListItem","position":2,"name":"Attach edilen veritabanlar\u0131nda kullan\u0131c\u0131lar\u0131 e\u015fle\u015ftirmek"}]},{"@type":"WebSite","@id":"https:\/\/fatihboy.com\/#website","url":"https:\/\/fatihboy.com\/","name":"Fatih Boy","description":"Ki\u015fisel Web Sitesi","publisher":{"@id":"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihboy.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihboy.com\/#\/schema\/person\/6b06a41d42eed36eaa0780fbeb774158","name":"Fatih Boy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fatihboy.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5b3de123ad95a2ffe30b75a54cee98b55f65185c6d6805b35088a3d945f2feb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5b3de123ad95a2ffe30b75a54cee98b55f65185c6d6805b35088a3d945f2feb4?s=96&d=mm&r=g","caption":"Fatih Boy"},"logo":{"@id":"https:\/\/fatihboy.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/fatihboy.com"],"url":"https:\/\/fatihboy.com\/en\/author\/fatih\/"}]}},"brizy_media":[],"_links":{"self":[{"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":0,"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihboy.com\/en\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}