{"id":245,"date":"2010-08-15T18:03:46","date_gmt":"2010-08-15T16:03:46","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=245"},"modified":"2017-05-19T16:26:26","modified_gmt":"2017-05-19T13:26:26","slug":"backup-ve-restore-planlari","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/","title":{"rendered":"Backup ve Restore planlar\u0131"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">SQL&#8217;de backup restore \u00f6zelliklerini \u00f6\u011frenmeden \u00f6nce, veritaban\u0131nda bir kay\u0131t i\u015flemi nas\u0131l olur onu g\u00f6relim.<\/p>\n<p style=\"font-family: Arial, Helvetica, sans-serif;\"><img loading=\"lazy\" decoding=\"async\" src=\"\/photos\/backuprestore\/veritabaniisleme.jpg\" alt=\"\" width=\"640\" height=\"276\" \/><\/p>\n<p style=\"font-family: Arial, Helvetica, sans-serif;\">Veri tabanlar\u0131na i\u015fleme olay\u0131n\u0131 en basit bir banka hesab\u0131ndan anlatmaya \u00e7al\u0131\u015fal\u0131m. Banka hesab\u0131m\u0131zda para bulunmamaktad\u0131r. Bu y\u00fczden kural olarak bankadan para \u00e7ekemez veya eft yapamazs\u0131n\u0131z.(Bknz.\u015eekil-1)<br \/>\n1- ID=1 ile \u0130nternet \u00fczerinden bir ba\u015fka hesaba EFT yapt\u0131\u011f\u0131m\u0131z varsayal\u0131m. \u0130\u015flemi yap\u0131yoruz ve ilk\u00f6nce veri taban\u0131n\u0131n .ldf dosyas\u0131na komutu g\u00f6nderiyoz. B\u00f6ylece ID=1 oluyor, fakat 3.00 TL olarak yapaca\u011f\u0131m\u0131z eft veritaban\u0131m\u0131za i\u015flenmeden (.mdf) kurallara uygun olmad\u0131\u011f\u0131ndan dolay\u0131 rollback ile iptal ediliyor.<br \/>\n2- ID=2 ile bu sefer ba\u015fka bir hesaptan kendi hesab\u0131m\u0131za 10.00 TL\u00a0eft yap\u0131yoruz. .ldf ile yapt\u0131\u011f\u0131m\u0131z i\u015flem ID=2 ile .mdf dosyas\u0131na yani ger\u00e7ek veritaban\u0131m\u0131za i\u015fleniyor. SQL sorgulamadan bakt\u0131\u011f\u0131n\u0131z zaman ID=1 ile yap\u0131lan kay\u0131tlar\u0131 g\u00f6remeyiz \u00e7\u00fcnk\u00fc bu i\u015flem log dosyas\u0131 olan .ldf den veritaban\u0131na i\u015flenirken kurallara uygun olmad\u0131\u011f\u0131ndan dolay\u0131 iptal edilmi\u015ftir.<\/p>\n<p>\u015eimdi .ldf ve .mdf dosyalar\u0131 aras\u0131ndaki fark\u0131 \u00f6\u011frendi\u011fimize g\u00f6re Recovery Model yani veri taban\u0131 kurtarma modeline ge\u00e7ebiliriz.<br \/>\nRecovery Model 3&#8217;e ayr\u0131l\u0131r:<br \/>\n1- Full : T\u00fcm yap\u0131lan i\u015flemler (ldf ve .mdf ) kay\u0131t alt\u0131na al\u0131n\u0131r ve backup&#8217;a kadar log dosyalar\u0131 silinmez. Bu genellikle veri ak\u0131\u015f\u0131 fazla ve verilerin \u00f6nemli oldu\u011fu zaman tutulan veritaban\u0131 kay\u0131tlar\u0131d\u0131r.(\u00d6rnek banka veritabanlar\u0131)<br \/>\n2- Bulk-Logged: B\u00fcy\u00fck verilerin ge\u00e7i\u015fi s\u0131ras\u0131na tutulmas\u0131 gereken veritaban\u0131 kay\u0131tlar\u0131d\u0131r. Yani b\u00fcy\u00fck bir dosyay\u0131 veritaban\u0131na aktar\u0131rken i\u015flem tamamlanana kadar yap\u0131lmas\u0131 gereken bir harekettir. Devaml\u0131l\u0131k arz etmez.<br \/>\n3- Simple: Veri ak\u0131\u015f\u0131n\u0131n fazla olmad\u0131\u011f\u0131, verilerin bizim i\u00e7in b\u00fcy\u00fck bir \u00f6nem ta\u015f\u0131mad\u0131\u011f\u0131 veritabanlar\u0131 i\u00e7in tutulan kay\u0131tt\u0131r.(\u00d6rnek forum siteleri)<br \/>\nBu ayarlar\u0131n nas\u0131l yap\u0131laca\u011f\u0131 \u015fekil-2&#8217;de belirtilmi\u015ftir. Veritaban\u0131 ilk olu\u015fturulurken veya olu\u015fturulduktan sonra de\u011fi\u015ftirilebilir.<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"\/photos\/backuprestore\/veritabaniozellik.jpg\" alt=\"\" width=\"616\" height=\"562\" \/><\/p>\n<p style=\"font-family: Arial, Helvetica, sans-serif;\">Backup ve Restore i\u015flemleri 3&#8217;e ayr\u0131l\u0131r.<br \/>\n1- Full : T\u00fcm .mdf ve .ldf(log) dosylar\u0131n\u0131n yede\u011fi al\u0131n\u0131r ve yedek al\u0131nma i\u015fleminden sonra serverda bulunan .ldf dosyalar\u0131 fazla yer kaplamamas\u0131 amac\u0131yla silinir.<br \/>\n2- Differential: Full olarak yap\u0131lan yedekleme i\u015fleminden sonra art\u0131r\u0131ml\u0131 dedi\u011fimiz sadece yap\u0131lan de\u011fi\u015fiklerin yedeklendi\u011fi backup i\u015flemidir.(Bknz.\u015eekil-3)<br \/>\n3- Transaction Log: Sadece .ldf dosylar\u0131n\u0131n yedeklerinin al\u0131nmas\u0131d\u0131r.<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"\/photos\/backuprestore\/veritabaniyedekleme.jpg\" alt=\"\" width=\"641\" height=\"369\" \/><br \/>\n\u015eimdi \u015fekil-3&#8217;e bakarak kendi politikan\u0131z\u0131 olu\u015fturabilmeniz i\u00e7in bir fikir verelim.<br \/>\n1- Ak\u015fam saat 00:00&#8217;da ba\u015flayan full yedekleme i\u015flemimiz sabah saat 06:00&#8217;da bitmi\u015ftir.<br \/>\n2- Saat 10:00&#8217;da Differential yedekleme ile sadece de\u011fi\u015fiklik olan kay\u0131tlar\u0131n yede\u011fi al\u0131nm\u0131\u015ft\u0131r.(06:00-10:00 aras\u0131ndaki i\u015flemler)<br \/>\n3- Saat 12:00&#8217;de Differential yedekleme ile sadece de\u011fi\u015fiklik olan kay\u0131tlar\u0131n yede\u011fial\u0131nm\u0131\u015ft\u0131r.(06:00 -12:00 aras\u0131ndaki i\u015flemler)<\/p>\n<p>\u015eimdi saat 12:30 da veritaban\u0131m\u0131z\u0131n \u00e7\u00f6kt\u00fc\u011f\u00fc d\u00fc\u015f\u00fcnelim:<br \/>\n1- Veritaban\u0131m\u0131z full recovery model : Veri kayb\u0131m\u0131z yok (Ama veritaban\u0131m\u0131z full oldu\u011fu i\u00e7in log dosyalar\u0131n\u0131n hdd yer olmad\u0131\u011f\u0131ndan dolay\u0131 veritaban\u0131 \u00e7\u00f6km\u00fc\u015f olabilir.\u015eimdi acaba veritaban\u0131m\u0131z\u0131n recovery modeli full olmal\u0131m\u0131d\u0131r?)<br \/>\n2- Veritaban\u0131m\u0131z Simple recovery model : Veri kayb\u0131m\u0131z 30 dakika (Acaba veritaban\u0131m\u0131zdaki bu 30 dakika bizi \u00e7ok etkiler miydi?\u00a0)<\/p>\n<p>Sonu\u00e7 olarak;<br \/>\n1- Bir forum sitemiz var \u00e7ok fazla miktarda veri ak\u0131\u015f\u0131 yok; backup haftal\u0131k olarak al\u0131n\u0131p, g\u00fcnl\u00fck olarak da Differential yedek alabiliriz. Veri taban\u0131m\u0131z\u0131n recovery modeli simple olabilir. B\u00f6ylece hosting olarak b\u00fcy\u00fck bir alan almam\u0131za gerek kalmaz.<br \/>\n2- Forum sitemiz de \u00e7ok fazla veri ak\u0131\u015f\u0131 var; Backup&#8217;\u0131 g\u00fcnl\u00fck full olarak alabiliriz, hatta g\u00fcnl\u00fck belirli saatlerde Transaction Log olarak yedek alabiliriz. recovery modelimiz ise full olmas\u0131 d\u00fc\u015f\u00fcn\u00fclebilir.<br \/>\n3- \u0130\u015f yerinde internete giren personelin yedekleri tutuluyor, \u00e7ok fazla veri ak\u0131\u015f\u0131 var ama ak\u015famlar\u0131 kimse mesaide de\u011fil, hatta veritaban\u0131m\u0131zdaki bilgiler \u00e7ok \u00e7ok \u00f6nemi yok; Recovery Model full olabilir, g\u00fcnl\u00fck full yedek al\u0131r\u0131z, g\u00fcnl\u00fck olarak da Differential yedek alabiliriz.<\/p>\n<p>Tabi bu varsay\u0131mlar benim kendi d\u00fc\u015f\u00fcncem, \u015eimdi kendi veritaban\u0131m\u0131z\u0131n nas\u0131l bir recovery model ile olu\u015fturulaca\u011f\u0131 ve yedekleme prosedurler\u0131n\u0131 nas\u0131l olu\u015fturabilece\u011fimiz hakk\u0131nda biraz olsun fikir sahibi yapabildi\u011fimi umuyorum.<\/p>\n<p>Te\u015fekk\u00fcrler \u00c7a\u011flar TEMUR Hocam&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL&#8217;de backup restore \u00f6zelliklerini \u00f6\u011frenmeden \u00f6nce, veritaban\u0131nda bir kay\u0131t i\u015flemi nas\u0131l olur onu g\u00f6relim. Veri tabanlar\u0131na i\u015fleme olay\u0131n\u0131 en basit<\/p>\n","protected":false},"author":14,"featured_media":640,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[55,58,57,60,56,59,36],"class_list":["post-245","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-backup","tag-differential","tag-full-backup","tag-recovery-model","tag-restore","tag-simple","tag-sql-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK<\/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.fethimurat.com\/blog\/backup-ve-restore-planlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"SQL&#8217;de backup restore \u00f6zelliklerini \u00f6\u011frenmeden \u00f6nce, veritaban\u0131nda bir kay\u0131t i\u015flemi nas\u0131l olur onu g\u00f6relim. Veri tabanlar\u0131na i\u015fleme olay\u0131n\u0131 en basit\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-15T16:03:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-19T13:26:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png\" \/>\n\t<meta property=\"og:image:width\" content=\"722\" \/>\n\t<meta property=\"og:image:height\" content=\"301\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Backup ve Restore planlar\u0131\",\"datePublished\":\"2010-08-15T16:03:46+00:00\",\"dateModified\":\"2017-05-19T13:26:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\"},\"wordCount\":776,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png\",\"keywords\":[\"backup\",\"differential\",\"full backup\",\"recovery model\",\"restore\",\"simple\",\"sql\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\",\"name\":\"Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png\",\"datePublished\":\"2010-08-15T16:03:46+00:00\",\"dateModified\":\"2017-05-19T13:26:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png\",\"width\":722,\"height\":301},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup ve Restore planlar\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK","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.fethimurat.com\/blog\/backup-ve-restore-planlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK","og_description":"SQL&#8217;de backup restore \u00f6zelliklerini \u00f6\u011frenmeden \u00f6nce, veritaban\u0131nda bir kay\u0131t i\u015flemi nas\u0131l olur onu g\u00f6relim. Veri tabanlar\u0131na i\u015fleme olay\u0131n\u0131 en basit","og_url":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-15T16:03:46+00:00","article_modified_time":"2017-05-19T13:26:26+00:00","og_image":[{"width":722,"height":301,"url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png","type":"image\/png"}],"author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Backup ve Restore planlar\u0131","datePublished":"2010-08-15T16:03:46+00:00","dateModified":"2017-05-19T13:26:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/"},"wordCount":776,"commentCount":1,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png","keywords":["backup","differential","full backup","recovery model","restore","simple","sql"],"articleSection":["SQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/","url":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/","name":"Backup ve Restore planlar\u0131 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png","datePublished":"2010-08-15T16:03:46+00:00","dateModified":"2017-05-19T13:26:26+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#primaryimage","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/backup.png","width":722,"height":301},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/backup-ve-restore-planlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Backup ve Restore planlar\u0131"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=245"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media\/640"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}