Otu esi akwado ma weghachite ọdụ data na SQL Server
SQL Server bụ sistemụ njikwa nchekwa data (DBMS) nke a na-ejikarị eme ihe n'ụwa IT maka ijikwa data. Nkwado ndabere na mweghachi bụ ọrụ abụọ dị mkpa onye nchịkwa nchekwa data ọ bụla kwesịrị ịghọta iji hụ na nchekwa data na mgbake ya ma ọ bụrụ na sistemụ daa, nrụrụ aka, ma ọ bụ mfu data. Isiokwu a ga-ekpuchi usoro maka nkwado ndabere na iweghachi nchekwa data na SQL Server n'ụzọ zuru ezu na nke doro anya.
Gịnị mere nkwado ndabere na mweghachi ji dị mkpa?
Ndabere bụ usoro nke idetuo data site na nchekwa data gaa na ebe nchekwa. Nke a dị mkpa iji gbochie mfu data nke nwere ike ime n'ihi ọdịda ngwaike, mmejọ mmadụ, mwakpo malware, ma ọ bụ ọdachi ndị sitere n'okike. Ndabere bụ usoro nke iweghachite data site na nchekwa data gaa na sistemụ mbụ ma ọ bụ ọhụrụ iji weghachi nchekwa data ahụ n'ọnọdụ mbụ ya.
Nzọụkwụ iji kwado nchekwa data na SQL Server
E nwere ọtụtụ ụzọ isi kwado nchekwa data na SQL Server. Lee ụzọ ndị a na-ejikarị eme ihe:
1. Ndabere site na SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) bụ ezigbo ngwaọrụ GUI maka ijikwa SQL Server, gụnyere ime nkwado ndabere data.
1. Mepee SSMS:
- Mepee SSMS wee banye na ihe atụ SQL Server gị.
2. Họrọ ebe nchekwa data:
– Na Ihe Explorer, gbasaa “Databases” wee họrọ nchekwa data ịchọrọ ịkwado ndabere.
3. Malite usoro ndabere:
– Pịa aka nri na nchekwa data ahọpụtara, wee họrọ “Ọrụ” > “Nkwado ndabere”.
4. Nhazi ndabere:
– Na windo "Back Up Database", họrọ ụdị nkwado ndabere (Full, Differential, ma ọ bụ Log). Nkwado ndabere zuru oke bụ nke a na-ejikarị eme ihe.
– Kwupụta ebe ndabere ahụ ga-adị, ma ọ bụ na diski ma ọ bụ teepu. Pịa bọtịnụ “Tinye” iji kọwaa ebe nchekwa faịlụ ndabere ahụ (.bak).
5. Malite ndabere:
– Pịa “OK” iji malite usoro nkwado ndabere. Chere ka usoro ahụ mechaa ma hụ na ọ dịghị mmejọ ọ bụla pụtara.
2. Ndabere site na T-SQL
Ụzọ ọzọ maka nkwado ndabere bụ iji Transact-SQL (T-SQL).
1. Mepee Onye Ndezi Ajụjụ:
– Mepee SSMS wee banye na ihe atụ SQL Server, wee mepee windo Ajụjụ Ọhụrụ.
2. Dee edemede ndabere:
– Dee edemede T-SQL ndị a iji mee nkwado ndabere. Jiri aha nchekwa data gị dochie `YourDatabaseName`, ma jiri ụzọ ebe nchekwa ndabere dochie `FilePath\YourBackup.bak`.
"sql"
DEBỤTA DEBỤTA AHỤMAKWỤKWỌ NDEPỤTA AHỤMAKWỤKWỌ NDAPỤTA AHỤMAKWỤKWỌ
TO DISK = 'C:\Backup\YourBackup.bak'
NA usoro,
MEDIANAME = 'Nkwado SQLServer',
AHA = 'Nchekwa zuru oke nke Aha Database Gị';
““
3. Mmezu edemede:
– Mee ihe odide ahụ site na ịpị bọtịnụ “Mezue” ma ọ bụ F5. Chere ka usoro ahụ mechaa.
3. Nkwado akpaghị aka site na iji Atụmatụ Mmezi
Iji mee nkwado ndabere akpaka na nke edobere, ị nwere ike iji Atụmatụ Mmezi na SQL Server.
1. Mepee Ọkachamara Atụmatụ Ndozi:
– Na Ihe Explorer, gbasaa "Njikwa", pịa aka nri "Atụmatụ Nchekwa", wee họrọ "Ngwa Nhazi Nchekwa".
2. Nhazi oge:
– Soro usoro ndị dị na wizard ahụ iji kọwaa usoro nkwado ndabere, ụdị nkwado ndabere, na ebe nchekwa.
3. Chekwaa ma kwado:
– Ozugbo emechara ya, chekwaa atụmatụ mmezi ahụ ma hụ na enyochala ya ma mee ya dịka usoro oge gị siri dị.
Nzọụkwụ iji weghachite nchekwa data na SQL Server
Usoro mweghachi bụ ihe dị iche na usoro nkwado ndabere. Lee otu esi eweghachi nchekwa data site na iji SSMS na T-SQL.
1. Weghachite site na SQL Server Management Studio (SSMS)
1. Mepee SSMS:
- Mepee SSMS wee banye na ihe atụ SQL Server gị.
2. Malite Usoro Mweghachi:
- Pịa aka nri na "Databases" na Ihe Explorer, wee họrọ "Weghachite Database".
3. Weghachite nhazi:
– Na windo “Weghachite Database”, họrọ nhọrọ “Ngwaọrụ” wee pịa bọtịnụ “...” iji chọta faịlụ ndabere (.bak) ị mepụtara na mbụ.
– Ozugbo ahọpụtara faịlụ ahụ, họrọ nchekwa data ịchọrọ iweghachi.
4. Kọwaa Nhọrọ Mweghachi:
– N'okpuru ngalaba "Nhọrọ Weghachite", jide n'aka na ị họọrọ nhọrọ kwesịrị ekwesị dịka "Kpochapụ nchekwa data dị ugbu a" ma ọ bụrụ na ịchọrọ ịgbanwe nchekwa data dị adị.
- I nwekwara ike ịhọrọ ịgbanwe ụzọ data na faịlụ ndekọ ma ọ bụrụ na ọ dị mkpa.
5. Malite Mweghachi:
– Pịa “OK” iji malite usoro mweghachi ahụ. Chere ka usoro ahụ mechaa ma hụ na enweghị mmejọ ọ bụla.
2. Weghachite site na T-SQL
1. Mepee Onye Ndezi Ajụjụ:
– Mepee SSMS wee banye na ihe atụ SQL Server, wee mepee windo Ajụjụ Ọhụrụ.
2. Dee Akwụkwọ Mweghachi:
– Dee edemede T-SQL ndị a iji mee mweghachi ahụ. Jiri aha nchekwa data gị dochie `YourDatabaseName` na `FilePath\YourBackup.bak` na ụzọ faịlụ ndabere.
"sql"
Weghachite Database Aha Database Gị
SITE NA DISK = 'C:\Backup\YourBackup.bak'
NA NTINYE NTINYE;
““
3. Mmezu edemede:
– Mee ihe odide ahụ site na ịpị bọtịnụ “Mezue” ma ọ bụ F5. Chere ka usoro ahụ mechaa.
Ndụmọdụ na Omume Kachasị Mma
1. Mee nkwado ndabere mgbe niile:
– Gbaa mbọ hụ na ị na-echekwa nchekwa data gị mgbe niile. Hazie oge maka nkwado ndabere akpaka ma ọ bụrụ na o kwere mee.
2. Chekwaa ndabere ahụ n'ebe dị nchebe:
– Debe faịlụ ndabere n'ebe dị nchebe dị iche na sava bụ isi. Dịka ọmụmaatụ, ojii nchekwa, draịva mpụga, ma ọ bụ teepu.
3. Nkwenye ndabere:
– Mgbe ịmechara nkwado ndabere, na-enyocha mgbe niile na faịlụ ndabere ahụ dị irè ma enwere ike iweghachi ya. Ị nwere ike weghachite ya na nchekwa data nnwale iji chọpụta nke a.
4. Na-enyocha usoro nkwado ndabere na mweghachi:
– Na-enyocha usoro nkwado ndabere na mweghachi mgbe niile iji hụ na ha na-arụ ọrụ nke ọma na enweghị mmejọ.
5. Dekọọ usoro ahụ:
– Mepụta akwụkwọ zuru oke nke usoro nkwado ndabere na mweghachi iji mee ka ọ dịrị ndị otu IT mfe ịmata ihe ha ga-eme n'ọnọdụ mberede.
Mmechi
Ndabere na mweghachi bụ ọrụ dị oke mkpa maka onye nchịkwa nchekwa data ọ bụla. Site na iji SQL Server Management Studio (SSMS) ma ọ bụ T-SQL scripts, ị nwere ike ịkwado ma weghachite nchekwa data gị ngwa ngwa. Jide n'aka na ị na-eme nkwado ndabere mgbe niile ma na-echekwa faịlụ ndabere n'ebe nchekwa iji gbochie mfu data. Na mgbakwunye, nyochaa ma na-enyocha usoro ahụ mgbe niile iji hụ na data gị dị nchebe ma dị njikere iweghachi ma ọ bụrụ na ọ dị mkpa.
