Mapulani a Zondomeko Zamakono Amakulolani kuti muzitha kugwira ntchito zambiri zothandizira makina a Microsoft SQL Server . Mungathe kupanga mapulani okonzekera pogwiritsira ntchito njira yosavuta yofikira wizara popanda kudziwa za Transact- SQL .
Mungathe kuchita ntchito zotsatirazi mu ndondomeko yosamalira ma database:
- Kutsika kwa deta
- Kuyimira nsanja
- Kuchita chidziwitso chodziwitsa
- Kusintha zowerengera zamasamba
- Kuwonetsa umphumphu wa database
- Kuyeretsa mafayilo osungirako otsala
- Kugwiritsa ntchito ntchito ya Aganyu SQL Server
- Kuchita chiganizo cha Transact-SQL
- Kubweretsanso ndondomeko
- Yambiraninso ndondomeko
- Kuyeretsa mbiri zakale
01 a 07
Kuyambitsa Dongosolo la Maintenance Plan Wizard
Tsegulani Microsoft SQL Server Management Studio (SSMS) ndikuwonjezera foda ya Management. Dinani pa Foda ya Maintenance Plans ndikusankha Maintenance Plan Wizard kuchokera kumasewera apamwamba. Mudzawona chitseko choyamba cha wizara, monga momwe taonera pamwambapa. Dinani Zotsatira kuti mupitirize.
02 a 07
Tchulani Ndondomeko Yokonzekera Malemba
Pulogalamu yotsatira yomwe ikuwonekera, perekani dzina ndi ndondomeko ya ndondomeko yanu yosungirako zinthu. Muyenera kupereka zambiri pano zomwe zingakhale zothandiza kwa woyang'anira wina (kapena nokha!) Amene akuyesera kuzindikira cholinga cha miyezi kapena zaka kuchokera pano.
03 a 07
Sungani dongosolo lanu la Database Maintenance Plan
Mwinamwake mukufuna kugwiritsa ntchito njira yosasinthika pano "Ndandanda yosawerengera ya dongosolo lonse kapena ndondomeko iliyonse". Muli ndi mwayi wopanga ndondomeko zosiyanasiyana za ntchito zosiyanasiyana, koma ndimakonda kupanga ndondomeko zosiyanasiyana za ndondomeko zosiyanasiyana kuti ndithetse zinthu.
Dinani Bulu Lomasintha kuti musinthe ndondomeko yosasinthika ndikusankha tsiku ndi nthawi yomwe ndondomekoyi idzachita. Dinani Bulu Lotsatira pamene mwatsiriza.
04 a 07
Sankhani Ntchito za Mapulani Anu
Mudzawona zenera zomwe zasonyezedwa pamwambapa. Sankhani ntchito zomwe mukufuna kuziika mu ndondomeko yanu yosungirako zinthu. Mukatsiriza, dinani Pambuyo Lomwe kuti mupitirize.
05 a 07
Kukonzekera Ntchito M'dongosolo la Maintenance Plan
Window yotsatira, yomwe ili pamwambapa, ikulolani kuti musinthe dongosolo la ntchito mu ndondomeko yanu yokonza pogwiritsa ntchito mabatani omwe amatsitsimula ndikukwera pansi.
06 cha 07
Konzani Ndondomeko ya Ntchito ya Mapulani
Kenaka, mudzakhala ndi mwayi wokonza tsatanetsatane wa ntchito iliyonse. Zomwe mwasankha zimasiyanasiyana malinga ndi ntchito zomwe mwasankha. Chithunzichi pamwamba chikuwonetsa chitsanzo cha chinsalu chomwe chikugwiritsidwa ntchito kukonza ntchito yobwezera. Mukatsiriza, dinani Pambuyo Lomwe kuti mupitirize.
07 a 07
Sankhani Njira Yoganizira Mapulani
Potsiriza, muli ndi mwayi wokhala ndi SQL Server kulengeza lipoti nthawi iliyonse yomwe mapulaniwa akupanga zotsatira zowonjezera. Mungasankhe kuti lipotili lilembedwe kwa wosuta kudzera pa e-mail kapena kusungidwa ku fayilo yolemba pa seva.