{"id":706,"date":"2015-04-06T15:21:14","date_gmt":"2015-04-06T13:21:14","guid":{"rendered":"http:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/"},"modified":"2021-12-18T13:30:49","modified_gmt":"2021-12-18T11:30:49","slug":"database-limitleri","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/","title":{"rendered":"Database Limitleri"},"content":{"rendered":"<p>WinTr Scada SQL Server&#8217;\u0131n t\u00fcm versiyonlar\u0131n\u0131 destekler. WinTr ilk \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda SQL server WINTR instance name ile kurulu de\u011filse, kurulum i\u00e7in sizden izin ister. Kurulum ba\u015flamadan \u00f6nce SQL Server 2005 veya 2014 versiyonlar\u0131ndan birini se\u00e7menizi ister. Se\u00e7imin ard\u0131ndan gerekli dosyalar\u0131 internetten indirip kurulumu ba\u015flat\u0131r.<\/p>\n<p>\u0130nternetden indirme esnas\u0131nda problem olu\u015fursa, internet browser sayfas\u0131nda indirilecek dosyay\u0131 a\u00e7ar. Bu dosyay\u0131 geni\u015fletmeden oldu\u011fu gibi program files i\u00e7ersinde Fultek\\Wintr\\Bin\\ klas\u00f6r\u00fcn\u00fcn i\u00e7ine kopyalamal\u0131s\u0131n\u0131z. WinTr tekrar \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda internetden indirmeden kurulum yap\u0131lacakt\u0131r.<\/p>\n<p>WinTr Sql Server Express versiyonunu kullan\u0131r. Express versiyonu 2005 her database 4 GB ile s\u0131n\u0131rl\u0131d\u0131r. 2014&#8217;de ise limit 10 GB&#8217;d\u0131r. Daha fazla depolama alan\u0131na ihtiyac\u0131n\u0131z olursa SQL server lisans\u0131 sat\u0131n almal\u0131s\u0131n\u0131z.<\/p>\n<p>Projenizin ihtiya\u00e7 duydu\u011fu Db alan\u0131n\u0131 yakla\u015f\u0131k olarak hesaplayabiliriz. E\u011fer projeniz bu hesaplanan de\u011ferden daha fazla Db alan\u0131 kullan\u0131yorsa yolunda gitmeyen bir \u015feyler var demektir. Database log dosyas\u0131na bakabilirsiniz. Db dosyalar\u0131 bu adreste bulunur. &#8220;C:\\Program Files\\Microsoft SQL Server\\MSSQL12.WINTR\\MSSQL\\DATA&#8221; bu dosyalr kopyalanarak yedek al\u0131nmaz.<\/p>\n<p>Database boyutu hesaplama:<\/p>\n<p>Tag say\u0131s\u0131 X byte say\u0131s\u0131 X 2,2 X Kay\u0131t sat\u0131r say\u0131s\u0131 = Top.Byte<\/p>\n<p>53 Tag X 2 Byte(16 bit lik Taglar i\u00e7in) \u00a0X 2,2 (Sabit) X 1951050 = 454.989.860\u00a0Byte \/ 1024 \/ 1024 = 433 MB.<\/p>\n<p>Projenizin kulland\u0131\u011f\u0131 db alan\u0131n\u0131 WinTr scada kontrol panelinden g\u00f6rebilirsiniz. Database Listing butonuna basman\u0131z yeterlidir.<\/p>\n<p><a href=\"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-708\" src=\"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png\" alt=\"DbSize\" width=\"300\" height=\"207\" srcset=\"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png 300w, https:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize.png 764w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WinTr Scada SQL Server&#8217;\u0131n t\u00fcm versiyonlar\u0131n\u0131 destekler. WinTr ilk \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda SQL server WINTR instance name ile kurulu de\u011filse, kurulum i\u00e7in sizden izin ister. Kurulum ba\u015flamadan \u00f6nce SQL Server 2005 veya 2014 versiyonlar\u0131ndan birini se\u00e7menizi ister. Se\u00e7imin ard\u0131ndan gerekli dosyalar\u0131 internetten indirip kurulumu ba\u015flat\u0131r. \u0130nternetden indirme esnas\u0131nda problem olu\u015fursa, internet browser sayfas\u0131nda indirilecek dosyay\u0131 a\u00e7ar. Bu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[293],"class_list":["post-706","post","type-post","status-publish","format-standard","hentry","category-scada-sql-server","tag-sql-server-limitleri"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database Limitleri - SCADA E\u011fitim Sitesi<\/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:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salih\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Database Limitleri\",\"datePublished\":\"2015-04-06T13:21:14+00:00\",\"dateModified\":\"2021-12-18T11:30:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/\"},\"wordCount\":259,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/DbSize-300x207.png\",\"keywords\":[\"SQL Server Limitleri\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/\",\"name\":\"Database Limitleri - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/DbSize-300x207.png\",\"datePublished\":\"2015-04-06T13:21:14+00:00\",\"dateModified\":\"2021-12-18T11:30:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/DbSize-300x207.png\",\"contentUrl\":\"http:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/DbSize-300x207.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2015\\\/04\\\/database-limitleri\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Limitleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\",\"name\":\"SCADA E\u011fitim Sitesi\",\"description\":\"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\",\"name\":\"Salih\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"caption\":\"Salih\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Limitleri - SCADA E\u011fitim Sitesi","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.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Database Limitleri","datePublished":"2015-04-06T13:21:14+00:00","dateModified":"2021-12-18T11:30:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/"},"wordCount":259,"commentCount":2,"image":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png","keywords":["SQL Server Limitleri"],"articleSection":["SQL Server"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/","name":"Database Limitleri - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#primaryimage"},"image":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png","datePublished":"2015-04-06T13:21:14+00:00","dateModified":"2021-12-18T11:30:49+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#primaryimage","url":"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png","contentUrl":"http:\/\/www.fultek.com.tr\/scada-yardim\/wp-content\/uploads\/2015\/04\/DbSize-300x207.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2015\/04\/database-limitleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Database Limitleri"}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/","name":"SCADA E\u011fitim Sitesi","description":"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/scada-yardim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be","name":"Salih","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","caption":"Salih"},"sameAs":["http:\/\/www.fultek.com.tr"],"url":"https:\/\/www.fultek.com.tr\/scada-yardim\/author\/salih\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/comments?post=706"}],"version-history":[{"count":4,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/706\/revisions"}],"predecessor-version":[{"id":711,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/706\/revisions\/711"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}