Amamodeli Wokubuyisela Balance Space Disk Against Complete Log Amafayela
Iseva ye-SQL inikeza amamodeli amathathu wokutakula okuvumela ukuthi ucacise indlela i-SQL Server ilawula ngayo amafayela angena ngemvume futhi ilungisa imininingwane yakho yokuthola ngemuva kokulahlekelwa kwedatha noma enye inhlekelele. Ngayinye yalezi zimelela indlela ehlukile yokulinganisa i-tradeoff phakathi kokulondoloza isikhala sediski nokuhlinzekela izinketho zokutakula izinhlekelele. Amamodeli amathathu okubuyiselwa kwezinhlekelele ahlinzekwa yi-SQL Server yilezi:
- Okulula
- Okuphelele
- Okungenwe ngobuningi
Ake sibheke ngayinye yalezo zibonelo ngokuningiliziwe.
Isibonelo Sokubuyisela Okulula
Imodeli elula yokutakula iwukuthi: elula. Kule ndlela, i-SQL Server igcina kuphela ulwazi oluncane lokungena kulogi lokuthenga. Iseva ye-SQL igxila irekhodi lokuthengiselana ngaso sonke isikhathi i-database ifinyelela kokuhlola kokuthengiselana, engashiyi ukungena kwamangena ngezinjongo zokutakula izinhlekelele.
Ukuze uthole ulwazi olusezingeni elilula lokubuyisela, ungabuyisela izipele ezigcwele noma ezihlukile. Akunakwenzeka ukubuyisela imininingwane enjalo kuphuzu elinikeziwe ngesikhathi - ungabuyisela kuphela ngesikhathi esiqondile lapho kwenzeka ukusekela okugcwele noma okuhlukile. Ngakho-ke, uzolahlekelwa ngokuzenzekelayo noma yikuphi ukuguqulwa kwedatha okwenziwe phakathi kwesikhathi sokusekela okuphelele / okuhlukile kokusabalalisa nesikhathi sokuhluleka.
Isibonelo sokubuyisela okugcwele
Imodeli elula yokutakula ibuye ibe negama elizichazayo. Ngalesi simodeli, i-SQL Server igcina irekhodi lokuthengiswa kuze kube yilapho uyiphakamisa. Lokhu kukuvumela ukuba uhlele uhlelo lokutakula izinhlekelele oluhlanganisa inhlanganisela yezipele ezigciniwe ezigcwele nezihlukile ngokubambisana nezipele zokungena ngemvume.
Uma kwenzeka ukuhluleka kwedatha, unesimo esivumelana kakhulu nokubuyiselwa yolwazi usebenzisa imodeli yokutakula ngokugcwele. Ngaphezu kokulondoloza ukuguqulwa kwedatha okugcinwe kulogi lokuthengiselana, imodeli yokutakula egcwele ikuvumela ukuba ubuyisele idatha kumaphuzu athile ngesikhathi. Isibonelo, uma ukuguqulwa okungalungile kwonakalisa idatha yakho ngo-2: 36 ekuseni ngoMsombuluko, ungasebenzisa iphuzu-in-time yokubuyisela i-SQL Server ukuze uvuselele imininingwane yakho kuze kube ngu-2: 35 ekuseni, ususe imiphumela yephutha.
Isibonelo sokubuyiswa kokungena ngemvume
Imodeli yokutakula eningi kakhulu iyimodeli ekhethekile ehlose ukuthi isebenza ngendlela efanako kumodeli wokutakula okugcwele. Umehluko okuwukuphela kwindlela olawula ngayo imisebenzi yokuguqulwa kwedatha eningi.Isibonelo esiningi esinamarekhodi siloba lokhu kusebenza kulogi lokuthengiselana besebenzisa inqubo eyaziwa ngokuthi i- minimal logging . Lokhu kusindisa kakhulu ngesikhathi sokucubungula, kodwa kukuvimbela ekusebenziseni iphuzu lokubuyisela isikhathi.
I-Microsoft ikhuthaza ukuba imodeli yokutakula eningi kakhulu isetshenziselwe isikhathi esifushane. Imikhuba engcono kakhulu ibonisa ukuba ushintshe i-database kumodeli wokutakula okunamandla ngokushesha ngaphambi kokwenza imisebenzi eningi futhi uyibuyisele esimisweni sokubuyisela ngokugcwele uma lezo zenzo ziphelele.
Ukushintsha Amamodeli Wokutakula
Sebenzisa iSQL Server Management Studio ukubuka noma ukushintsha imodeli yokutakula:
- Khetha iseva efanelekile : Xhuma kwisimo esifanele se-SQL Server Database Engine, bese ku-Object Explorer, chofoza igama leseva ukwandisa isihlahla sevava.
- Khetha i-database : Nwebisa imininingwane , futhi, ngokuya kwedatha, ungakhetha idatha yomsebenzisi noma ukwandise imininingwane yolwazi bese ukhetha idatha yesistimu.
- Vula izakhiwo ze-Database : Chofoza ngakwesokudla database, bese uchofoza Properties , ukuvula ibhokisi lengxoxo ye- Properties ibhokisi.
- Buka i-Model Recovery yamanje : Khetha Khetha ikhefu, chofoza Izinketho ukuze ubuke ukukhetha imodeli yokubuyisela yamanje.
- Khetha i-Model Yokubuyisela entsha : Khetha noma Okugcwele , Okunamalini-Okungenayo , noma Okulula .
- Chofoza OK .