{"id":3895,"date":"2014-07-15T22:39:10","date_gmt":"2014-07-15T22:39:10","guid":{"rendered":"http:\/\/mehmetsalihdeveci.net\/?p=3895"},"modified":"2019-02-28T08:37:16","modified_gmt":"2019-02-28T08:37:16","slug":"sql-server-2012-sp2-upgrade","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-2012-sp2-upgrade\/","title":{"rendered":"SQL Server 2012 SP2 Upgrade"},"content":{"rendered":"<p>Merhaba Arkada\u015flar,<\/p>\n<p>Bu yaz\u0131mda sizlere Windows Server 2012 \u00fczerinde \u00e7al\u0131\u015fan SQL Server 2012 SP1 veritaban\u0131n\u0131n SQL Server 2012 SP2 (\u00a0Service Pack 2 ) ye upgrade edilmesini anlataca\u011f\u0131m. Bu <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=43340\">Service Pack 2<\/a> Microsoft taraf\u0131ndan 10 haziran 2014 tarihinde yay\u0131nland\u0131 ve SQL Server 2012 RTM ve SP1 versiyonuna uygulanabilir. \u0130lgili Service Pack in download adresi <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=43340\">bu linktedir<\/a>. Service Pack 2, SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9) da i\u00e7ermektedir.<\/p>\n<p><a href=\"https:\/\/salihdeveci.files.wordpress.com\/2014\/07\/sql-server-2012-service-pack-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3896\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/sql-server-2012-service-pack-2.png\" alt=\"SQL-Server-2012-Service-Pack-2\" width=\"614\" height=\"337\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/sql-server-2012-service-pack-2.png 728w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/sql-server-2012-service-pack-2-300x165.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n\n<p>Kuruluma ba\u015flamadan \u00f6nce verilerin kritikli\u011fine g\u00f6re Backup al\u0131nmas\u0131 tavsiye edilir. Ayr\u0131ca bu kurulum s\u0131ras\u0131nda ve sonras\u0131nda Restart gerekti\u011fi i\u00e7in production ortamlarda kesinti planlanmal\u0131d\u0131r. Kurulum \u00f6ncesinde Veritaban\u0131n\u0131n versiyonuna ve product level \u0131na a\u015fa\u011f\u0131daki gibi\u00a0bak\u0131yorum. Production veritaban\u0131m SQL Server 2012 SP1 versiyonunda ve Product level \u0131 11.0.3000.0 \u015feklindedir. Upgrade sonras\u0131 versiyonum SQL Server 2012 SP2 olacak ve Product level \u0131m ise 11.0.5058.0 \u015feklinde olup en g\u00fcncel SQL Server versiyonlar\u0131ndan birisi olacakt\u0131r.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3884\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/3.png\" alt=\"3\" width=\"614\" height=\"225\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/3.png 821w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/3-300x110.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/3-768x283.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Service Pack 2 yi <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=43340\">bu linkten<\/a> indirdikten sonra kuruluma ba\u015fl\u0131yorum. Kurulum ad\u0131mlar\u0131 a\u015fa\u011f\u0131daki gibidir.<\/p>\n<p>Ad\u0131m -1:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3883\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/2.png\" alt=\"2\" width=\"614\" height=\"433\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/2.png 851w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/2-300x212.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/2-768x542.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -2:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3885\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/4.png\" alt=\"4\" width=\"614\" height=\"461\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/4.png 815w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/4-300x226.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/4-768x578.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -3:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3886\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/5.png\" alt=\"5\" width=\"614\" height=\"461\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/5.png 819w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/5-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/5-768x577.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -4:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3887\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/6.png\" alt=\"6\" width=\"614\" height=\"459\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/6.png 821w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/6-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/6-768x575.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -5:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3888\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/7.png\" alt=\"7\" width=\"614\" height=\"460\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/7.png 815w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/7-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/7-768x576.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -6:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3889\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/8.png\" alt=\"8\" width=\"614\" height=\"459\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/8.png 819w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/8-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/8-768x575.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Ad\u0131m -7:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3890\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/9.png\" alt=\"9\" width=\"614\" height=\"459\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/9.png 820w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/9-300x225.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/9-768x575.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -8:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3891\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/10.png\" alt=\"10\" width=\"614\" height=\"458\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/10.png 823w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/10-300x224.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/10-768x574.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>Ad\u0131m -9:<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3892\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/11.png\" alt=\"11\" width=\"614\" height=\"462\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/11.png 817w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/11-300x226.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/11-768x578.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Son ad\u0131mda ba\u015far\u0131l\u0131 olup SQL Server Veritaban\u0131m 2012 SP1 den a\u015fa\u011f\u0131dada g\u00f6r\u00fcnd\u00fc\u011f\u00fc gibi 2012 SP2 ye upgrade oldu.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3893\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2014\/07\/12.png\" alt=\"12\" width=\"614\" height=\"220\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/12.png 1057w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/12-300x108.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/12-768x275.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/07\/12-1024x367.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>B\u00f6ylece bir yaz\u0131n\u0131n daha sonuna gelmi\u015f bulunmaktay\u0131m bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle Esen kal\u0131n.<\/p>\n\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\">Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7&#215;24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span><span style=\"color: #ff0000;\">\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n<p><span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Veritaban\u0131 E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera Bak\u0131m ve Destek<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; SQL Server E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Goldengate E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Exadata E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Linux E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EBS E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle VM Server E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Weblogic E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle EPPM E\u011fitimleri<\/span><br \/>\n<span style=\"color: #ff0000;\">&#8211; Oracle Primavera E\u011fitimleri<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba Arkada\u015flar, Bu yaz\u0131mda sizlere Windows Server 2012 \u00fczerinde \u00e7al\u0131\u015fan SQL Server 2012 SP1 veritaban\u0131n\u0131n SQL Server 2012 SP2 (\u00a0Service Pack 2 ) ye upgrade edilmesini anlataca\u011f\u0131m. Bu Service Pack 2 Microsoft taraf\u0131ndan 10 haziran 2014 tarihinde yay\u0131nland\u0131 ve SQL Server 2012 RTM ve SP1 versiyonuna uygulanabilir. \u0130lgili Service Pack in download adresi bu linktedir. &hellip;<\/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":[508,1031,1515,1577,1600,1605,1606,1607,1671,1672],"class_list":["post-3895","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-deveci","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2012","tag-sql-server-2012-service-pack-2-upgrade","tag-sql-server-2012-sp1","tag-sql-server-2012-sp2","tag-sql-server-upgrade","tag-sql-server-upgrade-sp2"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3895","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=3895"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3895\/revisions"}],"predecessor-version":[{"id":5846,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/3895\/revisions\/5846"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=3895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=3895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=3895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}