Izinhlelo Zokugcinwa Kwemigomo Yokulondolozwa Kwemigomo ikuvumela ukuba ulungise imisebenzi eminingi yokuphatha idatha ku- Microsoft SQL Server . Ungakha izinhlelo zokondla usebenzisa inqubo elula ye-wizard ngaphandle kolwazi lwe-Transact- SQL .
Ungenza imisebenzi elandelayo ngaphakathi kwepulani lokugcinwa kwedatha:
- Ukunciphisa i-database
- Ukusekela i-database
- Ukwenza isaziso se-opharetha
- Ibuyekeza izibalo ze-database
- Ukuqinisekisa ubuqotho be-database
- Ukuhlanza amafayela wokugcina asele
- Ukusebenzisa umsebenzi we-Agent SQL Server
- Ukusebenzisa isitatimende se-Transact-SQL
- Buyela kabusha inkomba
- Hlela kabusha i-index
- Ukuhlanza imininingo yemininingwane yedatha
01 ngo-07
Ukuqala iWebhu yeSondlo seSondlo seDatabase
Vula i-Microsoft SQL Server Management Studio (SSMS) futhi wandise ifolda yokuphatha. Chofoza ngakwesokudla kwifolda ye-Maintenance Plans bese ukhetha u-Maintenance Plan Wizard kusuka kwimenyu e-pop-up. Uzobona isikrini sokuvula se-wizard, njengoba kuboniswe ngenhla. Chofoza Okulandelayo ukuze uqhubeke.
02 ngo-07
Yisho Uhlelo Lokugcinwa Kwemininingwane Yedatha
Esikrinini esilandelayo esivela, nikeza igama nencazelo yesicwangciso sakho sokugcinwa kwedatha. Kufanele unikeze ulwazi lapha oluzosiza omunye umlawuli (noma wena ngokwakho!) Ozama ukuthola injongo yezinyanga noma iminyaka kusukela manje.
03 ka-07
Hlela uhlelo lwakho lokugcinwa kwedatha
Mhlawumbe ufuna ukusebenzisa okukhethwa kukho okuzenzakalelayo lapha "Uhlelo olulodwa lwepulani lonke noma akukho schedule". Unakho ukhetho lokudala amashejuli ahlukene wemisebenzi ehlukene, kodwa ngikhetha ukudala izinhlelo ezihlukene zamashejuli ahlukene ukusiza ukugcina izinto ziqonde.
Chofoza inkinobho yokushintsha ukuze ushintshe isimiso esizenzakalelayo bese ukhetha usuku nesikhathi uhlelo oluzokwenza. Chofoza inkinobho elandelayo uma usuqedile.
04 ka 07
Khetha Imisebenzi yohlelo lwakho lokulondoloza
Uzobona iwindi eliboniswe ngenhla. Khetha umsebenzi (s) ofuna ukufaka kuwo ohlelweni lwakho lokugcinwa kwedatha. Uma uqedile, chofoza inkinobho elandelayo ukuze uqhubeke.
05 ka-07
Ukuhleleka Imisebenzi Kuhlelo Lokugcinwa Kwemininingwane
Iwindi elilandelayo, elikhonjisiwe ngenhla, likuvumela ukuba ushintshe ukuhleleka kwemisebenzi ohlelweni lwakho lokunakekela ngokusebenzisa izinkinobho ezihamba phambili ze-Move Up and Move Down.
06 ka-07
Lungiselela imininingwane yohlelo lomsebenzi
Okulandelayo, uzothola ithuba lokulungisa imininingwane yomsebenzi ngamunye. Izinketho ezinikezwe kuwe zizohluka ngokusekelwe emisebenzini oyikhethile. Isithombe esingenhla sibonisa isibonelo sesibuko esetshenziselwa ukumisa umsebenzi wokusekelayo. Uma uqedile, chofoza inkinobho elandelayo ukuze uqhubeke.
07 ka-07
Khetha Izinketho Zokubika Ukuhlela Isu
Okokugcina, unayo ikhono lokuba ne-SQL Server yakha umbiko njalo lapho uhlelo lusebenza luqukethe imiphumela eningiliziwe. Ungakhetha ukuthi lo mbiko uthunyelwe kumsebenzisi nge-e-mail noma ulondolozwe efayeleni yombhalo kuseva.