Ubuchwepheshe bokuphindaphinda kwesifinyezo se- SQL Server kukuvumela ukuba uthumele ulwazi ngokuzenzekelayo phakathi kolwazi oluningi lwe- SQL Server . Le buchwepheshe kuyindlela enhle yokuthuthukisa ukusebenza kanye / noma ukuthembeka kwezinguquko zakho.
Kunezindlela eziningi ongazisebenzisa ngokuphindaphindiwe kwe-snapshot kuma-database wakho we-SQL Server. Isibonelo, ungasebenzisa lobu buchwepheshe ukuze unikeze idatha yedatha ezindaweni ezigciniwe ezisendaweni ezikude. Lokhu kuthuthukisa ukusebenza kwabasebenzisi bokugcina ngokubeka idatha endaweni yesikhungo esiseduze nabo futhi ngesikhathi esifanayo kunciphisa umthwalo ekuxhumaneni kwenethiwekhi ye-intersite.
Ukuphindaphinda kwesitatimende sokusabalalisa idatha
Ungase futhi usebenzise ukuphindaphinda kwesifinyelelo sokusabalalisa idatha kumaseva amaningi ngezinjongo zokulinganisela umthwalo. Isu elilodwa lokusakaza lokujwayelekile likwazi ukuthola ulwazi oluyisisekelo olusetshenziselwa yonke imibuzo yokuvuselela bese izinqolobane eziningana ezingezansi ezithola izifinyezo futhi zisetshenziswe kwimodi yokufunda kuphela ukunikeza idatha kubasebenzisi nezinhlelo zokusebenza. Okokugcina, ungasebenzisa ukuphindaphindiwe kwe-snapshot ukuze ubuyekeze idatha kwisiphakeli lesipele ukuze ulethwe ku-inthanethi uma kwenzeka iseva eyinhloko ihluleka.
Uma usebenzisa ukuphindaphindiwe kwe-snapshot, ukopisha yonke i-database kusuka kumshicileli we-SQL Server kuya kuma-SQL (ama-SQL Server) ama-SQL (s) ngesikhathi esisodwa noma esiqhubekayo. Uma uMbhalisile ethola isibuyekezo, lifaka ikhophi yayo yonke yedatha ngolwazi olwamukelwe kuMshicileli. Lokhu kungathatha isikhathi eside ngama dataset amakhulu futhi kubalulekile ukuthi uhlole ngokucophelela imvamisa kanye nesikhathi sokusatshalaliswa kwe-snapshot.
Isibonelo, ngeke ufune ukudlulisela ama-snapshots phakathi kwamaseva phakathi kwedatha ematasa kwinethiwekhi ehlanganisiwe kakhulu. Kungaba nokuhlakanipha okukhulu ukudlulisa ulwazi phakathi kobusuku lapho abasebenzisi bekhaya futhi bandwidth iningi.
Ukuqalisa Ukuphendula Ngokuzenzekelayo Kuyisinyathelo Esithathu
- Dala umthumeli
- Yakha le ncwadi
- Bhalisela kushicilelwe
Ungaphinda isinyathelo sokugcina sokwakha ubhalisile izikhathi eziningi kunesidingo ukuze udale bonke ababhalisile ongathanda. Ukuphindaphinda kwesitatimende kuyithuluzi elinamandla elikuvumela ukuba udlulise idatha phakathi kokufakwa kwe-SQL Server ebhizinisini lakho. Abafundisi abaxhunyiwe ngenhla bazokusiza ukuthi uqale ukuhambisa idatha ngehora lamahora.