{"id":314,"date":"2025-11-18T08:53:46","date_gmt":"2025-11-18T08:53:46","guid":{"rendered":"https:\/\/kriweb.info\/bilgi-bankasi\/sql-server-management-studio-2014-ile-veritabani-yedegi-alma-ve-geri-yukleme-mssql-backup-restore\/"},"modified":"2025-12-01T09:37:44","modified_gmt":"2025-12-01T09:37:44","slug":"mssql-veritabani-yedegi-alma-ve-geri-yukleme","status":"publish","type":"post","link":"https:\/\/kriweb.com\/bilgi-bankasi\/mssql-veritabani-yedegi-alma-ve-geri-yukleme\/","title":{"rendered":"MSSQL Veritaban\u0131 Yede\u011fi Alma ve Geri Y\u00fckleme"},"content":{"rendered":"

Veri g\u00fcvenli\u011fi, bir web projesinin en hayati par\u00e7as\u0131d\u0131r. MSSQL veritaban\u0131 yede\u011fi alma<\/b> i\u015flemi, sunucu de\u011fi\u015fikli\u011fi yaparken veya olas\u0131 veri kay\u0131plar\u0131na kar\u015f\u0131 alabilece\u011finiz en g\u00fc\u00e7l\u00fc \u00f6nlemdir. Microsoft SQL Server kullanan projelerde, veritaban\u0131 y\u00f6netimi genellikle SQL Server Management Studio (SSMS)<\/b> aray\u00fcz\u00fc \u00fczerinden yap\u0131l\u0131r.<\/p>\n

Bu rehberde, SSMS 2014 s\u00fcr\u00fcm\u00fcn\u00fc kullanarak veritaban\u0131n\u0131z\u0131 nas\u0131l yedekleyece\u011finizi (Backup) ve mevcut bir yede\u011fi nas\u0131l geri y\u00fckleyece\u011finizi (Restore) ad\u0131m ad\u0131m inceleyece\u011fiz.<\/p>\n

B\u00f6l\u00fcm 1: MSSQL Veritaban\u0131 Yede\u011fi Alma (Backup)<\/h4>\n

Veritaban\u0131n\u0131z\u0131n tam bir kopyas\u0131n\u0131 olu\u015fturmak i\u00e7in \u00f6ncelikle<\/b> bilgisayar\u0131n\u0131zda SQL Server Management Studio program\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n ve sunucuya ba\u011flan\u0131n. Ard\u0131ndan<\/b> \u015fu ad\u0131mlar\u0131 takip edin:<\/p>\n

    \n
  1. \n

    Veritaban\u0131 Se\u00e7imi:<\/b> Sol taraftaki “Object Explorer” men\u00fcs\u00fcnde bulunan Databases<\/b> klas\u00f6r\u00fcn\u00fc geni\u015fletin. Yede\u011fini almak istedi\u011finiz veritaban\u0131n\u0131n \u00fczerine sa\u011f t\u0131klay\u0131n.<\/p>\n<\/li>\n

  2. \n

    Backup Men\u00fcs\u00fc:<\/b> A\u00e7\u0131lan men\u00fcden s\u0131ras\u0131yla Tasks > Back Up…<\/b> se\u00e7eneklerine t\u0131klay\u0131n.<\/p>\n<\/li>\n

  3. \n

    Ayarlar\u0131n Yap\u0131land\u0131r\u0131lmas\u0131:<\/b> Kar\u015f\u0131n\u0131za \u00e7\u0131kan pencerede “Backup type” k\u0131sm\u0131n\u0131n Full<\/b> olarak se\u00e7ili oldu\u011fundan emin olun.<\/p>\n<\/li>\n

  4. \n

    Hedef Belirleme:<\/b> Pencerenin alt\u0131ndaki “Destination” (Hedef) b\u00f6l\u00fcm\u00fcnde, yede\u011fin .bak<\/code> uzant\u0131l\u0131 olarak nereye kaydedilece\u011fini se\u00e7in.<\/p>\n<\/li>\n

  5. \n

    \u0130\u015flemi Tamamlama:<\/b> Ayarlar\u0131 kontrol ettikten sonra OK<\/b> butonuna bas\u0131n.<\/p>\n<\/li>\n<\/ol>\n

    Sonu\u00e7 olarak<\/b>, i\u015flem tamamland\u0131\u011f\u0131nda ekrana “The backup of database completed successfully” uyar\u0131s\u0131 gelecektir.<\/p>\n

    B\u00f6l\u00fcm 2: MSSQL Veritaban\u0131 Geri Y\u00fckleme (Restore)<\/h4>\n

    Elinizdeki bir .bak<\/code> dosyas\u0131n\u0131 sunucuya y\u00fcklemek veya eski yede\u011fe d\u00f6nmek istiyorsan\u0131z “Restore” i\u015flemini uygulaman\u0131z gerekir. Bunun i\u00e7in<\/b> a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n

      \n
    1. \n

      Ba\u015flang\u0131\u00e7:<\/b> SSMS 2014’\u00fc a\u00e7\u0131n ve sol men\u00fcdeki Databases<\/b> klas\u00f6r\u00fcne sa\u011f t\u0131klay\u0131n. Men\u00fcden Restore Database…<\/b> se\u00e7ene\u011fini i\u015faretleyin.<\/p>\n<\/li>\n

    2. \n

      Kaynak Se\u00e7imi:<\/b> A\u00e7\u0131lan ekranda “Source” b\u00f6l\u00fcm\u00fcndeki Device<\/b> kutucu\u011funu i\u015faretleyin. Yan\u0131ndaki “…” butonuna t\u0131klayarak bilgisayar\u0131n\u0131zdaki .bak<\/code> uzant\u0131l\u0131 yedek dosyas\u0131n\u0131 se\u00e7in.<\/p>\n<\/li>\n

    3. \n

      Hedef Veritaban\u0131:<\/b> “Destination” k\u0131sm\u0131nda, yede\u011fin hangi veritaban\u0131 \u00fczerine yaz\u0131laca\u011f\u0131n\u0131 se\u00e7in (Mevcut bir DB se\u00e7ebilir veya yeni bir isim yazabilirsiniz).<\/p>\n<\/li>\n

    4. \n

      \u00dczerine Yazma \u0130zni:<\/b> Bu ad\u0131m \u00e7ok \u00f6nemlidir;<\/b> sol men\u00fcden Options<\/b> sekmesine ge\u00e7in. “Overwrite the existing database (WITH REPLACE)” se\u00e7ene\u011fini i\u015faretleyin. Bu, mevcut veritaban\u0131n\u0131n \u00fczerine yaz\u0131lmas\u0131na izin verir.<\/p>\n<\/li>\n

    5. \n

      Biti\u015f:<\/b> OK<\/b> butonuna t\u0131klayarak geri y\u00fcklemeyi ba\u015flat\u0131n.<\/p>\n<\/li>\n<\/ol>\n

      Kar\u015f\u0131la\u015f\u0131labilecek Hatalar ve \u0130pu\u00e7lar\u0131<\/h4>\n

      Geri y\u00fckleme (Restore) i\u015flemi s\u0131ras\u0131nda “Database is in use” (Veritaban\u0131 kullan\u0131mda) hatas\u0131 alabilirsiniz. Bunun nedeni<\/b>, veritaban\u0131na o an ba\u015fka bir kullan\u0131c\u0131n\u0131n veya uygulaman\u0131n ba\u011fl\u0131 olmas\u0131d\u0131r.<\/p>\n