Maintenance Maintenance Plans anokubvumira kuti uite mazita akawanda ekuchengetedzwa kwemashoko eDynamic SQL Server . Iwe unogona kugadzira zvirongwa zvekugadzirisa uchishanda nyore wizard-based process pasina ruzivo rwe Transact- SQL .
Iwe unogona kuita mabasa anotevera mukati meurongwa hwekuchengetedza database:
- Kupera hodha
- Kutsigira up database
- Kuita chiziviso chekushandisa
- Kudzokorora nhamba dze database
- Kutsigira kutendeseka kwepa database
- Kuchenesa up zvakasara kugadzirisa mafaira
- Kuita basa reSagL Server Agent
- Kuita shanduro yeStact-SQL
- Kuvakazve nyanzvi
- Kugadzirisa rondedzero
- Kuchenesa up database histories
01 of 07
Kutanga Database Database Maintenance Plan Wizard
Vhura Microsoft SQL Server Management Studio (SSMS) uye wedzera Folder Management. Tsvaga pakarurama pane Maintenance Plans folda uye sarudza Maintenance Plan Wizard kubva mumusangano we-pop-up. Iwe uchaona chinyorwa chekuvhara wizard, sezvakaratidzwa pamusoro apa. Dzvanya Zvitevera kuti uende.
02 of 07
Itai Zita rekugadzirisa Maintenance Plan
Muchirongwa chinotevera chinowanika, ita zita uye tsanangudzo yeurongwa hwekuchengetedza database. Iwe unofanirwa kugovera ruzivo pano izvo zvichabatsira kune mumwe mutungamiri (kana iwe pachako!) Ari kuedza kufungidzira chinangwa chegadziro yemwedzi kana makore kubva zvino.
03 of 07
Ronga Purogiramu yako yeDatabase yekuGadzirira
Iwe unogona kunge uchitsvaga kushandisa sarudzo yakasarudzwa pano "Single purogiramu yepurogiramu yose kana purogiramu". Iwe unenge uine sarudzo yekusika sarudzo dzakasiyana dzemabasa akasiyana, asi ini ndinosarudza kugadzira zvirongwa zvakasiyana zvezvirongwa zvakasiyana kuti ndibatsire kuchengeta zvinhu zvakananga.
Dzvanya bhatani Rinochinja kuti uchinje purogiramu isina kukwana uye sarudza zuva uye nguva chirongwa chichaita. Dzvanya Bhokisi rinotevera kana wapedza.
04 of 07
Sarudza Mabasa ekugadzirisa Maintenance Plan yako
Iwe uchaona hwindo rakaratidzwa pamusoro. Sarudza basa (s) raunoda kuisa muurongwa hwekuchengetedza database. Pawakapedza, tora bhora rinotevera kuti uenderere mberi.
05 of 07
Kurayira Mabasa muDatabase Database Maintenance Plan
Iwindo rinotevera, rinoratidzwa pamusoro, rinokubvumira kuti uchinje urongwa hwemabasa muurongwa hwako hwekugadzirisa uchishandisa Mafambiro Edza kumusoro uye Enda Pasi.
06 of 07
Rongedza Hurongwa hweShoko Remaitiro
Zvadaro, uchava nemukana wekugadzirisa zvinhu zvebasa rimwe nerimwe. Zvisarudzo zvaunopiwa kwauri zvichasiyana zvichienderana nemabasa awakasarudza. Mufananidzo wacho pamusoro apa unoratidza muenzaniso wekrini yakashandiswa kugadzirisa basa rekuchengetedza. Pawakapedza, tora bhora rinotevera kuti uenderere mberi.
07 of 07
Sarudza Maintenance Plan Kupa Zvokuita
Pakupedzisira, iwe unokwanisa kuva neSQL Server unopa mushumo nguva imwe neimwe purogiramu inoshandisa ine zvinyorwa zvakajeka. Iwe ungasarudza kuva nemharidzo iyi yakatumirwa kumushandisi kuburikidza ne e-mail kana kuti yakachengetedzwa kune text file pane seva.