{"id":2774,"date":"2012-09-21T08:41:40","date_gmt":"2012-09-21T08:41:40","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=2774"},"modified":"2019-02-28T11:08:50","modified_gmt":"2019-02-28T11:08:50","slug":"sql-server-2008-de-database-snaphot-kullanimi","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-2008-de-database-snaphot-kullanimi\/","title":{"rendered":"SQL Server 2008 de Database Snaphot Kullan\u0131m\u0131"},"content":{"rendered":"

Merhaba Arkada\u015flar,<\/p>\n

Bu yaz\u0131mda sizlere SQL Server 2008 de Database Snaphot kullan\u0131m\u0131n\u0131 anlataca\u011f\u0131m. Bu yaz\u0131y\u0131 okumadan \u00f6nce Database Snapshot kavram\u0131n\u0131 anlatan \u00f6nceki yaz\u0131m\u0131<\/a> okursan\u0131z sizin a\u00e7\u0131n\u0131zdan faydal\u0131 olacakt\u0131r. Snaphot lar Databases sekmesinin alt\u0131nda a\u015fa\u011f\u0131daki gibi bulunmaktad\u0131r. \u015euana kadar Hi\u00e7bir Veritaban\u0131n\u0131n Snapshot \u0131 al\u0131nmad\u0131\u011f\u0131 i\u00e7in Database Snapshots sekmesi g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi bo\u015f durumdad\u0131r.<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n\n

SQL Server da Snapshot olu\u015ftururken Management Studio da User Interface den de\u011filde a\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcde bulunan T-SQL koduyla olu\u015fturulmaktad\u0131r. \u00d6rnek olarak Bir \u00e7ok \u00f6rnekte kullan\u0131lan ve \u00e7ok sevdi\u011fim Test database olan AdventureWorks database i kullan\u0131lm\u0131\u015ft\u0131r.<\/p>\n

\"\"<\/a><\/p>\n

SQL Server Database Snaphot Kodu<\/strong><\/em>\r\nCREATE DATABASE AdventureWorksSnaphot \u00a0ON\r\n( NAME = AdventureWorks_Data, FILENAME = 'd:\\Snapshot\\AdventureWorks_SparseFile.ss' )\r\nAS SNAPSHOT OF AdventureWorks;\r\nGO<\/pre>\n
Script \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131 zaman yukar\u0131da sol tarafta g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi SQL Server AdventureWorksSnaphot ad\u0131nda bir database Databases Snaphot sekmesinin alt\u0131nda olu\u015fturulmu\u015ftur. Bu database AdventureWorks database inin sadece bir g\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr. Diskte AdventureWorks database inin boyutu kadar bir Sparse file olu\u015fturulmas\u0131na ra\u011fmen ba\u015flang\u0131\u00e7ta \u00e7ok k\u00fc\u00e7\u00fck bir boyut olarak Create edilmektedir. A\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcde AdventureWorksSnaphot database inin Fiziksel disk \u00fczerindeki yeri g\u00f6sterilmi\u015ftir.<\/p>\n
\"\"<\/a><\/p>\n
Yukar\u0131daki g\u00f6r\u00fcnt\u00fcde 1 numaral\u0131 boyut asl\u0131nda AdventureWorks Source veritaban\u0131n\u0131n boyutudur. 2 numaral\u0131 boyut ise AdventureWorksSnaphot \u0131n\u0131n Sparsefile dosyas\u0131n\u0131n boyutudur. \u00d6nceki yaz\u0131mda da belirtmi\u015ftim Sparse File da A\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcdeki gibi sadece Source database de de\u011fi\u015fen page lerin \u00f6nceki hali bulunacakt\u0131r.<\/p>\n
\"\"<\/a><\/p>\n
Snapshot veritaban\u0131n\u0131 a\u00e7t\u0131\u011f\u0131m\u0131z zaman Source da bulunan Table, Views, Stored Procedures vb gibi \u00f6\u011felerin tamam\u0131 ayn\u0131 \u015fekilde bulunmaktad\u0131r. A\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcde oldu\u011fu gibi Source database olan tablolar\u0131n ayn\u0131s\u0131n\u0131 Snaphot veritaban\u0131n\u0131ndan da g\u00f6r\u00fcnt\u00fclenebilmekte ve Select \u00e7ekilebilmektedir.<\/p>\n
\"\"<\/a><\/p>\n
Snapshot lar Administrator hatalar\u0131 konusunda da etkili oldu\u011funu s\u00f6ylemi\u015ftim. \u00d6rne\u011fin yanl\u0131\u015fl\u0131kla bir tabloyu tamamen silme veya tabloyu truncate etme gibi hatalar Administrator hatalar\u0131na girmektedir. \u00d6rnek olarak AdventureWorks database inden DBO \u015femas\u0131 alt\u0131ndaki 1 numaral\u0131 karede g\u00f6r\u00fcnen AWBuildVersion tablosu drop ediliyor. Script \u00e7al\u0131\u015ft\u0131ktan sonra Tables Sekmesi yenilendi\u011fi zaman a\u015fa\u011f\u0131da 2 numaral\u0131 g\u00f6r\u00fcnt\u00fcde g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi AWBuildVersion tablosu AdventureWorks Source database inden silinmi\u015ftir.<\/p>\n
\"\"<\/a><\/p>\n
Bu hata kritik veritabanlar\u0131nda \u00e7ok su g\u00f6t\u00fcr\u00fcr \ud83d\ude42 Bu hatadan d\u00f6nmek i\u00e7in Snapshot veritaban\u0131n\u0131 kullan\u0131yoruz. A\u015fa\u011f\u0131daki gibi Snapshot veritaban\u0131nda dbo \u015femas\u0131n\u0131n alt\u0131nda bulunan AWBuildVersion tablosunu kullanarak AdventureWorks database inde dbo \u015femas\u0131 alt\u0131nda AWBuildVersion tablosunu olu\u015fturup datas\u0131n\u0131 insert ediyoruz. Select * into komutu create + insert i\u015flevini g\u00f6r\u00fcyor. Scripti \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonraki ekran g\u00f6r\u00fcnt\u00fcs\u00fc a\u015fa\u011f\u0131daki gibidir. K\u0131rm\u0131z\u0131 \u00e7izgiyle belirtildi\u011fi gibi Drop edilen Table datas\u0131yla beraber geri d\u00f6nd\u00fcr\u00fclm\u00fc\u015ft\u00fcr.<\/p>\n
\"\"<\/a><\/p>\n
Benzeri bir \u00f6rnek daha yapal\u0131m daha kal\u0131c\u0131 olmas\u0131 a\u00e7\u0131s\u0131ndan. Herhangi bir tablonun verilerini silelim ve tekrardan Snapshot dan d\u00f6nd\u00fcrelim.\u00a0 A\u015fa\u011f\u0131da 1.1 numaral\u0131 g\u00f6r\u00fcnt\u00fcde belirtildi\u011fi gibi AdventureWorks database inden Production \u015eemas\u0131n\u0131n alt\u0131ndaki BillOfMaterials tablosu delete ediliyor. Tabloya ayn\u0131 anda Select count \u00e7ekti\u011fimiz zaman yukar\u0131daki 1.2 numaral\u0131 a\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcden de g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi 0 kay\u0131t \u00e7ekilmektedir.<\/p>\n
\"\"<\/a><\/p>\n
Bu Administrator hatas\u0131ndan d\u00f6nmek i\u00e7in yine Snapshot veritaban\u0131n\u0131 kullan\u0131yoruz. Yukar\u0131da 2.1 numaral\u0131 g\u00f6r\u00fcnt\u00fcde oldu\u011fu gibi Snapshot veritaban\u0131n\u0131n ayn\u0131 \u015fema ve tablosunu source database deki ilgili tabloya insert yap\u0131yoruz. Ayn\u0131 \u015fekilde Select Count \u00e7ekti\u011fimiz zaman 2.2 numaral\u0131 g\u00f6r\u00fcnt\u00fcde g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi ayn\u0131 say\u0131da sat\u0131r kay\u0131t insert edilmi\u015ftir.<\/p>\n
Son olarak Snapshot veritaban\u0131ndan yine bir administrator hatas\u0131 yap\u0131p bu defa Snaphot veritaban\u0131n\u0131 Restore yap\u0131yoruz. B\u00f6ylece AdventureWorks database i Snapshot al\u0131n\u0131rken ki haline geri d\u00f6nm\u00fc\u015f oluyor. Production \u015eemas\u0131n\u0131n alt\u0131ndaki BillOfMaterials tablosunun datalar\u0131n\u0131 siliyorum ayn\u0131 anda da Sales \u015femas\u0131n\u0131n alt\u0131ndaki SalesOrderDetail tablosunu drop ediyorum. Ekran g\u00f6r\u00fcnt\u00fcs\u00fc a\u015fa\u011f\u0131daki gibidir. Production \u015eemas\u0131n\u0131n alt\u0131ndaki BillOfMaterials tablosunun datalar\u0131 silindi\u011fi gibi Sales \u015femas\u0131nun alt\u0131nda da SalesOrderDetail tablosu drop edilmi\u015f g\u00f6r\u00fcnmemektedir.<\/p>\n
\"\"<\/a><\/p>\n
Source Veritaban\u0131ndan \u00e7ok say\u0131da de\u011fi\u015fiklik yapt\u0131k bu de\u011fi\u015fiklikler hep Sparse File a yaz\u0131ld\u0131\u011f\u0131n\u0131 s\u00f6ylemi\u015ftik. A\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcde Sparse file \u0131n son hali g\u00f6r\u00fcnmektedir. 1. numaral\u0131 orjinal boyut de\u011fi\u015fmemi\u015fken 2 numaral\u0131 as\u0131l Sparse file \u0131n boyutu artm\u0131\u015ft\u0131r. Bunun sebebi de dedi\u011fim gibi Source database de yap\u0131lan t\u00fcm de\u011fi\u015fikliklerin Snaphot al\u0131n\u0131rken ki halleri buraya yaz\u0131l\u0131r. B\u00f6ylece Kullan\u0131c\u0131 Snapshot dan veri okurken de\u011fi\u015fmemi\u015f datay\u0131 Source dan okurken De\u011fi\u015fmi\u015f g\u00fcncellenmi\u015f data olursa G\u00fcncellenmeden \u00f6nceki halini Sparse File dan okur. Sparse File da her zaman Snapshot al\u0131n\u0131rken ki datalar tutulur.<\/p>\n
\"\"<\/a><\/p>\n
\u015eimdi belli anda ald\u0131\u011f\u0131m\u0131z Snapshot dan geri d\u00f6nelim. Geri d\u00f6nerken demin yapt\u0131\u011f\u0131m\u0131z \u00f6rne\u011fe istinaden Production \u015eemas\u0131n\u0131n alt\u0131ndan BillOfMaterials, Sales \u015eemas\u0131n\u0131n alt\u0131ndaki SalesOrderDetail tablosuna Select \u00e7ekiyoruz. A\u015fa\u011f\u0131daki g\u00f6r\u00fcnt\u00fcdeki gibi bu tablolar eski haline d\u00f6nm\u00fc\u015ft\u00fcr. AdventureWorks database i Snapshot dan Restore edilmi\u015ftir.<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
SQL Server 2008 Database Snaphot Restore Kodu<\/strong><\/em>\r\nrestore\u00a0<\/code>database<\/code>\u00a0\u00a0AdventureWorks\u00a0<\/code>from<\/code>\u00a0database_snapshot=<\/code>'AdventureWorksSnaphot'<\/code><\/pre>\n
 <\/p>\n
B\u00f6ylece bir yaz\u0131m\u0131n daha sonuna gelmi\u015f bulunmaktay\u0131m. Bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle Esen Kal\u0131n…<\/p>\n\n
 <\/p>\n
Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n
– Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba Arkada\u015flar, Bu yaz\u0131mda sizlere SQL Server 2008 de Database Snaphot kullan\u0131m\u0131n\u0131 anlataca\u011f\u0131m. Bu yaz\u0131y\u0131 okumadan \u00f6nce Database Snapshot kavram\u0131n\u0131 anlatan \u00f6nceki yaz\u0131m\u0131 okursan\u0131z sizin a\u00e7\u0131n\u0131zdan faydal\u0131 olacakt\u0131r. Snaphot lar Databases sekmesinin alt\u0131nda a\u015fa\u011f\u0131daki gibi bulunmaktad\u0131r. \u015euana kadar Hi\u00e7bir Veritaban\u0131n\u0131n Snapshot \u0131 al\u0131nmad\u0131\u011f\u0131 i\u00e7in Database Snapshots sekmesi g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi bo\u015f durumdad\u0131r.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[467,508,1031,1515,1561,1562,1577,1578,1583,1597,1598,1664,1665,1666,1713,1856],"class_list":["post-2774","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-database-snapshot","tag-deveci","tag-mehmet-salih-deveci","tag-salih-deveci","tag-snapshot","tag-snapshot-kodu","tag-sql-server","tag-sql-server-2005","tag-sql-server-2008","tag-sql-server-2008-snapshot","tag-sql-server-2008-snapshot-olusturma","tag-sql-server-snapshot","tag-sql-server-snapshot-kavrami","tag-sql-server-snapshot-nasil-alinir","tag-t-sql-snapshot-kodu","tag-veritaban-inda-snapshot-alma"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=2774"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2774\/revisions"}],"predecessor-version":[{"id":5908,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2774\/revisions\/5908"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}