{"id":2811,"date":"2012-10-02T10:59:39","date_gmt":"2012-10-02T10:59:39","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=2811"},"modified":"2019-02-28T11:07:40","modified_gmt":"2019-02-28T11:07:40","slug":"sql-server-2008-backup-restore-islemi-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-2008-backup-restore-islemi-2\/","title":{"rendered":"SQL Server 2008 Backup – Restore \u0130\u015flemi -2"},"content":{"rendered":"

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

Bu yaz\u0131mda SQL Server 2008 de Backup \u2013 Restore i\u015flemine devam edece\u011fim. \u00d6nceki yaz\u0131mda<\/a> Backup tiplerini, Recovery model leri anlatm\u0131\u015f ve son olarakta SQL Server 2008 de Backup i\u015fleminin ger\u00e7eklenmesini g\u00f6stermi\u015ftim. Bu yaz\u0131da da Backup \u0131 al\u0131nan bir Veritaban\u0131n\u0131n tekrardan Restore edilmesini anlataca\u011f\u0131m.\u00a0Bu yaz\u0131 \u00f6nceki yaz\u0131n\u0131n<\/a> devam\u0131 niteli\u011finde oldu\u011fu i\u00e7in \u00f6nceki yaz\u0131da Backup ald\u0131\u011f\u0131m database i \u015fimdi farkl\u0131 bir instance s\u0131ma Restore edece\u011fim. Ornek instance sa login olduktan sonra Databases -> Tasks-> Restore <\/strong>\u00a0ad\u0131mlar\u0131n\u0131 icra ediyorum.<\/p>\n

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

<\/p>\n\n

Yukar\u0131daki ad\u0131mlar\u0131 icra ettikten sonra a\u015fa\u011f\u0131daki gibi SQL Server 2008 Management Studio Restore toolu kar\u015f\u0131m\u0131za \u00e7\u0131kmal\u0131d\u0131r.<\/p>\n

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

 <\/p>\n

Bu tool \u00fczerinde Backup \u0131n bulundu\u011fu yere gidip restore i\u015flemini ba\u015flataca\u011f\u0131m. Backup dosyam disk \u00fczerinde oldu\u011fu i\u00e7in From Database<\/strong> de\u011filde From Devices <\/strong>check box \u0131n\u0131 a\u015fa\u011f\u0131daki gibi se\u00e7tim. Burda gelen men\u00fcde a\u015fa\u011f\u0131daki gibi Add se\u00e7ene\u011fini t\u0131klay\u0131p resimde yan men\u00fcde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi AdventureWorks.bak dosyas\u0131n\u0131 disk \u00fczerinde koydu\u011fum yeri se\u00e7iyorum.<\/p>\n

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

Backup dosyam\u0131z\u0131 Restore tool una mount ettikten sonra Options <\/strong>k\u0131sm\u0131na geliyoruz. Options sekmesini A\u015fa\u011f\u0131da g\u00f6r\u00fcnt\u00fcde belirtti\u011fim gibi 3 maddeyle anlataca\u011f\u0131m.<\/p>\n

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

    \n
  1. Restore Options k\u0131sm\u0131nda Restore edilirken ne t\u00fcr opsiyonlar\u0131n olaca\u011f\u0131n\u0131 d\u00fczenliyoruz. \u00d6rne\u011fin ilk tik box da e\u011fer Backup edece\u011fin veritaban\u0131 mevcutsa bu se\u00e7ene\u011fi eklersen Backup verilerini se\u00e7ilen veritaban\u0131n\u0131n \u00fczerine yazar.<\/li>\n
  2. Bu se\u00e7enekte Restore edece\u011fimiz Backup data ve log filelar\u0131n\u0131n disk \u00fczerindeki default bulunaca\u011f\u0131 yer g\u00f6r\u00fcl\u00fcr. Bunu sa\u011fdaki buttona t\u0131klay\u0131p de\u011fi\u015ftirebiliriz.<\/li>\n
  3. Bu se\u00e7enekte commit yememi\u015f transaction lar\u0131n nas\u0131l restore edilece\u011fi belirtiliyor.Duruma g\u00f6re commitlenmemi\u015f transactionlar ya restore edilir yada restore edilmez yada standby modda restore edilebilir.<\/li>\n<\/ol>\n

    Bu opsiyonlar\u0131 belirttikten sonra Restore olduktan sonra Database in ad\u0131 ne olacak son olarak onu To Database<\/strong> se\u00e7ene\u011finde AdventureWorks olarak belirtiyoruz. Restore tool unda Generate Scripts yap\u0131yoruz a\u015fa\u011f\u0131daki gibi restore i\u015fleminin T-SQL kodunu SQL Server Management Studio \u00fcretiyor.<\/p>\n

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

     <\/p>\n

    SQL Server 2008 Restore T-SQL Kodu<\/strong><\/p>\n

    RESTORE DATABASE [AdventureWorks] FROM\u00a0 DISK = N'D:\\Data\\AdventureWorksBackup.bak' WITH\u00a0 FILE = 1,\r\n\u00a0MOVE N'AdventureWorks_Data' TO N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MYTESTINSTANCE\\MSSQL\\DATA\\AdventureWorks_Data.mdf',\r\n\u00a0 MOVE N'AdventureWorks_Log' TO N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MYTESTINSTANCE\\MSSQL\\DATA\\AdventureWorks_Log.ldf',\r\n\u00a0 NOUNLOAD,\u00a0 STATS = 10\r\nGO<\/pre>\n
    Bundan sonra f5 e t\u0131klay\u0131p T-SQL kodunu execute etti\u011fimizde a\u015fa\u011f\u0131daki gibi restore i\u015flemi ba\u015far\u0131l\u0131 bir \u015fekilde tamamlanm\u0131\u015f oluyor. A\u015fa\u011f\u0131da g\u00f6r\u00fcnt\u00fcde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi Sol tarafta Restore i\u015flemi bittikten sonra Restore olmu\u015f database imiz AdventureWorks ad\u0131yla g\u00f6z\u00fckmektedir. Sa\u011f tarafta da \u00e7al\u0131\u015fan scriptin ba\u015far\u0131l\u0131 bir \u015fekilde ger\u00e7ekle\u015fti\u011fi g\u00f6r\u00fcl\u00fcyor.<\/p>\n
    \"Restore<\/a><\/p>\n
     <\/p>\n
    B\u00f6ylece SQL Server 2008 de Backup Restore yaz\u0131m\u0131n sonuna gelmi\u015f bulunmaktay\u0131m. Bir sonraki SQL Server yaz\u0131s\u0131nda g\u00f6r\u00fc\u015fmek dile\u011fiyle Esen Kal\u0131n\u2026<\/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 SQL Server 2008 de Backup \u2013 Restore i\u015flemine devam edece\u011fim. \u00d6nceki yaz\u0131mda Backup tiplerini, Recovery model leri anlatm\u0131\u015f ve son olarakta SQL Server 2008 de Backup i\u015fleminin ger\u00e7eklenmesini g\u00f6stermi\u015ftim. Bu yaz\u0131da da Backup \u0131 al\u0131nan bir Veritaban\u0131n\u0131n tekrardan Restore edilmesini anlataca\u011f\u0131m.\u00a0Bu yaz\u0131 \u00f6nceki yaz\u0131n\u0131n devam\u0131 niteli\u011finde oldu\u011fu i\u00e7in \u00f6nceki yaz\u0131da Backup …<\/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":[205,508,1031,1515,1577,1578,1583,1596,1620,1621,1622,1631,1655,1662,1663],"class_list":["post-2811","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-backup-alma","tag-deveci","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2005","tag-sql-server-2008","tag-sql-server-2008-restore-kodu","tag-sql-server-backup","tag-sql-server-backup-restore","tag-sql-server-backup-restore-islemi","tag-sql-server-database-restore","tag-sql-server-management-studio","tag-sql-server-restore","tag-sql-server-restore-islemi"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2811","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=2811"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2811\/revisions"}],"predecessor-version":[{"id":5905,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/2811\/revisions\/5905"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=2811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=2811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=2811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}