{"id":1696,"date":"2016-12-05T17:34:37","date_gmt":"2016-12-05T14:34:37","guid":{"rendered":"https:\/\/www.ltr.com.tr\/?p=1696"},"modified":"2020-07-02T13:30:08","modified_gmt":"2020-07-02T10:30:08","slug":"sql-yedek-alma","status":"publish","type":"post","link":"https:\/\/www.ltr.com.tr\/?p=1696","title":{"rendered":"SQL Yedek alma"},"content":{"rendered":"<p>Pek \u00e7ok ki\u015fi taraf\u0131ndan ayn\u0131 soruya maruz kal\u0131yoruz.<\/p>\n<p>Kulland\u0131\u011f\u0131m\u0131z program\u0131n verileri MSSQL veritaban\u0131nda tutuluyor.Yedeklemesini kendimiz nas\u0131l yapabiliriz.<\/p>\n<p>\u00d6ncelikle belirtmek isterimki MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.MSSQL i\u00e7in bu SQL Management Studio ad\u0131yla ge\u00e7er.Kullan\u0131lan MSSQL versiyonuna ba\u011fl\u0131 olarak aray\u00fczde ufak tefek de\u011fi\u015fiklikler olabilir.Ancak genel olarak hepsinin aray\u00fcz k\u0131s\u0131mlar\u0131 ayn\u0131d\u0131r.<\/p>\n<p>Yedek almak i\u00e7in kullan\u0131labilecek 2 metoddan bahsedelim.<\/p>\n<h5><strong>1- SQL Management Studio kullanarak yedek almak<\/strong><\/h5>\n<p><a href=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1697\" src=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-300x160.png\" alt=\"sql\" width=\"720\" height=\"384\" srcset=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-300x160.png 300w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-768x410.png 768w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1024x547.png 1024w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-260x139.png 260w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-50x27.png 50w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-140x75.png 140w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql.png 1181w\" sizes=\"auto, (max-width:767px) 480px, 720px\" \/><\/a><\/p>\n<p>Bu ekranda sql kurulumu s\u0131ras\u0131nda belirledi\u011finiz kullan\u0131c\u0131 ve \u015fifreyle giri\u015f yaparak veritabanlar\u0131m\u0131zla ilgili i\u015flemleri yapt\u0131\u011f\u0131m\u0131z k\u0131sma ge\u00e7ebiliyoruz.<\/p>\n<p>Bu k\u0131s\u0131mda sol tarafta bulunan <strong>Databases<\/strong> ba\u015fl\u0131\u011f\u0131 alt\u0131ndan istedi\u011fimiz veritaban\u0131n\u0131 se\u00e7erek sa\u011f tu\u015f men\u00fcs\u00fcnde <strong>Task\u00a0<\/strong>alt\u0131nda <strong>Backup\u00a0<\/strong>k\u0131sm\u0131ndan yedekleme ayarlar\u0131n\u0131 yapt\u0131\u011f\u0131m\u0131z k\u0131s\u0131ma geliyoruz.<\/p>\n<p><a href=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1698\" src=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1-300x273.png\" alt=\"sql\" width=\"593\" height=\"540\" srcset=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1-300x273.png 300w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1-161x146.png 161w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1-50x45.png 50w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1-82x75.png 82w, https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png 684w\" sizes=\"auto, (max-width:767px) 480px, 593px\" \/><\/a><\/p>\n<p>A\u00e7\u0131lan \u00f6zellikler b\u00f6l\u00fcm\u00fcnde sa\u011f alt k\u0131s\u0131mda bulunan <strong>Add\u00a0<\/strong>tu\u015fuyla alaca\u011f\u0131m\u0131z yedek dosyas\u0131n\u0131n hangi klas\u00f6rde bulunaca\u011f\u0131n\u0131 belirliyoruz. ve sonras\u0131nda <strong>OK\u00a0<\/strong>tu\u015fu ile yedekleme i\u015flemimiz ba\u015fl\u0131yor.<\/p>\n<p>\u0130\u015flem tamamland\u0131\u011f\u0131nda size sonu\u00e7 bilgisi olarak i\u015flemin ba\u015far\u0131l\u0131 oldu\u011funu yada yapamad\u0131\u011f\u0131n\u0131 belirten bir bilgi kutusu \u00e7\u0131kacakt\u0131r.<\/p>\n<p>\u0130\u015flemin tamamlanamas\u0131 veritaban\u0131n\u0131z\u0131n bozulmu\u015f olmas\u0131,dosyalar\u0131n\u0131z\u0131n olmas\u0131 gereken yerde olmamas\u0131 gibi durumlar nedeniyle olabilir.<\/p>\n<h5><strong>2- Batch dosyas\u0131 yard\u0131m\u0131 ile yedek almak<\/strong><\/h5>\n<p>Bu y\u00f6ntem i\u00e7in iki farkl\u0131 dosyaya ihtiyac\u0131n\u0131z var.<\/p>\n<p>Batch dosyas\u0131 uzant\u0131s\u0131 .bat uzant\u0131s\u0131na sahip olurlar.\u00c7al\u0131\u015ft\u0131r\u0131ld\u0131klar\u0131 ama\u00e7 do\u011frultusunda bilgisayar\u0131n komut sat\u0131r\u0131 \u00f6zelli\u011fini kullanarak i\u015flemleri ger\u00e7ekle\u015ftirirler.Bizim durumumuzda bu dosyay\u0131 di\u011fer dosyam\u0131z\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in kullanaca\u011f\u0131z.<\/p>\n<p>Yedekleme i\u015flemini yapt\u0131raca\u011f\u0131n\u0131z klas\u00f6rde bir metin dosyas\u0131(txt) olu\u015fturup ad\u0131n\u0131 diledi\u011finiz \u015fekilde de\u011fi\u015ftirebilirsiniz.ancak olu\u015fturdu\u011funuz bu yeni metin dosyas\u0131n\u0131n ad\u0131 Yeni Metin Belgesi.txt \u015feklinde olabilir.Bu durumda <strong>.txt<\/strong> k\u0131sm\u0131 yerine <strong>.bat\u00a0<\/strong>yazarak dosyas\u0131n\u0131z\u0131 kaydedebilirsiniz.Sonras\u0131nda bu dosyay\u0131 bir not defteri veya i\u00e7erisine bilgi yazabilece\u011fimiz herhangi bir \u015fekilde a\u00e7arak a\u015fa\u011f\u0131da belirtti\u011fim kriterlerin sizin bilgisayar\u0131n\u0131za uygun halini yazabilirsiniz.<\/p>\n<p>&#8220;C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\Sqlcmd.exe&#8221; -S SERVERADI\\INSTANCEADI -U VER\u0130TABANIER\u0130\u015e\u0130MKULLANICIADI\u00a0-P VERITABANIER\u0130\u015e\u0130M\u015e\u0130FRES\u0130\u00a0-i C:\\YEDEKDOSYANIZINADI.sql<\/p>\n<p>ilk k\u0131s\u0131mda yer alan sqlcmd.exe dosyas\u0131 kulland\u0131\u011f\u0131n\u0131z MSSQL versiyonuna g\u00f6re farkl\u0131 dizinlerde olabilir.siz kendi bilgisayar\u0131n\u0131zda ilgili yerdeki sqlcmd.exe dosyas\u0131n\u0131 bulun ve buraya yolunu yaz\u0131n.<\/p>\n<p>SERVERADI\\INSTANCEADI k\u0131sm\u0131 sizin bilgisayar\u0131n\u0131za kurarken sql server\u0131n \u00f6zellikleri k\u0131sm\u0131nda belirtti\u011finiz \u015fekildedir.<\/p>\n<p>Instance ad\u0131 zorunlu bir bilgi de\u011fildir.olmamas\u0131 ko\u015fuluyla sadece SERVERADI bilgisi ile de yedekleme i\u015flemini ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<p>Bu dosyay\u0131 d\u00fczenledikten sonra yeni bir txt dosyas\u0131 a\u00e7arak bu dosyayada batch dosyas\u0131n\u0131zla kar\u0131\u015ft\u0131rmayaca\u011f\u0131n\u0131z bir isim vererek uzant\u0131s\u0131n\u0131 <strong>.txt\u00a0<\/strong>&#8216;den\u00a0<strong>.sql<\/strong> &#8216;e \u00e7evirin.<\/p>\n<p>Dosyan\u0131z\u0131n i\u00e7ine a\u015fa\u011f\u0131daki komutun sizin i\u00e7in ge\u00e7erli olan versiyonunu yaz\u0131n.<\/p>\n<p>BACKUP DATABASE [veritaban\u0131n\u0131z\u0131nad\u0131] TO DISK = N&#8217;D:\\yedekalmakistedi\u011finizyer.bak&#8217; WITH NOFORMAT, INIT, NAME = N&#8217;veritaban\u0131n\u0131z\u0131nad\u0131-Full Database Backup&#8217;, SKIP, NOREWIND, NOUNLOAD, STATS = 10<br \/>\nGO<\/p>\n<h5><strong>3- SQLCMD ile yedek almak<\/strong><\/h5>\n<p>Burda da \u00e7ok farkl\u0131 bir i\u015flem bulunmamakta.\u00d6ncelike bir batch dosyas\u0131 olu\u015fturup a\u015fa\u011f\u0131daki \u00f6rne\u011fin kendi bilgisayar\u0131n\u0131za uygun halini yaz\u0131p kaydederek \u00e7al\u0131\u015ft\u0131rabilirsiniz.<\/p>\n<p>SqlCmd -E -S SERVERADI\u00a0\u2013Q \u201cBACKUP DATABASE [VER\u0130TABANIADI] TO DISK=\u2019C:YEDEKALMAKISTEDI\u011eINIZYER[veritaban\u0131ad\u0131].bak&#8217;\u201d<\/p>\n<p>Herkese verilerini kaybetmeden \u00e7al\u0131\u015fmalar\u0131n\u0131za devam edebildi\u011finiz bir g\u00fcn dileriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pek \u00e7ok ki\u015fi taraf\u0131ndan ayn\u0131 soruya maruz kal\u0131yoruz. Kulland\u0131\u011f\u0131m\u0131z program\u0131n verileri MSSQL veritaban\u0131nda tutuluyor.Yedeklemesini kendimiz nas\u0131l yapabiliriz. \u00d6ncelikle belirtmek isterimki MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":3,"featured_media":1698,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,34],"tags":[42,48,44,43,45,41,47,46,49,40],"class_list":["post-1696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-logo-yazilim","category-yazilim","tag-batch-yedek","tag-hizli-yedek-alma","tag-logo-yedek","tag-mssql-yedek","tag-sql-management-studio-yedek","tag-sql-yedek","tag-sqlcmd-yedek","tag-ssms-yedek","tag-veritabani-yedekleme","tag-yedekleme"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Yedek alma - LTR Bilgi Teknolojileri<\/title>\n<meta name=\"description\" content=\"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.\" \/>\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.ltr.com.tr\/?p=1696\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Yedek alma - LTR Bilgi Teknolojileri\" \/>\n<meta property=\"og:description\" content=\"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ltr.com.tr\/?p=1696\" \/>\n<meta property=\"og:site_name\" content=\"LTR Bilgi Teknolojileri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ltrcom\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-05T14:34:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-02T10:30:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"684\" \/>\n\t<meta property=\"og:image:height\" content=\"622\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Levent Kubilay\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ltrtek\" \/>\n<meta name=\"twitter:site\" content=\"@ltrtek\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Levent Kubilay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696\"},\"author\":{\"name\":\"Levent Kubilay\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/person\\\/776594bf41382c96cd738771c19be481\"},\"headline\":\"SQL Yedek alma\",\"datePublished\":\"2016-12-05T14:34:37+00:00\",\"dateModified\":\"2020-07-02T10:30:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696\"},\"wordCount\":669,\"publisher\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/sql-1.png\",\"keywords\":[\"batch yedek\",\"h\u0131zl\u0131 yedek alma\",\"logo yedek\",\"mssql yedek\",\"sql management studio yedek\",\"sql yedek\",\"sqlcmd yedek\",\"ssms yedek\",\"veritaban\u0131 yedekleme\",\"yedekleme\"],\"articleSection\":[\"Logo Yaz\u0131l\u0131m\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696\",\"name\":\"SQL Yedek alma - LTR Bilgi Teknolojileri\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/sql-1.png\",\"datePublished\":\"2016-12-05T14:34:37+00:00\",\"dateModified\":\"2020-07-02T10:30:08+00:00\",\"description\":\"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#primaryimage\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/sql-1.png\",\"contentUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/sql-1.png\",\"width\":684,\"height\":622},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=1696#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\\\/\\\/www.ltr.com.tr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Yedek alma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#website\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/\",\"name\":\"LTR Bilgi Teknolojileri\",\"description\":\"Yaz\u0131l\u0131m  ve Network \u00c7\u00f6z\u00fcmleri\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.ltr.com.tr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\",\"name\":\"Ltr Bilgi Teknolojileri Ltd. \u015eti.\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/yloog.png\",\"contentUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/yloog.png\",\"width\":225,\"height\":91,\"caption\":\"Ltr Bilgi Teknolojileri Ltd. \u015eti.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ltrcom\\\/\",\"https:\\\/\\\/x.com\\\/ltrtek\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ltr-communication-software-desing\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/person\\\/776594bf41382c96cd738771c19be481\",\"name\":\"Levent Kubilay\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Yedek alma - LTR Bilgi Teknolojileri","description":"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.","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.ltr.com.tr\/?p=1696","og_locale":"tr_TR","og_type":"article","og_title":"SQL Yedek alma - LTR Bilgi Teknolojileri","og_description":"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.","og_url":"https:\/\/www.ltr.com.tr\/?p=1696","og_site_name":"LTR Bilgi Teknolojileri","article_publisher":"https:\/\/www.facebook.com\/ltrcom\/","article_published_time":"2016-12-05T14:34:37+00:00","article_modified_time":"2020-07-02T10:30:08+00:00","og_image":[{"width":684,"height":622,"url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png","type":"image\/png"}],"author":"Levent Kubilay","twitter_card":"summary_large_image","twitter_creator":"@ltrtek","twitter_site":"@ltrtek","twitter_misc":{"Yazan:":"Levent Kubilay","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ltr.com.tr\/?p=1696#article","isPartOf":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696"},"author":{"name":"Levent Kubilay","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/person\/776594bf41382c96cd738771c19be481"},"headline":"SQL Yedek alma","datePublished":"2016-12-05T14:34:37+00:00","dateModified":"2020-07-02T10:30:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696"},"wordCount":669,"publisher":{"@id":"https:\/\/www.ltr.com.tr\/#organization"},"image":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696#primaryimage"},"thumbnailUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png","keywords":["batch yedek","h\u0131zl\u0131 yedek alma","logo yedek","mssql yedek","sql management studio yedek","sql yedek","sqlcmd yedek","ssms yedek","veritaban\u0131 yedekleme","yedekleme"],"articleSection":["Logo Yaz\u0131l\u0131m","Yaz\u0131l\u0131m"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/www.ltr.com.tr\/?p=1696","url":"https:\/\/www.ltr.com.tr\/?p=1696","name":"SQL Yedek alma - LTR Bilgi Teknolojileri","isPartOf":{"@id":"https:\/\/www.ltr.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696#primaryimage"},"image":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696#primaryimage"},"thumbnailUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png","datePublished":"2016-12-05T14:34:37+00:00","dateModified":"2020-07-02T10:30:08+00:00","description":"MSSQL veritaban\u0131n\u0131n tek ba\u015f\u0131na yede\u011fini alman\u0131z m\u00fcmk\u00fcn de\u011fildir.Bunun i\u00e7in mutlaka veritaban\u0131na eri\u015fiminizi sa\u011flayacak bir aray\u00fcze ihtiyac\u0131n\u0131z var.","breadcrumb":{"@id":"https:\/\/www.ltr.com.tr\/?p=1696#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ltr.com.tr\/?p=1696"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.ltr.com.tr\/?p=1696#primaryimage","url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png","contentUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/12\/sql-1.png","width":684,"height":622},{"@type":"BreadcrumbList","@id":"https:\/\/www.ltr.com.tr\/?p=1696#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.ltr.com.tr\/"},{"@type":"ListItem","position":2,"name":"SQL Yedek alma"}]},{"@type":"WebSite","@id":"https:\/\/www.ltr.com.tr\/#website","url":"https:\/\/www.ltr.com.tr\/","name":"LTR Bilgi Teknolojileri","description":"Yaz\u0131l\u0131m  ve Network \u00c7\u00f6z\u00fcmleri","publisher":{"@id":"https:\/\/www.ltr.com.tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ltr.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.ltr.com.tr\/#organization","name":"Ltr Bilgi Teknolojileri Ltd. \u015eti.","url":"https:\/\/www.ltr.com.tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/logo\/image\/","url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/01\/yloog.png","contentUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/01\/yloog.png","width":225,"height":91,"caption":"Ltr Bilgi Teknolojileri Ltd. \u015eti."},"image":{"@id":"https:\/\/www.ltr.com.tr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ltrcom\/","https:\/\/x.com\/ltrtek","https:\/\/www.linkedin.com\/company\/ltr-communication-software-desing"]},{"@type":"Person","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/person\/776594bf41382c96cd738771c19be481","name":"Levent Kubilay"}]}},"_links":{"self":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/1696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1696"}],"version-history":[{"count":3,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/1696\/revisions"}],"predecessor-version":[{"id":2915,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/1696\/revisions\/2915"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/media\/1698"}],"wp:attachment":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}