Yuav ua li cas thaub qab thiab rov qab kho cov ntaub ntawv hauv SQL Server
SQL Server yog ib lub database management system (DBMS) uas siv dav hauv ntiaj teb IT rau kev tswj cov ntaub ntawv. Kev thaub qab thiab rov qab los yog ob txoj haujlwm tseem ceeb uas txhua tus thawj coj database yuav tsum nkag siab kom ntseeg tau tias cov ntaub ntawv muaj kev nyab xeeb thiab rov qab tau yog tias lub system ua tsis tiav, puas tsuaj, lossis poob cov ntaub ntawv. Tsab xov xwm no yuav qhia txog cov kauj ruam rau kev thaub qab thiab rov qab los ntawm database hauv SQL Server kom meej thiab meej.
Vim li cas Backup thiab Restore thiaj tseem ceeb?
Kev thaub qab yog cov txheej txheem ntawm kev theej cov ntaub ntawv los ntawm lub hauv paus ntaub ntawv mus rau qhov chaw ruaj ntseg. Qhov no yog qhov tseem ceeb los tiv thaiv kev poob cov ntaub ntawv uas yuav tshwm sim vim yog kev ua tsis tiav ntawm cov khoom siv kho vajtse, kev ua yuam kev ntawm tib neeg, kev tawm tsam malware, lossis kev puas tsuaj ntuj tsim. Kev rov qab yog cov txheej txheem ntawm kev xa cov ntaub ntawv los ntawm kev thaub qab mus rau lub kaw lus qub lossis tshiab kom rov qab kho lub hauv paus ntaub ntawv mus rau nws lub xeev qub.
Cov kauj ruam rau kev thaub qab ib lub Database hauv SQL Server
Muaj ntau txoj kev rau kev thaub qab cov ntaub ntawv hauv SQL Server. Nov yog cov kev qhia feem ntau:
1. Thaub qab los ntawm SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) yog ib qho cuab yeej GUI zoo heev rau kev tswj hwm SQL Server, suav nrog kev ua cov ntaub ntawv thaub qab.
1. Buka SSMS :
- Qhib SSMS thiab nkag mus rau hauv koj tus SQL Server instance.
2. Pilih Database :
– Hauv Object Explorer, nthuav "Databases" thiab xaiv lub database uas koj xav thaub qab.
3. Mulai Proses Backup :
– Nyem sab xis rau ntawm lub ntaub ntawv database uas koj xaiv, ces xaiv "Tasks" > "Back Up".
4. Konfigurasi Backup :
– Hauv lub qhov rais "Back Up Database", xaiv hom backup (Full, Differential, lossis Log). Full backup feem ntau yog qhov siv ntau tshaj plaws.
– Qhia qhov chaw uas koj yuav tsum khaws cov ntaub ntawv thaub qab, xws li rau disk los yog tape. Nyem lub pob "Add" kom qhia qhov chaw uas koj yuav khaws cov ntaub ntawv thaub qab (.bak).
5. Mulai Backup :
– Nyem "OK" kom pib txheej txheem thaub qab. Tos kom txheej txheem ua tiav thiab xyuas kom meej tias tsis muaj qhov yuam kev tshwm sim.
2. Thaub qab ntawm T-SQL
Lwm txoj hauv kev rau kev thaub qab yog siv Transact-SQL (T-SQL).
1. Buka Query Editor :
– Qhib SSMS thiab nkag mus rau hauv SQL Server instance, tom qab ntawd qhib lub qhov rais New Query.
2. Tulis Skrip Backup :
– Sau cov ntawv T-SQL hauv qab no los ua qhov thaub qab. Hloov `YourDatabaseName` nrog koj lub npe database, thiab `FilePath\YourBackup.bak` nrog txoj kev xa mus rau qhov thaub qab.
"`sql
Thaub qab cov ntaub ntawv koj lub npe ntaub ntawv
RAU DISK = 'C:\Backup\YourBackup.bak'
NROG HOM NTAWV,
MEDIANAME = 'SQLServerBackups',
LUB NPE = 'Thaub Qab Tag Nrho ntawm Koj Lub Npe Ntaub Ntawv';
“
3. Eksekusi Skrip :
– Ua kom tiav daim ntawv sau los ntawm kev nias lub pob "Execute" lossis F5. Tos kom cov txheej txheem tiav.
3. Kev thaub qab tsis siv neeg siv Txoj Kev Npaj Txij Nkawm
Yuav kom ua tiav cov thaub qab tsis siv neeg thiab teem sijhawm, koj tuaj yeem siv Cov Phiaj Xwm Txij Nkawm hauv SQL Server.
1. Buka Maintenance Plan Wizard :
– Hauv Object Explorer, nthuav "Management", nias sab xis rau ntawm "Maintenance Plans", tom qab ntawd xaiv "Maintenance Plan Wizard".
2. Konfigurasi Jadwal :
- Ua raws li cov kauj ruam hauv tus wizard kom teev lub sijhawm thaub qab, hom thaub qab, thiab qhov chaw cia khoom.
3. Simpan dan Validasi :
- Thaum ua tiav lawm, khaws daim phiaj xwm txij nkawm thiab xyuas kom meej tias nws tau raug lees paub thiab ua tiav raws li koj lub sijhawm teem tseg.
Cov Kauj Ruam Los Rov Qab Tsim Ib Lub Database Hauv SQL Server
Cov txheej txheem rov qab kho dua yog qhov rov qab ntawm cov txheej txheem thaub qab. Nov yog yuav ua li cas rov qab kho lub ntaub ntawv siv SSMS thiab T-SQL.
1. Rov qab kho dua los ntawm SQL Server Management Studio (SSMS)
1. Buka SSMS :
- Qhib SSMS thiab nkag mus rau hauv koj tus SQL Server instance.
2. Mulai Proses Restore :
– Nyem sab xis rau ntawm "Databases" hauv Object Explorer, ces xaiv "Restore Database".
3. Konfigurasi Restore :
– Hauv lub qhov rais "Restore Database", xaiv qhov kev xaiv "Device" thiab nyem lub pob "..." kom nrhiav tau cov ntaub ntawv thaub qab (.bak) uas koj tau tsim ua ntej.
- Thaum xaiv cov ntaub ntawv lawm, xaiv lub ntaub ntawv database uas koj xav rov qab los.
4. Spesifikasikan Opsi Restore :
– Hauv qab ntu "Restore options", xyuas kom tseeb tias koj xaiv qhov kev xaiv tsim nyog xws li "Overwrite the existing database" yog tias koj xav hloov lub database uas twb muaj lawm.
- Koj tuaj yeem xaiv hloov cov ntaub ntawv thiab cov ntaub ntawv cav yog tias xav tau.
5. Mulai Restore :
– Nyem "OK" kom pib cov txheej txheem rov qab kho. Tos kom cov txheej txheem ua tiav thiab xyuas kom meej tias tsis muaj qhov yuam kev.
2. Rov qab kho dua los ntawm T-SQL
1. Buka Query Editor :
– Qhib SSMS thiab nkag mus rau hauv SQL Server instance, tom qab ntawd qhib lub qhov rais New Query.
2. Tulis Skrip Restore :
– Sau cov ntawv T-SQL hauv qab no los ua qhov kev rov qab los. Hloov `YourDatabaseName` nrog koj lub npe database thiab `FilePath\YourBackup.bak` nrog txoj kev thaub qab cov ntaub ntawv.
"`sql
ROV QAB COV NTAUB NTAWV KOJ LUB NTAUB NTAWV LUB NPE
LOS NTAWM DISK = 'C:\Backup\YourBackup.bak'
NROG HLOOV;
“
3. Eksekusi Skrip :
– Ua kom tiav daim ntawv sau los ntawm kev nias lub pob "Execute" lossis F5. Tos kom cov txheej txheem tiav.
Cov Lus Qhia thiab Cov Kev Xyaum Zoo Tshaj Plaws
1. Rutin Melakukan Backup :
– Nco ntsoov thaub qab koj cov ntaub ntawv database tsis tu ncua. Teem sijhawm thaub qab tsis siv neeg yog tias ua tau.
2. Simpan Backup di Lokasi Aman :
– Simpan file backup di lokasi yang aman dan berbeda dari server utama. Misalnya, huab cia, external drive, atau tape.
3. Verifikasi Backup :
– Tom qab ua tiav qhov thaub qab, ib txwm xyuas kom meej tias cov ntaub ntawv thaub qab siv tau thiab tuaj yeem rov qab tau. Koj tuaj yeem rov qab mus rau hauv lub hauv paus ntaub ntawv sim kom paub tseeb qhov no.
4. Monitor Proses Backup dan Restore :
- Ib txwm saib xyuas cov txheej txheem thaub qab thiab rov qab los kom ntseeg tau tias lawv khiav tau zoo thiab tsis muaj qhov yuam kev.
5. Dokumentasikan Proses :
- Tsim cov ntaub ntawv tiav ntawm cov txheej txheem thaub qab thiab rov qab los kom yooj yim dua rau pab pawg IT kom paub cov kauj ruam yuav tsum ua thaum muaj xwm txheej ceev.
Xaus
Backup dan restore adalah tugas krusial bagi setiap administrator database. Dengan menggunakan SQL Server Management Studio (SSMS) atau skrip T-SQL, Anda dapat melakukan backup dan restore database dengan mudah. Pastikan untuk selalu melakukan backup secara rutin dan menyimpan file backup di lokasi yang aman untuk menghindari kehilangan data. Selain itu, lakukan verifikasi dan monitor proses secara berkala untuk memastikan data Anda selalu dalam kondisi aman dan siap dipulihkan jika diperlukan.
