Iimodeli zokubuyisela Balance Space Disk Space Against Complete Files Log
I-SQL Server inika imizekelo emithathu yokubuyisela evumela ukuba ucacise indlela iSQL Server ilawula ngayo iifayile zelogi kwaye ilungiselela i-database yakho yokubuyisela emva kokulahlekelwa kwedatha okanye enye inhlekelele. Ngalunye lwezi zimela indlela eyahlukileyo yokulinganisa i-tradeoff phakathi kokugcinwa kwesithuba sediski nokubonelela ngeendlela zokubuyisela inhlekelele. Iimpawu ezintathu zokubuyiselwa kweentlekele ezinikezwa yi-SQL Server zi:
- Elula
- Epheleleyo
- Ingeniso ebhaliweyo
Makhe sijonge nganye nganye yale mizekelo ngeenkcukacha ezingakumbi.
Umzekelo Wokubuyiswa Okulula
Imodeli yokubuyisela elula yileyo: elula. Kulo ndlela, i-SQL Server igcina kuphela inani elincinci lolwazi kwi-log log. I-SQL Server iqwalasela ingxelo yokuthengwa rhoqo ngexesha i-database ifinyelela kwiphepha lokujonga, ukushiya ukungena kwamangeniso okungena kwiinjongo zokubuyisela inhlekelele.
Ukufumana iinkcukacha zolwazi ngokulandelelana okulula, unokubuyisela iifayile ezipheleleyo okanye ezahlukileyo. Akunakwenzeka ukubuyisela i-database eneenkcukacha kwinqanaba elithile ngexesha - unokulibuyisela ngexesha elichanekileyo xa kubakho ukugcinwa okupheleleyo okanye okuhlukileyo. Ngoko ke, uzakulahlekelwa ngokuzenzekelayo nayiphi na iinguqulelo zedatha ezenziwe phakathi kwexesha lokugqibela lokugcina kunye / nexesha lokusilela.
Umzekelo Wokubuyisela
Imodeli yokubuyisela epheleleyo ibuye ibe negama elichazayo. Ngalo mzekelo, i-SQL Server igcina ingxelo yomthengi de uze uyibuyisele. Oku kukuvumela ukuba uyile uyilo lokubuyisela inhlekelele elibandakanya ukudibanisa izigcawu ezigciniweyo ezipheleleyo kunye neenkcukacha ngokubambisana kunye neenkcukacha zokungena kwi-log log.
Xa kwenzeka ukungaphumeleli kwedatha, unakho ukulungelelanisa ukubuyisela iinkcukacha ngokusebenzisa imodeli yokubuyisela ngokupheleleyo. Ukongezelela ekugcineni ukuguqulwa kwedatha egcinwe kwirekhodi yokuthengiselana, imodeli yokubuyisela ngokupheleleyo ikuvumela ukuba ubuyisele i-database kwindawo ethile ngexesha. Umzekelo, ukuba ukuguqulwa okungekho nto kwonakalise idatha yakho ngo-2: 36 ngoMsombuluko, ungasebenzisa i-point-in-time ye-SQL Server ukubuyisela i-database yakho emva kwe-2: 35 ekuseni, ukusula umphumo wephutha.
Umzekelo Wokubuyisela Umnxeba
Imodeli yokubuyisela emaninzi yinkqubo ekhethekileyo eyenza ukuba isebenze ngendlela efana nesimo sokubuyisela ngokupheleleyo. Ukwahlukana nje kuphela kwindlela ekusingatha ngayo imisebenzi yokuguqulwa kwedatha ngobuninzi.Imodeli engena ngobuninzi ibhalela le mi sebenzi kwimiqulu yokuthengiselana isebenzisa inqubo eyaziwa ngokuba yilogi . Oku kusindisa kakhulu ngexesha lokucwangcisa, kodwa kukuthintela ukusebenzisa i-point-in-time yokubuyisela inketho.
UMicrosoft uncoma ukuba imodeli yokubuyisela i-bulk isetyenziswe kuphela ixesha elifutshane. Iindlela ezilungileyo zifuna ukuba utshintshe i-database kwi-model yokutakula ngokukhawuleza ngaphambi kokuqhuba imisebenzi eninzi kwaye uyibuyisele kwimodeli yokubuyisela ngokupheleleyo xa loo mi sebenzi iphelele.
Ukutshintsha iiModeli zokuPhinda
Sebenzisa iSquL Server Management Studio ukujonga okanye utshintshe imodeli yokubuyisela:
- Khetha umncedisi ochaphazelekayo : Xhuma kumzekelo ofanelekileyo we-Injini yeDatabase yeSquL Server, ngoko kwi-Object Explorer, cofa igama lomncedisi ukwandisa umthi womncedisi.
- Khetha isiseko sedatha : Yandisa iiNgcaciso , kwaye, ngokuxhomekeke kwisiseko sedatha, khetha i-database yolwazi okanye ukwandisa i- System yolwazi kunye nokukhetha iinkcukacha zeenkcukacha.
- Vula i-Properties Properties : nqakraza kwesokudla kwi database, kwaye nqakraza i- Properties , ukuvula ibhokisi yencoko yababini beDatabase.
- Jonga iModeli Yokubuyisela yangoku : Khetha Ikhefu lephepha , nqakraza Izinketho ukujonga ukhetho olukhoyo lwangoku lokubuyisela .
- Khetha umzekelo omtsha wokubuyisela : Khetha Okupheleleyo , Okubhaliweyo , okanye Okulula .
- Chofoza OK .