<\/div>\n

Bu yaz\u0131mda SQL Server 2008 de veritaban\u0131 yede\u011fi alma y\u00f6ntemlerini anlataca\u011f\u0131m.
\n<\/p>\n

1. Y\u00d6NTEM :<\/strong><\/p>\n

— 1 . SQL SERVER \u0131n \u00e7al\u0131\u015fmas\u0131n\u0131 durdurun.(Object Explorerdan \u00fczerine sa\u011f t\u0131klay\u0131p Stop diyerek ya da masa\u00fcst\u00fcnden Bilgisayar\u0131ma sa\u011f t\u0131kla – Y\u00f6net – Hizmetlerden SQL SERVER \u0131 bul,\u00fczerine sa\u011f t\u0131kla Durdur de)
\n— 2. Yede\u011fini alaca\u011f\u0131n\u0131z database in mdf ve ldf dosyalar\u0131n\u0131n bulundu\u011fu dizine git ve o dosyalar\u0131 kopyalarayarak istedi\u011fin yere al. art\u0131k databasenin yedek dosyalar\u0131 elinde.
\n— 3. Yede\u011fi y\u00fckleyece\u011fin sql servera management studiodan ba\u011flan.
\n— 4. Databases e sa\u011f t\u0131kla Attach de.
\n— 5. A\u00e7\u0131lan pencereden Add t\u0131\u015funa t\u0131kla ve mdf dosyas\u0131n\u0131n oldu\u011fu lokasyonu g\u00f6ster.
\n— 6. OK ile database i geri y\u00fcklemi\u015f oldun.
\n—————————————————–
\n2. Y\u00d6NTEM<\/strong><\/p>\n

— 1. Yede\u011fini almak istedi\u011fin database e sa\u011f t\u0131kla. Tasks-BackUp se\u00e7ene\u011fine git. A\u00e7\u0131lan pencereden BakcUp Type k\u0131sm\u0131ndan Full,Differantial ya da Transaction Log hangi tipte yedek almak istiyorsan se\u00e7 (Full tavsiye edilir.)
\n— 2. A\u015fa\u011f\u0131dan Add tu\u015funa t\u0131klayarak yedek dosyas\u0131n\u0131 hangi diske y\u00fckleyece\u011fini se\u00e7.
\n— 3. Belirtti\u011fin diskte uzant\u0131s\u0131 bak olan bir dosya olu\u015facakt\u0131r. art\u0131k elinde yedek dosyas\u0131 var.
\n— 4. Bu dosyay\u0131 geri y\u00fcklemek i\u00e7in izleyece\u011fin ad\u0131mlar \u015f\u00f6yle. SQL Server da bo\u015f bir veritaban\u0131 olu\u015ftur.O veritaban\u0131 \u00fczerine sa\u011f t\u0131kla Tasks-Restore-Database se\u00e7. A\u015fa\u011f\u0131dan From Device kutusunu i\u015faretle a\u00e7\u0131lan pencereden Add se\u00e7. a\u00e7\u0131lan pencereden .bak dosyas\u0131n\u0131n oldu\u011fu dizini g\u00f6ster. E\u011fer dosyay\u0131 g\u00f6remezsen a\u015fa\u011f\u0131dan All Files se\u00e7. Yedek dosya\u0131n\u0131 g\u00f6rd\u00fc\u011f\u00fcnde onu se\u00e7 OK de. Kar\u015f\u0131na bu dosyan\u0131n hangi tarihte olu\u015fturuldu\u011fu vs. bilgisi gelecek. Bunu ba\u015f\u0131ndaki check kutusunu i\u015faretle ve ok de yedek dosyas\u0131 geri y\u00fcklenecektir.<\/p>\n

—————————————————–<\/p>\n

3. Y\u00d6NTEM (BUNU KULLANIN)<\/strong><\/p>\n

— 1 . Yede\u011fini almak istediiniz database e sa\u011f t\u0131klay\u0131n. Tasks – Genrate Scripts se\u00e7in.
\n— 2. Kar\u015f\u0131n\u0131za bir wizard gelecek Next deyin. Kar\u015f\u0131n\u0131za 2 se\u00e7enek gelecek. \u00dcstteki (database and all … olan) ile database i\u00e7indeki b\u00fct\u00fcn tablolar\u0131n, stored proclar\u0131n, triggerlar\u0131n v.s. nini yede\u011fini alaca\u011f\u0131n\u0131z belirtmi\u015f olursunuz. Alttaki se\u00e7ene\u011fi i\u015faretlerseniz, database i\u00e7inde neyin yede\u011fimi alaca\u011f\u0131n\u0131z\u0131 siz se\u00e7ersiniz. \u00fcsttekini se\u00e7in. Next deyin.
\n— 3. Kar\u015f\u0131n\u0131za gelen pencereden File Name ks\u0131m\u0131ndan, yedek dosyas\u0131n\u0131n nerede olu\u015fturulaca\u011f\u0131n\u0131 belirleyin.
\n— 4. Advanced d\u00fc\u011fmesine t\u0131klay\u0131n, a\u00e7\u0131lan pencerexen Types of data to sxcript in kar\u015f\u0131s\u0131ndan Schema Only se\u00e7erseniz sadece tablo yap\u0131s\u0131n\u0131 (verileri de\u011fil), Data Only se\u00e7erseniz sadece verileri (tablo yap\u0131lar\u0131n\u0131 de\u011fil), Schema and data se\u00e7erseniz de hem tablo yap\u0131lar\u0131n\u0131 hem de verileri yedekleyece\u011finiz s\u00f6ylemi\u015f olursunuz. Schema and data se\u00e7in. Next Next Next diyerek yedek alma i\u015flemini bitirin.
\n— 5. Yede\u011fi geri y\u00fcklemek i\u00e7in olu\u015fturulan script dosyas\u0131n\u0131 ayn\u0131 Northwind y\u00fckler gibi management studioya s\u00fcr\u00fckleyin.
\n— 6. Kar\u015f\u0131n\u0131za gelen kod lar i\u00e7inde use master k\u0131sm\u0131n\u0131 silin ve execute deyin. Yedek dosyas\u0131 geri y\u00fcklenecek ve database olu\u015facakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"

Bu yaz\u0131mda SQL Server 2008 de veritaban\u0131 yede\u011fi alma y\u00f6ntemlerini anlataca\u011f\u0131m.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[127,128],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-veritabani","tag-database","tag-yedekleme"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}