Yadda ake Ajiyewa da Mayar da Bayanan Bayanai a cikin SQL Server
SQL Server tsarin sarrafa bayanai ne (DBMS) wanda ake amfani da shi sosai a duniyar IT don sarrafa bayanai. Ajiyewa da dawo da bayanai ayyuka ne guda biyu masu mahimmanci da kowane mai kula da bayanai ya kamata ya fahimta don tabbatar da tsaron bayanai da dawo da su idan tsarin ya gaza, cin hanci da rashawa, ko asarar bayanai. Wannan labarin zai rufe matakan adana bayanai da dawo da bayanai dalla-dalla a cikin SQL Server.
Me yasa Ajiyayyen da Mayar da Magani yake da Muhimmanci?
Ajiye bayanai (Ajiye bayanai) tsari ne na kwafi bayanai daga rumbun adana bayanai zuwa wuri mai aminci. Wannan yana da mahimmanci don hana asarar bayanai da ka iya faruwa sakamakon gazawar kayan aiki, kuskuren ɗan adam, hare-haren malware, ko bala'o'i na halitta. Maidowa tsari ne na mayar da bayanai daga rumbun adana bayanai zuwa tsarin asali ko sabon don dawo da bayanan zuwa yanayin da suke a da.
Matakai don Ajiye Bayanan Bayanai a cikin SQL Server
Akwai hanyoyi da dama don adana bayanai a cikin SQL Server. Ga hanyoyin da aka fi amfani da su:
1. Ajiyewa ta hanyar SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) kyakkyawan kayan aikin GUI ne don sarrafa SQL Server, gami da yin madadin bayanai.
1. Buɗe SSMS:
- Buɗe SSMS kuma shiga cikin misalin SQL Server ɗinku.
2. Zaɓi Bayanan Bayanai:
– A cikin Object Explorer, faɗaɗa “Bayanai” kuma zaɓi bayanan da kake son adanawa.
3. Fara Tsarin Ajiyewa:
– Danna-dama a kan bayanan da aka zaɓa, sannan zaɓi “Ayyuka” > “Ajiye”.
4. Tsarin Ajiyar Ajiya:
– A cikin taga “Back Up Database”, zaɓi nau'in madadin (Cikakke, Bambanci, ko Log). Cikakken madadin galibi shine mafi yawan amfani.
– Kayyade wurin da za a ajiye madadin, ko dai zuwa faifai ko tef. Danna maɓallin “Ƙara” don ƙayyade wurin da za a ajiye fayil ɗin madadin (.bak).
5. Fara Ajiyewa:
– Danna “Ok” don fara aikin madadin. Jira har sai an kammala aikin kuma tabbatar da cewa babu kurakurai da suka bayyana.
2. Ajiyar bayanai ta hanyar T-SQL
Wani madadin don adana bayanai shine amfani da Transact-SQL (T-SQL).
1. Buɗe Editan Tambaya:
– Buɗe SSMS sannan ka shiga cikin misalin SQL Server, sannan ka buɗe taga Sabuwar Tambaya.
2. Rubuta Rubutun Ajiyar Bayanai:
– Rubuta rubutun T-SQL mai zuwa don yin madadin. Sauya `YourDatabaseName` da sunan bayananka, da kuma `FilePath\YourBackup.bak` da hanyar da za a bi wajen ajiye madadin.
"sql
BOYE BAYANAI NA AJIYE SUNAN BAYANAI NAKU
ZUWA DISK = 'C:\Backup\YourBackup.bak'
DA TSARI,
MEDIANAME = 'SQLServerBackups',
SUNA = 'Cikakken Ajiya na Sunan Bayananka';
““
3. Aiwatar da Rubutu:
– A aiwatar da rubutun ta hanyar danna maɓallin “Aiki” ko F5. Jira har sai an kammala aikin.
3. Ajiyar Atomatik Ta Amfani da Tsarin Gyara
Don yin madadin atomatik da aka tsara, zaku iya amfani da Tsarin Kulawa a cikin SQL Server.
1. Buɗe Ma'aikacin Tsarin Gyara:
– A cikin Object Explorer, faɗaɗa “Gudanarwa”, danna dama “Tsarin Gyara”, sannan zaɓi “Mai sarrafa Tsarin Gyara”.
2. Tsarin Jadawali:
– Bi matakan da ke cikin mayen don tantance jadawalin madadin, nau'in madadin, da wurin ajiya.
3. Ajiye kuma Tabbatar:
– Da zarar an kammala, ajiye tsarin kulawa kuma ka tabbatar an tabbatar da an aiwatar da shi bisa ga jadawalin da aka ƙayyade.
Matakai don Mayar da Bayanan Bayanai a cikin SQL Server
Tsarin dawo da bayanai shine akasin tsarin madadin bayanai. Ga yadda ake dawo da bayanai ta amfani da SSMS da T-SQL.
1. Maidowa ta hanyar SQL Server Management Studio (SSMS)
1. Buɗe SSMS:
- Buɗe SSMS kuma shiga cikin misalin SQL Server ɗinku.
2. Fara Tsarin Maidowa:
- Danna dama akan "Bayanai" a cikin Object Explorer, sannan zaɓi "Mayar da Bayanan Bayani".
3. Maido da Saita:
– A cikin taga “Mayar da Bayanan Bayanai”, zaɓi zaɓin “Na'ura” sannan danna maɓallin “...” don nemo fayil ɗin madadin (.bak) da kuka ƙirƙira a baya.
– Da zarar an zaɓi fayil ɗin, zaɓi rumbun adana bayanai da kake son mayarwa.
4. Kayyade Zaɓuɓɓukan Maidowa:
– A ƙarƙashin sashin “Zaɓuɓɓukan Maidowa”, tabbatar da cewa ka zaɓi zaɓin da ya dace kamar “Overwrite the destiny database” idan kana son maye gurbin da destiny database.
- Hakanan zaka iya zaɓar canza hanyoyin bayanai da fayilolin log idan ana buƙata.
5. Fara Maidowa:
– Danna “Ok” don fara aikin dawo da shi. Jira aikin ya kammala kuma tabbatar babu kurakurai.
2. Maidowa ta hanyar T-SQL
1. Buɗe Editan Tambaya:
– Buɗe SSMS sannan ka shiga cikin misalin SQL Server, sannan ka buɗe taga Sabuwar Tambaya.
2. Rubuta Rubutun Maidowa:
– Rubuta rubutun T-SQL mai zuwa don yin aikin dawo da shi. Sauya `YourDatabaseName` da sunan bayananka da kuma `FilePath\YourBackup.bak` da hanyar fayil ɗin madadin.
"sql
MAYAR DA BAYANAI Sunan Bayananka
DAGA DISK = 'C:\Backup\YourBackup.bak'
DA MAYEWA;
““
3. Aiwatar da Rubutu:
– A aiwatar da rubutun ta hanyar danna maɓallin “Aiki” ko F5. Jira har sai an kammala aikin.
Nasihu da Mafi Kyawun Ayyuka
1. Yi madadin bayanai akai-akai:
– Tabbatar kana adana bayanai akai-akai. Shirya madadin bayanai ta atomatik idan zai yiwu.
2. Ajiye Ajiyayyen a Wuri Mai Aminci:
– Ajiye fayilolin madadin a wuri mai aminci daban da babban sabar. Misali, girgije ajiya, na'urar tuƙi ta waje, ko kuma tef.
3. Tabbatar da Ajiyar Bayanai:
– Bayan yin ajiyar bayanai, koyaushe tabbatar da cewa fayil ɗin ajiyar yana da inganci kuma ana iya dawo da shi. Kuna iya mayar da shi zuwa rumbun adana bayanai na gwaji don tabbatar da hakan.
4. Kula da Tsarin Ajiyewa da Maidowa:
– Kullum a lura da hanyoyin adanawa da dawo da bayanai domin tabbatar da cewa suna aiki cikin sauƙi ba tare da kurakurai ba.
5. Rubuta Tsarin:
– Ƙirƙiri cikakkun takardu game da tsarin adanawa da dawo da bayanai domin sauƙaƙa wa ƙungiyar IT sanin matakan da za a ɗauka a cikin gaggawa.
Kammalawa
Ajiyewa da dawo da bayanai ayyuka ne masu mahimmanci ga kowane mai kula da bayanai. Ta amfani da SQL Server Management Studio (SSMS) ko rubutun T-SQL, zaka iya ajiye bayanai da dawo da su cikin sauƙi. Tabbatar kana yin ajiyar bayanai akai-akai da kuma adana fayilolin ajiyar bayanai a wuri mai aminci don hana asarar bayanai. Bugu da ƙari, tabbatar da kuma sa ido kan tsarin akai-akai don tabbatar da cewa bayananka suna da tsaro kuma a shirye suke don a dawo da su idan ana buƙata.
