【導(dǎo)讀】WiththeShaanxiExpresswayworkingtol,tolextensionbusinessisnoweighingchargesforstoragechargesdatabasesecurityandbackupofbusinessdatahasbeemoreprominent.Aftertwoyearsofoperation,moreandmoreawarenessoftheoperatingunitstodatabasestabiltyissuesisaproblemnottobeignored.Simpleexamplessuchas:failureoftheserversandatabases,generalmaintenanceandmanagementstaff,inmanycases,cannotbeindependentandquickrecovery,

　　

【正文】 u need t o select he r eal t ime synchr onization met hod of t he pr ogr amme. Typically backup system es wit h backup solut ions hould be pr ef er red. I f t he syst em es wit h a backup lan if it cannot m eet he r equir ement s, sof t war e developm ent methods is needed. Or t hir dpar ty sof t war e syst ems are select ed f or backup. Because t hir d par ty backup sof t war e is usualy pr iced ver y high, char ging unit s r equir e high pr ice, so f or only t he f ir st wo m et hods ar e s t udied below. use M S QL2020 synchronized backups of SQL 2020 dat abase in t hree ways, nam ely snapshot r eplication, t r ansactional r eplication and m erge r eplicat ion. By parison, excluding t he f ir st wo pr ogr amm es, select synchr onizat ion tr ansactional r eplicat ion and database Not hwind database, f or example, f or t esting. The t hr ee part s of t he main considerations in t he synchr onization of t he dat a, can be t hought of as t hr e hosts. The Publisher, Dist ribut or , and Subscriber。 can be under st od f r om t he lit eral m eaning, f unct ion is act ualy im plement ed t o keep subscriber s t hr ough t he Dist ribut or dat a t im ely and consi t ent dat a at t he Publisher. 1, about snapshot r eplication t o copy dat a changes inf r equently, or ar e not r equir ed t o keep t he data cur ent values ( low lat ency) , snapshot dat a is one of t he best m et hods of dat a r eplicat ion. When synchr onization ocurs, plet e snapshot is gener at ed and sent o t he Subscriber . Because snapshot r eplicat ion bulk copies r eleased ( it ems colection) a plete copy, it wil publish all wr it es made t o t he snapshot f older. Pr oj ect is t o specif y t hat you want o copy tables, dat a par ti ioning, or database obj ects. Pr oj ects can be a ful t able and cert ain columns ( using a vert ical f ilt er) , cert ain r ows ( using a horizont al f ilt er ), a st ored pr ocedur e or view def init ion, t he stored procedure execut ion, view, indexed, view, or user def ined f unction. Snapshot replication does not maint ain data t he f astest r eal tim e updates, and t he bulk copy released (it ems colection) af ul copy of t he mechanism wil generat e a lot of wor k t r af fic. Only small volumes of r eplication used, data is stat ic and does not need t o be updat ed in r eal t ime dat abase. So do not use snapshot replication t he synchr onization mode Dat a t able, add a new dat a f ield M Sr epl_tr an_ver sion, publishing soft war e depending on whet her t he cont ents of t his f ield changes t o det erm ine whet her you need t o publish t he data. And SQL 2020 data is m odifed j udging is managed by t he kernel, not f or exter nal pr ogr amming. Such as modif y t he str uct ur e of t he original dat a t able, adir ect r esult of r unni g lanes and m anagement sof t war e t hat doesn39。t wor k. Due t o t he above t est r esult s t o pr ove t hat t his cenario is not suit able as a backup m et hod f or working t ol system in Shaanxi Pr ovince. 5. 2 using specially developed backup sof t war e af ter t he above t ests, t hrough t he syst em39。s subscr iptions, publish m et hod in Shanxi pr ovince under t he wor king sof t war e sync backup, demand cannot be m et , backup soft war e so I decided t o use f or t he developm ent of synchronization, synchr onize backups. As a r esult of independent development, i has a high degree of f lexibilt y in backup. Easier f or seamless int egr ation wit h existing syst ems. Bac kup soft ware developed f or t he synchr onization, you m ust meet t he f ol wing r equir em ent s: in or der t o ensure synchr onous backup soft ware can start on Windows t art up, and ar e not easily shut down by t he oper at ion, it should be developed using a Windows ervice. Synchr onize backup sof t war e is t he soft war e t hat r uns 24 hours, must be able t o st eady oper ation. I n or der t o r educe wor k bandwidt h t o t he gr eat est degr ee in t he backup, and only need to back up the t oling system generates the new data t able. The backup soft war e should be able t o automatically f ilt er t he add new data in a dat abase t able, and synchr onized backups of dat a t hat meet s t he conditons of orm. Flags field of the cur rent char ging syst em using a dedicat ed Tr ansferMark, any kind of t ol sys tem softwar e af ter changing t he recor d, both on t he field is zero, this r ecord has been changed t o not ify other soft war e. Use t his field as a flag t o ident if y whether data has changed. I n addit ion to t his field, 目 錄 1 總 則 ............................................................................................................... 1 編制依據(jù) .................................................................................................. 1 適用范圍 .................................................................................................. 1 一般規(guī)定 .................................................................................................. 2 2 渠段膨脹土膨脹等級(jí)鑒定及處理措施現(xiàn)場調(diào)整 ......................................... 4 渠段膨脹等級(jí)劃分依據(jù) .......................................................................... 4 膨脹土等級(jí)現(xiàn)場判別 .............................................................................. 4 施工期膨脹土渠道處理的現(xiàn)場調(diào)整 ...................................................... 5 3 換填土料質(zhì)量復(fù)核與質(zhì)量要求 ..................................................................... 7 換填土料質(zhì)量復(fù)核 .................................................................................. 7 換填土土料質(zhì)量要求 .............................................................................. 8 4 膨脹土渠道地表及地下水處理 ..................................................................... 9 地下水特征 .............................................................................................. 9 地表水處理 ....