Ukuphindaphinda kwe-SQL Server kuvumela abaphathi be-database ukuba basakaze idatha kudatha amaseva amaningi kuyo yonke inhlangano. Ungase ufise ukusebenzisa ukuphindaphinda enhlanganweni yakho ngezizathu eziningana, njenge:
- Layisha ukulinganisa . Ukuphendulela kukuvumela ukuthi usakaze idatha yakho kumaseva amaningi bese usakaza umthwalo wombuzo phakathi kwalezo maseva.
- Ukuxhunyiwe okungaxhunyiwe ku-inthanethi Ukuphendulela kusekela ukuphatha idatha kusuka ku-database yakho kumshini ongeke uxhumeke kunethiwekhi.
- I-Redundancy . Ukuphendulela kukuvumela ukuba wakhe isiphakeli se-database ehlulekayo esilungele ukuthatha umthwalo wokucubungula kwesaziso somzuzwana.
Noma yikuphi isimo sokuphendulela sinezingxenye ezimbili eziyinhloko:
- Abashicileli banedatha yokunikela kwamanye amaseva. Uhlelo lokuphindaphinda olunikezwa lungaba nabamemezeli oyedwa noma ngaphezulu.
- Ababhalisile ngamaseva wedatha afisa ukuthola izibuyekezo ezivela kuMshicileli uma idatha ishintshiwe.
Akukho lutho oluvimbela uhlelo olulodwa ukuthi lungasebenzi kuzo zombili lezi zikhono. Eqinisweni, lokhu kuvame ukuklanywa kwezinhlelo ezinkulu zokusakaza ezigciniwe .
Ukusekela kwe-SQL Iseva yokuPhendula
I-Microsoft SQL Server isekela izinhlobo ezintathu zokuphindaphinda kwedatha. Lesi sihloko sinikeza isingeniso esifushane kulowo nalowo mfanekiso, kuyilapho izihloko ezizayo zizozihlola ngokuningiliziwe. Kunjalo:
- Ukuphindaphinda kwesitatimende kwenziwa ngendlela igama layo elichaza ngayo. Umshicileli uthatha isifinyezo se-database ephindaphindiwe futhi uyabelana nababhalisile. Yiqiniso, lena yisikhathi esiningi kakhulu nenqubo enamandla kakhulu. Ngenxa yalesi sizathu, abalawuli abaningi abasebenzisi ukuphindaphindiwe kwe-snapshot ngezizathu eziphindaphindiwe zezinqolobane ezishintsha njalo. Kunezimo ezimbili lapho ukuphindaphindiwe kwesifinyeto kuvame ukusetshenziswa: Okokuqala, isetshenziselwa yolwazi olungaguquki. Okwesibili, lisetshenziselwa ukusetha isisekelo sokuqala ukuphindaphinda phakathi kwezinhlelo ngenkathi izibuyekezo zesikhathi esizayo zisakazwa ngokusebenzisa ukuphindaphinda noma ukuhlanganisa ukuphindaphinda .
- Ukuphindaphindiwe komsebenzi kunikeza ikhambi eliguquguqukayo kakhulu yolwazi oluguqukayo njalo. Ngokuphindaphindiwe kwe-transactional, i-agent yokuphindaphinda ihlola umshicileli wezinguquko ku-database futhi idlulisela lezo zinguquko kubhalisile. Lokhu kuthunyelwa kungenziwa ngokushesha noma ngezikhathi ezithile.
- Ukuhlanganisa ukuphindaphinda kuvumela umshicileli kanye nombhalisi ukuba benze ngokuzimela ukuthi ushintshe ku-database. Zombili izinhlangano zingasebenza ngaphandle kokuxhumana kwenethiwekhi okusebenzayo. Uma zixhunyaniswa kabusha, i-agent yokubuyisela ukuhlanganiswa ihlola izinguquko kuzo zombili amasethingi wedatha futhi iguqule i-database ngayinye ngokufanele. Uma kushintsha ukungqubuzana, i-ejenti isebenzisa isichazamazwi sokuxazulula ukuxazulula izingxabano ukucacisa idatha efanelekile. Ukuhlanganisa ukuphindaphinda kuvame ukusetshenziswa abasebenzisi bekhompuyutha nabanye abangakwazi ukuxhumeka njalo kumshicileli.
Ngalinye lalezi zindlela zokuphindaphinda zisebenza ngenjongo ewusizo futhi zifanelana kahle nezimo ezithile zemininingwane.
Uma usebenza ne-SQL Server 2016, khetha uhlelo lwakho ngokusekelwe kuzidingo zakho zokuphindaphinda. Uhlelo ngalunye lunamakhono ahlukene uma kuziwa ekusekeleni ukuphindaphinda:
- Ukusekelwa kwe-Subscriber kuphela : Express, Express nge Amathuluzi noma Izinsizakalo Ezithuthukisiwe kanye nezinhlelo zeWebhu zinikeza amandla okuphindaphinda okulinganiselwe, akwazi ukwenza njengomplayenti wokuphindaphinda kuphela.
- Umshicileli ogcwele ne-Abhalisile : I- Standard ne- Enterprise inikeza ukusekelwa okugcwele, ne-Enterprise futhi ihlanganisa ukushicilelwa kwe-Oracle, ukubuka ukuphindaphinda kokuthengiselana, nokuphindaphinda kokuthengiselana njengokubhalisele okuvuselelwe.
Njengoba ngokungangabazeki waziwa ngaleli phuzu, amandla okuphindaphinda we-SQL Server anikezela abaqondisi be-database ithuluzi elinamandla lokuphatha nokwehliswa kokulondoloza ulwazi kwimvelo yebhizinisi.