Momwe Mungasungire ndi Kubwezeretsa Ma Database mu SQL Server
SQL Server ndi njira yoyendetsera deta (DBMS) yomwe imagwiritsidwa ntchito kwambiri padziko lonse lapansi pa IT poyang'anira deta. Kusunga ndi kubwezeretsa deta ndi ntchito ziwiri zofunika kwambiri zomwe woyang'anira deta ayenera kumvetsetsa kuti atsimikizire chitetezo cha deta ndikubwezeretsa deta pakagwa vuto la dongosolo, kuwonongeka, kapena kutayika kwa deta. Nkhaniyi ifotokoza njira zosungira deta ndikubwezeretsa deta mu SQL Server mwatsatanetsatane komanso momveka bwino.
N’chifukwa chiyani Kusunga ndi Kubwezeretsa Zinthu N’kofunika?
Kusunga deta kuchokera ku database kupita kumalo otetezeka. Izi ndizofunikira kuti deta isatayike chifukwa cha kulephera kwa hardware, zolakwika za anthu, kuukira kwa pulogalamu yaumbanda, kapena masoka achilengedwe. Kubwezeretsa deta kuchokera ku backup kupita ku system yoyambirira kapena yatsopano kuti database ibwezeretsedwe momwe inalili poyamba.
Njira Zosungira Database mu SQL Server
Pali njira zingapo zosungira deta mu SQL Server. Nazi njira zodziwika kwambiri:
1. Kusunga zosunga zobwezeretsera kudzera pa SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) ndi chida chabwino kwambiri cha GUI choyang'anira SQL Server, kuphatikizapo kuchita zosunga zobwezeretsera za database.
1. Tsegulani SSMS:
- Tsegulani SSMS ndikulowa mu SQL Server instance yanu.
2. Sankhani Database:
- Mu Object Explorer, onjezerani "Databases" ndikusankha database yomwe mukufuna kusunga.
3. Yambani Njira Yosungira Zinthu:
– Dinani kumanja pa database yosankhidwa, kenako sankhani “Ntchito” > “Back Up”.
4. Kukonza Zosungira:
– Mu zenera la “Back Up Database”, sankhani mtundu wa zosunga zobwezeretsera (Zonse, Zosiyanitsa, kapena Log). Zosunga zobwezeretsera zonse nthawi zambiri zimagwiritsidwa ntchito kwambiri.
– Tchulani komwe mungasungire zosunga zobwezeretsera, kaya pa diski kapena tepi. Dinani batani la "Onjezani" kuti mutchule malo osungiramo zosunga zobwezeretsera (.bak).
5. Yambani Kusunga Zosunga Zobwezeretsera:
– Dinani “Chabwino” kuti muyambe njira yosungira zinthu. Yembekezerani kuti njirayo ithe ndipo onetsetsani kuti palibe zolakwika zomwe zikuwonekera.
2. Kusunga zobwezeretsera kudzera pa T-SQL
Njira ina yosungira zinthu ndikugwiritsa ntchito Transact-SQL (T-SQL).
1. Tsegulani Mkonzi wa Mafunso:
- Tsegulani SSMS ndi kulowa mu SQL Server instance, kenako tsegulani zenera la New Query.
2. Lembani Script Yosungira Zinthu:
– Lembani script yotsatirayi ya T-SQL kuti mukonze zosunga zobwezeretsera. Sinthani `YourDatabaseName` ndi dzina lanu la database, ndipo `FilePath\YourBackup.bak` ndi njira yosungira zosunga zobwezeretsera.
“`sql
BUCUKU WA NKHANI YA NYUMBA YANU
KU DISK = 'C:\Backup\YourBackup.bak'
NDI FOMU,
MEDIANAME = 'SQLServerBackups',
NAME = 'Kusunga Zonse za Dzina Lanu la Database';
``
3. Kugwiritsa Ntchito Script:
- Ikani scriptyo podina batani la "Execute" kapena F5. Yembekezerani kuti ntchitoyi ithe.
3. Kusunga Zokha Pogwiritsa Ntchito Ndondomeko Yokonzera
Kuti mugwiritse ntchito ma backups okhazikika komanso okonzedwa, mutha kugwiritsa ntchito Mapulani Osamalira mu SQL Server.
1. Tsegulani Wizard ya Mapulani Okonza:
– Mu Object Explorer, onjezerani “Management”, dinani kumanja pa “Maintenance Plans”, kenako sankhani “Maintenance Plan Wizard”.
2. Kukonza Ndandanda:
- Tsatirani njira zomwe zili mu wizard kuti mutchule nthawi yosungira, mtundu wa zosungira, ndi malo osungira.
3. Sungani ndi Kutsimikizira:
– Mukamaliza, sungani dongosolo lokonza ndikuonetsetsa kuti latsimikizika ndikugwiritsidwa ntchito motsatira ndondomeko yanu.
Njira Zobwezeretsera Database mu SQL Server
Njira yobwezeretsa ndi yosiyana ndi njira yosungira zinthu zina. Umu ndi momwe mungabwezeretsere database pogwiritsa ntchito SSMS ndi T-SQL.
1. Kubwezeretsa kudzera pa SQL Server Management Studio (SSMS)
1. Tsegulani SSMS:
- Tsegulani SSMS ndikulowa mu SQL Server instance yanu.
2. Yambani Njira Yobwezeretsa:
- Dinani kumanja pa "Databases" mu Object Explorer, kenako sankhani "Restore Database".
3. Bwezeretsani Kusintha:
- Muwindo la "Kubwezeretsa Database", sankhani njira ya "Chipangizo" ndikudina batani la "..." kuti mupeze fayilo yosungira (.bak) yomwe mudapanga kale.
- Fayilo ikasankhidwa, sankhani database yomwe mukufuna kubwezeretsa.
4. Tchulani Zosankha Zobwezeretsa:
– Pansi pa gawo la “Zosankha zobwezeretsa”, onetsetsani kuti mwasankha njira yoyenera monga “Chotsani deta yomwe ilipo kale” ngati mukufuna kusintha deta yomwe ilipo kale.
- Muthanso kusankha kusintha njira za deta ndi mafayilo a log ngati pakufunika.
5. Yambani Kubwezeretsa:
– Dinani “Chabwino” kuti muyambe kubwezeretsa. Yembekezerani kuti ntchitoyi ithe ndipo onetsetsani kuti palibe zolakwika.
2. Kubwezeretsa kudzera pa T-SQL
1. Tsegulani Mkonzi wa Mafunso:
- Tsegulani SSMS ndi kulowa mu SQL Server instance, kenako tsegulani zenera la New Query.
2. Lembani Script Yobwezeretsa:
– Lembani script yotsatirayi ya T-SQL kuti mukonzenso. Sinthani `YourDatabaseName` ndi dzina lanu la database ndipo `FilePath\YourBackup.bak` ndi njira yosungiramo mafayilo.
“`sql
Bwezeretsani deta yanu
KUCHOKERA KU DISK = 'C:\Backup\YourBackup.bak'
NDI KUSINTHA;
``
3. Kugwiritsa Ntchito Script:
- Ikani scriptyo podina batani la "Execute" kapena F5. Yembekezerani kuti ntchitoyi ithe.
Malangizo ndi Machitidwe Abwino Kwambiri
1. Chitani zosunga zobwezeretsera nthawi zonse:
- Onetsetsani kuti mukusunga ma backup a database yanu nthawi zonse. Konzani nthawi yoti musunge ma backup okha ngati n'kotheka.
2. Sungani zosunga zobwezeretsera pamalo otetezeka:
- Sungani mafayilo osungira zinthu pamalo otetezeka osiyana ndi seva yayikulu. Mwachitsanzo, yosungirako mtambo, cholumikizira chakunja, kapena tepi.
3. Kutsimikizira Kosunga:
– Mukamaliza kusunga deta, nthawi zonse onetsetsani kuti fayilo yosungira deta ndi yolondola ndipo ikhoza kubwezeretsedwanso. Mutha kubwezeretsa deta ku database yoyesera kuti mutsimikizire izi.
4. Yang'anirani njira yosungira ndi kubwezeretsa deta:
- Yang'anirani nthawi zonse njira zosungira ndi kubwezeretsa kuti zitsimikizire kuti zikuyenda bwino komanso popanda zolakwika.
5. Lembani Njira Yogwirira Ntchito:
- Pangani zikalata zonse za njira yosungira ndi kubwezeretsa deta kuti zikhale zosavuta kwa gulu la IT kudziwa njira zoti muchite pakagwa ngozi.
Mapeto
Kusunga ndi kubwezeretsa deta ndi ntchito yofunika kwambiri kwa woyang'anira database aliyense. Pogwiritsa ntchito SQL Server Management Studio (SSMS) kapena T-SQL scripts, mutha kusunga deta yanu mosavuta. Onetsetsani kuti mwasunga deta nthawi zonse ndikusunga mafayilo osunga deta pamalo otetezeka kuti deta isatayike. Kuphatikiza apo, onetsetsani ndikuyang'anira njirayi nthawi zonse kuti muwonetsetse kuti deta yanu ndi yotetezeka komanso yokonzeka kubwezeretsedwa ngati pakufunika kutero.
