Me pēhea te tārua me te whakaora i ngā pātengi raraunga i roto i te SQL Server
He pūnaha whakahaere pātengi raraunga (DBMS) a SQL Server e whakamahia whānuitia ana i roto i te ao hangarau mōhiohio mō te whakahaere raraunga. Ko te tārua me te whakaora he mahi nui e rua me mārama e ngā kaiwhakahaere pātengi raraunga katoa hei whakarite i te haumarutanga raraunga me te whakaora i roto i te wā ka rahua te pūnaha, ka pirau, ka ngaro rānei ngā raraunga. Ka kapihia e tēnei tuhinga ngā mahi mō te tārua me te whakaora i tētahi pātengi raraunga i roto i te SQL Server me te taipitopito me te mārama.
He aha te hiranga o te Tārua me te Whakaora?
Ko te tārua raraunga he tukanga tārua raraunga mai i tētahi pātengi raraunga ki tētahi wāhi haumaru. He mea nui tēnei hei ārai i te ngaronga raraunga ka puta mai i te ngoikore o te taputapu, te hapa tangata, ngā whakaekenga kino, ngā āhuatanga taiao rānei. Ko te whakaora raraunga he tukanga whakahoki raraunga mai i tētahi tārua ki te pūnaha taketake, ki te pūnaha hou rānei hei whakahoki i te pātengi raraunga ki tōna āhua taketake.
Ngā Hipanga hei Tārua i tētahi Pātengi Raraunga i roto i te SQL Server
He maha ngā tikanga hei tārua i tētahi pātengi raraunga i roto i te SQL Server. Anei ngā huarahi tino noa:
1. Tārua mā te SQL Server Management Studio (SSMS)
He taputapu GUI tino pai a SQL Server Management Studio (SSMS) mō te whakahaere i te SQL Server, tae atu ki te mahi tārua pātengi raraunga.
1. Whakatuwheratia te SSMS:
– Whakatuwheratia te SSMS ka takiuru ki tō tauira SQL Server.
2. Tīpakohia te Pūtake Raraunga:
– I roto i te Object Explorer, whakawhanuihia te “Databases” ka tīpako i te pātengi raraunga e hiahia ana koe ki te tārua.
3. Tīmata te Tukanga Tārua:
– Pāwhiri-matau ki te pātengi raraunga kua tīpakohia, kātahi ka tīpako i te “Ngā Mahi” > “Pūrua”.
4. Whirihoranga Tārua:
– I roto i te matapihi “Pūrua Pūtake Raraunga”, tīpakohia te momo tārua (Katoa, Rerekētanga, Takiuru rānei). Ko te tārua katoa te mea e whakamahia whānuitia ana.
– Tauwhāitihia te wāhi e tāruatia ai, ki te kōpae, ki te rīpene rānei. Pāwhiritia te pātene “Tāpiri” hei tauwhāiti i te wāhi e tiakina ai te kōnae tārua (.bak).
5. Tīmata Tārua:
– Pāwhiritia te “ĀE” hei tīmata i te tukanga tārua. Taria kia oti te tukanga, kia kore ai he hapa e puta.
2. Tārua mā te T-SQL
Ko tētahi atu huarahi hei tārua i ngā kōnae ko te whakamahi i te Transact-SQL (T-SQL).
1. Whakatuwheratia te Etita Uiui:
– Whakatuwheratia te SSMS ka takiuru ki te tauira SQL Server, kātahi ka whakatuwhera i te matapihi Uiui Hou.
2. Tuhia he tuhinga tārua:
– Tuhia te tuhinga T-SQL e whai ake nei hei mahi i te tārua. Whakakapia te `YourDatabaseName` ki te ingoa o tō pātengi raraunga, me te `FilePath\YourBackup.bak` ki te ara ūnga tārua.
"`sql"
PŪTAKE PĀRANGI TŌINGA PŪTAKE PĀRANGI
KI TE KŌPAKI = 'C:\Backup\YourBackup.bak'
ME TE HŌPŪ,
INGOA MEDIA = 'Ngā Pūrua Tūmau SQL',
INGOA = 'Te Tārua Katoa o TōIngoaPūtakeRaraunga';
""
3. Te Whakahaere i te Hōtuhi:
– Whakahaerehia te tuhinga mā te pēhi i te pātene “Whakahaere” me te pātene F5 rānei. Taria kia oti te tukanga.
3. Tārua Aunoa mā te Mahere Tiaki
Hei mahi i ngā tārua aunoa me ngā tārua kua whakaritea, ka taea e koe te whakamahi i ngā Mahere Tiaki i roto i te SQL Server.
1. Whakatuwheratia te Ruānuku Mahere Tiaki:
– I roto i te Object Explorer, whakawhanuihia te “Management”, pāwhiri-matau i te “Maintenance Plans”, kātahi ka tīpako i te “Maintenance Plan Wizard”.
2. Whirihoranga Whakarite:
– Whāia ngā kaupae o te ruānuku hei tautuhi i te kaupapa tārua, te momo tārua, me te wāhi rokiroki.
3. Tiaki me te Whakamana:
– Kia oti, tiakina te mahere tiaki, ā, kia tino whakamanahia, kia whakatinanahia hoki e ai ki tāu kaupapa kua whakaritea.
Ngā Hipanga hei Whakaora i tētahi Pātengi Raraunga i roto i te SQL Server
He rerekē te tukanga whakaora i te tukanga tārua. Anei me pēhea te whakaora i tētahi pātengi raraunga mā te whakamahi i te SSMS me te T-SQL.
1. Whakaora mā te SQL Server Management Studio (SSMS)
1. Whakatuwheratia te SSMS:
– Whakatuwheratia te SSMS ka takiuru ki tō tauira SQL Server.
2. Tīmata te Tukanga Whakaora:
– Pāwhiri-matau ki “Databases” i roto i te Object Explorer, kātahi ka tīpako i te “Restore Database”.
3. Whakaora Whirihoranga:
– I te matapihi “Whakaora Pūtake Raraunga”, tīpakohia te kōwhiringa “Pūrere” ka pāwhiri i te pātene “…” hei kimi i te kōnae tārua (.bak) i hangaia e koe i mua.
– Kia oti te tīpako i te kōnae, tīpakohia te pātengi raraunga e hiahia ana koe ki te whakaora.
4. Tauwhāitihia ngā Kōwhiringa Whakaora:
– I raro i te wāhanga “Ngā Kōwhiringa Whakaora”, me tīpako e koe te kōwhiringa tika pēnei i te “Tuhirua te pātengi raraunga o nāianei” mēnā kei te hiahia koe ki te whakakapi i tētahi pātengi raraunga o nāianei.
– Ka taea hoki e koe te whakarerekē i ngā ara raraunga me ngā ara kōnae takiuru mēnā e tika ana.
5. Tīmata Whakaora:
Pāwhiritia te “ĀE” hei tīmata i te tukanga whakaora. Taria kia oti te tukanga, kia kore ai he hapa.
2. Whakaora mā te T-SQL
1. Whakatuwheratia te Etita Uiui:
– Whakatuwheratia te SSMS ka takiuru ki te tauira SQL Server, kātahi ka whakatuwhera i te matapihi Uiui Hou.
2. Tuhia te Hōtuhi Whakaora:
– Tuhia te tuhinga T-SQL e whai ake nei hei mahi i te whakaora. Whakakapia te `YourDatabaseName` ki te ingoa o tō pātengi raraunga, me te `FilePath\YourBackup.bak` ki te ara kōnae tārua.
"`sql"
WHAKAHOKIA TE PŪTAKE PĀRANGI Tō IngoaPūtakePārangi
MAI I TE KŌPAKI = 'C:\Pūrua\TōPūrua.bak'
ME TE WHAKAKĀHORE;
""
3. Te Whakahaere i te Hōtuhi:
– Whakahaerehia te tuhinga mā te pēhi i te pātene “Whakahaere” me te pātene F5 rānei. Taria kia oti te tukanga.
Ngā Tohutohu me ngā Mahi Pai
1. Whakahaerehia ngā tārua auau:
– Kia tino tāruatia tō pātengi raraunga i ia wā. Whakaritea he tārua aunoa mēnā ka taea.
2. Tiakina te Tārua ki tētahi Wāhi Haumaru:
– Penapenahia ngā kōnae tārua ki tētahi wāhi haumaru, motuhake mai i te tūmau matua. Hei tauira, kapua rokiroki, puku o waho, rīpene rānei.
3. Manatoko Tārua:
– I muri i te mahi tārua, me manatoko tonu kei te tika te kōnae tārua, ā, ka taea te whakahoki mai. Ka taea e koe te whakahoki ki tētahi pātengi raraunga whakamātautau hei manatoko i tēnei.
4. Aroturuki i te Tukanga Tārua me te Whakaora:
– Me aroturuki tonu i ngā tukanga tārua me te whakaora kia pai ai te haere, kia kore ai he hapa.
5. Tuhia te Tukanga:
– Waihangahia he tuhinga katoa mō te tukanga tārua me te whakaora kia māmā ake ai te mōhio o te tīma hangarau mōhiohio ki ngā mahi hei mahi i roto i tētahi āhuatanga ohorere.
Whakamutunga
He mahi tino nui te tārua me te whakaora mō ngā kaiwhakahaere pātengi raraunga katoa. Mā te whakamahi i ngā tuhinga SQL Server Management Studio (SSMS) me ngā tuhinga T-SQL rānei, ka taea e koe te tārua me te whakaora i tō pātengi raraunga. Kia mahara ki te mahi tārua auau, me te penapena i ngā kōnae tārua ki tētahi wāhi haumaru hei ārai i te ngaronga o ngā raraunga. Hei tāpiri, manatokohia me te aroturuki i te tukanga i ia wā kia mōhio ai kei te haumaru ō raraunga, ā, kua rite hoki ki te whakaora mēnā e tika ana.
