Indlela Yokwenza Isipele Nokubuyisela Ama-Database ku-SQL Server
I-SQL Server uhlelo lokuphatha isizindalwazi (i-DBMS) olusetshenziswa kabanzi emhlabeni we-IT ekuphatheni idatha. Ukusekela ngokulondoloza nokubuyisela kuyimisebenzi emibili ebalulekile okufanele wonke umphathi wesizindalwazi ayiqonde ukuqinisekisa ukuphepha kwedatha nokubuyiselwa kwayo uma kwenzeka uhlelo luhluleka, ukonakala, noma ukulahleka kwedatha. Lesi sihloko sizohlanganisa izinyathelo zokwenza isipele nokubuyisela isizindalwazi ku-SQL Server ngokuningiliziwe nangokucacile.
Kungani Kubalulekile Ukwenza Isipele Nokubuyisela?
Ukulondoloza idatha kuyinqubo yokukopisha idatha kusuka kusizindalwazi kuya endaweni ephephile. Lokhu kubalulekile ukuvimbela ukulahleka kwedatha okungenzeka ngenxa yokwehluleka kwehadiwe, amaphutha abantu, ukuhlaselwa yi-malware, noma izinhlekelele zemvelo. Ukubuyisela idatha kusuka kusizindalwazi kuya ohlelweni lokuqala noma olusha ukuze kubuyiselwe idatha kusimo sayo sokuqala.
Izinyathelo Zokwenza Isipele Sedatha ku-SQL Server
Kunezindlela eziningana zokwenza isipele sedatha ku-SQL Server. Nazi izindlela ezivame kakhulu:
1. Isipele nge-SQL Server Management Studio (SSMS)
I-SQL Server Management Studio (SSMS) iyithuluzi elihle kakhulu le-GUI lokuphatha i-SQL Server, okuhlanganisa nokwenza ama-backups edathabheyisi.
1. Vula i-SSMS:
- Vula i-SSMS bese ungena ngemvume ku-instance yakho ye-SQL Server.
2. Khetha i-Database:
– Ku-Object Explorer, yandisa “Ama-Database” bese ukhetha i-database ofuna ukuyigcina.
3. Qala Inqubo Yokwenza Isipele:
– Chofoza kwesokudla kusizindalwazi esikhethiwe, bese ukhetha okuthi “Imisebenzi” > “Isipele”.
4. Ukucushwa Kwesipele:
– Efasiteleni elithi “Back Up Database”, khetha uhlobo lwesipele (Okugcwele, Okuhlukile, noma Ilogi). Isipele esiphelele yisona esivame ukusetshenziswa kakhulu.
– Cacisa indawo yokusekelayo, kungaba kudiski noma kutheyiphu. Chofoza inkinobho ethi “Engeza” ukuze ucacise indawo yokugcina ifayela lokusekelayo (.bak).
5. Qala Isipele:
– Chofoza okuthi “Kulungile” ukuze uqale inqubo yokusekelayo. Linda inqubo iphele futhi uqinisekise ukuthi awekho amaphutha avelayo.
2. Isipele nge-T-SQL
Enye indlela yokwenza isipele ukusebenzisa i-Transact-SQL (T-SQL).
1. Vula Umhleli Wemibuzo:
- Vula i-SSMS bese ungena ku-SQL Server instance, bese uvula iwindi le-New Query.
2. Bhala Isikripthi Sokusekelayo:
– Bhala iskripthi se-T-SQL esilandelayo ukuze wenze ikhophi yasenqolobaneni. Faka igama lesizindalwazi sakho esikhundleni se-`YourDatabaseName`, bese ufaka igama lesizindalwazi sakho esikhundleni se-`FilePath\YourBackup.bak`.
"sql
IDATHA YOKUGCINA I-DatabaseName Yakho
KU-DISK = 'C:\Backup\YourBackup.bak'
NGESIMO,
I-MEDIANAME = 'Izipele ze-SQLServer',
NAME = 'Isipele Esiphelele Segama Lakho Ledathabheyisi';
``
3. Ukusebenza Kweskripthi:
– Yenza iskripthi ngokucindezela inkinobho ethi “Yenza” noma F5. Linda inqubo iphele.
3. Ukusekela Ngokuzenzakalelayo Ukusebenzisa Uhlelo Lokulungisa
Ukuze wenze ama-backup azenzakalelayo nahleliwe, ungasebenzisa Izinhlelo Zokunakekela ku-SQL Server.
1. Vula i-Wizard Yohlelo Lokulungisa:
– Ku-Object Explorer, nweba “Ukuphatha”, chofoza kwesokudla ku-“Maintenance Plans”, bese ukhetha “Maintenance Plan Wizard”.
2. Ukucushwa Kweshejuli:
– Landela izinyathelo ezikwiwizadi ukuze ucacise ishejuli yesipele, uhlobo lwesipele, kanye nendawo yokugcina.
3. Londoloza futhi Uqinisekise:
– Uma usuqedile, gcina uhlelo lokulungisa bese uqinisekisa ukuthi luqinisekisiwe futhi lwenziwe ngokwesheduli yakho echaziwe.
Izinyathelo Zokubuyisela Idathabheyisi ku-SQL Server
Inqubo yokubuyisela iphambene nenqubo yokusekelayo. Nansi indlela yokubuyisela isizindalwazi usebenzisa i-SSMS ne-T-SQL.
1. Buyisela kabusha nge-SQL Server Management Studio (SSMS)
1. Vula i-SSMS:
- Vula i-SSMS bese ungena ngemvume ku-instance yakho ye-SQL Server.
2. Qala Inqubo Yokubuyisela:
– Chofoza ngakwesokudla ku-“Databases” ku-Object Explorer, bese ukhetha “Buyisela Idathabheyisi”.
3. Buyisela Ukucushwa:
– Ewindini elithi “Buyisela Idathabheyisi”, khetha inketho ethi “Idivayisi” bese uchofoza inkinobho ethi “...” ukuthola ifayela lokusekelayo (.bak) olidalile ngaphambilini.
– Uma ifayela selikhethiwe, khetha isizindalwazi ofuna ukusibuyisela.
4. Cacisa Izinketho Zokubuyisela:
– Ngaphansi kwesigaba esithi “Buyisela izinketho”, qiniseka ukuthi ukhetha inketho efanele njengokuthi “Bhala ngaphezulu isizindalwazi esikhona” uma ufuna ukufaka esikhundleni sesizindalwazi esikhona.
– Ungakhetha futhi ukushintsha izindlela zefayela ledatha kanye nelogi uma kudingeka.
5. Qala Ukubuyisela:
– Chofoza okuthi “KULUNGILE” ukuze uqale inqubo yokubuyisela. Linda inqubo iphele futhi uqinisekise ukuthi awekho amaphutha.
2. Buyisela kabusha nge-T-SQL
1. Vula Umhleli Wemibuzo:
- Vula i-SSMS bese ungena ku-SQL Server instance, bese uvula iwindi le-New Query.
2. Bhala i-Restore Script:
– Bhala iskripthi se-T-SQL esilandelayo ukuze wenze ukubuyiselwa. Faka esikhundleni igama elithi `YourDatabaseName` ngegama lesizindalwazi sakho kanye nelithi `FilePath\YourBackup.bak` ngendlela yefayela eliyisipele.
"sql
BUYISELA IDATHA LEZINDABA Igama Ledatha Lakho
KUSUKA KUDISK = 'C:\Backup\YourBackup.bak'
NGOKUSHINTSHA;
``
3. Ukusebenza Kweskripthi:
– Yenza iskripthi ngokucindezela inkinobho ethi “Yenza” noma F5. Linda inqubo iphele.
Amathiphu kanye Nemikhuba Emihle Kakhulu
1. Yenza amakhophi agciniwe avamile:
– Qiniseka ukuthi ugcina ikhophi yasenqolobaneni yakho njalo. Hlela ukwenza ikhophi yasenqolobaneni ngokuzenzakalelayo uma kungenzeka.
2. Londoloza i-Backup Endaweni Ephephile:
– Gcina amafayela okusekelayo endaweni ephephile ehlukile kuseva eyinhloko. Isibonelo, storage ifu, idrayivu yangaphandle, noma iteyipu.
3. Ukuqinisekiswa Kwekhophi Yangemuva:
– Ngemva kokwenza ikhophi yasenqolobaneni, qinisekisa njalo ukuthi ifayela eliyisipele liyasebenza futhi lingabuyiselwa. Ungabuyisela kudathabheyisi yokuhlola ukuqinisekisa lokhu.
4. Qapha Inqubo Yokwenza Isipele Nokubuyisela:
– Njalo qapha izinqubo zokusekela nokubuyisela ukuqinisekisa ukuthi zisebenza kahle futhi azinawo amaphutha.
5. Bhala phansi inqubo:
– Dala amadokhumenti aphelele enqubo yokusekela nokubuyisela ukuze kube lula ngethimba le-IT ukwazi izinyathelo okufanele zithathwe esimweni esiphuthumayo.
Isiphetho
Ukusekela ngokulondoloza nokubuyisela kuyimisebenzi ebalulekile kubo bonke abaphathi bedatha. Usebenzisa izikripthi ze-SQL Server Management Studio (SSMS) noma ze-T-SQL, ungakwazi ukwenza isipele nokubuyisela kalula i-database yakho. Qiniseka ukuthi wenza izipele njalo futhi ugcina amafayela okusekelayo endaweni ephephile ukuvimbela ukulahleka kwedatha. Ngaphezu kwalokho, qinisekisa futhi uqaphe inqubo njalo ukuqinisekisa ukuthi idatha yakho iphephile futhi ilungele ukubuyiselwa uma kudingeka.
