Recovery Models Balance Disk Space Kurwisa Complete Log Files
SQL Server inopa zvitatu zvekudzorera zvinokubvumira kutsanangura nzira iyo SQL Server inogadzirisa mafaira ekugogodza uye inogadzira database yako yekugadzirisa mushure mekurasikirwa kwemashoko kana imwe njodzi. Chimwe chezvinhu izvi chinomirira nzira yakasiyana yekuenzanidza tradeoff pakati pekuchengetedza disk nzvimbo nekupa maitiro ekugadzirisa njodzi. Iyo mitatu mitatu yekudzorera njodzi inopiwa neSQL Server ndeyi:
- Zviri nyore
- Yakazara
- Bulk-logged
Ngatitarisei pane imwe neimwe yeiyo mienzaniso mune mamwe mashoko.
Nyore Kudzokorora Muenzaniso
Izvo zvinyorwa zvinoshandiswa pakufambisa ndizvo chete: zviri nyore. Munzira iyi, SQL Server inongova nehuwandu hwehuwandu hwemashoko mubhuku rekutengesa. SQL Server inotora zvinyorwa zvekutengesa nguva imwechete iyo database ichisvika pakatarisa kwekutengesa, kusasiya manyoreji egiyo nekuda kwekugadzirisa njodzi.
Kune databases uchishandisa iri nyore kuratidza muenzaniso, unogona kudzorera zvizere kana kuti zvakasiyana-siyana mabhakkudzi chete. Hazvigoneki kudzorera dhidhiyo yakadaro pane imwe nguva panguva - iwe unogona kungoidzorera panguva chaiyo apo kubhadhara kwakazara kana kusiyanisa kwakaitika. Nokudaro, iwe uchange uchingorasikirwa chero hupi hwekushandurwa kwemashoko huripo pakati penguva yekupedzisira yakakwana / yakasiyana-siyana yekuchengetedza uye nguva yekukundikana.
Yakazara yekudzorera muenzaniso
Muenzaniso wekugadzirisa zvakare unobata zita rinodonongodza. Neyu muenzaniso, SQL Server inodzivirira gwaro rekutengesa kusvikira iwe uchidzokorora. Izvi zvinokubvumira iwe kugadzira hurongwa hwekugadzirisa njodzi hunosanganisira kusanganiswa kwezvakazara uye zvakasiyana-siyana zvekuchengetedza zvinyorwa pamwe chete nekutengesa mabhuku ekuregeresa.
Kana muchiitiko chekukundikana kwepa database, iwe unoshandura mafungiro ekudzokorora zvinyorwa zvekushandisa uchitsvaga mufananidzo. Mukuwedzera pakachengetedza kudhindwa kwezvinhu zvakachengetwa mubhuku rekutengesa, maitiro akazara ekudzorera anokubvumira kuti udzorere dhesikisi kune imwe nzvimbo panguva. Somuenzaniso, kana kugadzirisa kusina kukanganisa kwakasvibisa data yako pa2: 36 mangwanani musi weMuvhuro, unogona kushandisa SQL Server's point-in-time rekudzorera kuti usvitse d database yako kusvika 2:35 am, kubvisa migumisiro yekanganiso.
Bhuku Rekutsvaga Rakabatanidzwa
Iyo yakawanda-logged recovery model ndiyo muenzaniso chaiwo-chinangwa unoshanda nenzira imwecheteyo kumutambo wakakwana wokutora. Misiyano bedzi iri munzira iyo inobata nayo kuwanda kwekushandurwa kwemashoko ekugadzirisa. Mhando yakawanda-yakanyorwa inodzokorora maitiro aya mubhuku rekutengesa uchishandisa nzira inozivikanwa sekunyoresa kutsemura . Izvi zvinoponesa zvakanyanya pakugadzirisa nguva, asi zvinokudzivirira kubva kushandisa iko-in-nguva kudzorera kusarudzwa.
Microsoft inokurudzira kuti mienzaniso yakawanda yekuchengetedza inoshandiswa chete kwenguva pfupi. Unyanzvi huri nani hunotaurira kuti iwe uchinje dhesi yepamusoro kune yakakura-logged recovery model nguva pfupi musati maita mabasa makuru uye muchidzosera kumutambo wakakwana wekugadzirisa apo mabasa aya akazadza.
Kuchinja Kuvandudza Mienzaniso
Shandisa SQL Server Management Studio kuti uone kana kuchinja mufananidzo wokutora:
- Sarudza iyo yakakodzera server : Unganidza pane zvakakanganisika zveSQL Server Database Engine, ipapo muIndaneti Explorer, chengetedza zita revharesi kuti uwedzere seriva.
- Sarudza database : Wedzera Databases , uye, zvichienderana ne database, kana kusarudza database yevashandi kana kuwedzera System Databases uye sarudza dhidhiyo yehurongwa.
- Vhura Properties Properties : Kurudyi-kanda dhesi, uye ipapo chengetedza Properties , kuti uzarurire Dzimba Dhauriro yepaIndaneti.
- Ona ikozvino Recovery Model : In the Select a page pane, chofoza Options kuti uone ikozvino Kuwana muenzaniso wekutsvaga.
- Sarudza mutsva wekutsvaga mutsva : Sarudza kana Chizere , Chikwata -chikwata , kana Chiri nyore .
- Dzvanya OK .