Ndingaite sei kuti ndichengetedze database muMicrosoft SQL Server Management Studio?

Unoita sei backup yedatabase mukati Studio yeKutarisira Seva yeMicrosoft SQL?

Microsoft SQL Server Management Studio chishandiso chakakosha chekutonga nekutsigira dhatabhesi muMicrosoft SQL Server nharaunda. Kuita periodic backups yedatabase inovimbisa kuvimbika uye kuwanikwa kwedata muchiitiko chekutadza kana njodzi. Muchikamu chino, tichatsanangura maitirwo ekuchengetedza dhatabhesi uchishandisa Microsoft SQL Server Management Studio, nhanho nhanho uye nenzira iri nyore. Ngatitangei!

Step 1: Vhura Microsoft SQL Server Management Studio uye batanidza kune iyo muenzaniso

Nhanho yekutanga mukuita backup yedatabase ndeyekuvhura Microsoft SQL Server Management Studio uye kubatana kune iyo SQL Server muenzaniso uko dhatabhesi raunoda kuchengetedza riripo. Kana uchinge wanyatso batanidza, unokwanisa kuona ese aripo dhatabhesi mune yekuruboshwe panel.

Danho 2: Kurudyi tinya pane dhatabhesi uye sarudza "Mabasa" uye ipapo "Backup"

Iye zvino, tinya-kurudyi pane dhatabhesi yaunoda kuchengetedza uye sarudza "Mabasa" kubva pane zviri mukati menyu. Tevere, sarudza "Back Up" kubva pane yekudonha-pasi submenu. Iyi nhanho ichakubvumidza iwe kuti uwane iyo yekumisikidza hwindo rekuchengetedza database.

Danho rechitatu: Gadzirisa sarudzo dzekuchengetedza

Mune hwindo rekuchengetedza dhizaini, unogona kuseta akasiyana sarudzo zvinoenderana nezvaunoda. Semuenzaniso, unogona kusarudza rudzi rwe backup (izere, mutsauko, kana danda), nzvimbo yekuenda kune backup, uye sarudzo yekuvharira iyo backup yekuwedzera kuchengetedza. Iwe unogona zvakare kuronga periodic otomatiki backups kana uchida.

Danho 4: Click "OK" kutanga negadziriro yeparutivi

Paunenge uchinge wagadzirisa zvese backup sarudzo zvakakodzera, tinya "OK" bhatani kuti utange negadziriro yeparutivi. Zvichienderana nehukuru hwe database uye gadziriro yakasarudzwa, maitiro anogona kutora nguva. Panguva ye backup, iwe uchaona bhaa yekufambira inoratidza kufambira mberi kweiyo backup.

Kuita periodic backups yedatabase itsika yakakosha kuve nechokwadi chekuchengetedza uye kuwanikwa kwedata kana ukatadza. NeMicrosoft SQL Server Management Studio, unogona kuita backups nyore uye nekuvimbika. Tevedza matanho akatsanangurwa muchinyorwa chino uye chengetedza dhatabhesi rako rakachengetedzwa. Usamirire kusvika yanyanya kunonoka kugadzira backup!

-Kusuma kuMicrosoft SQL Server Management Studio

Nhanganyaya kuMicrosoft SQL Server Management Studio:

Microsoft SQL Server Management Studio ndeye dhatabhesi manejimendi uye kusimudzira chishandiso chakapihwa neMicrosoft. Iyo graphical mushandisi interface (GUI) inobvumira vanogadzira uye maneja kutonga zvinobudirira uye dhatabhesi inoshanda inogarwa paMicrosoft SQL Server. Nechishandiso ichi, vashandisi vanogona kuita akawanda mabasa akadai sekugadzira nekugadzirisa dhatabhesi, kubata vashandisi uye mvumo, kubvunza mibvunzo uye zvinyorwa, kugadzira mishumo, nezvimwe zvakawanda.

Rimwe remabasa akakosha kuona kutendeseka uye kuwanikwa kwedata ndeyekuita nguva dzose mabhapu emadhatabhesi. Microsoft SQL Server Management Studio inopa iri nyore uye inoshanda nzira yekuita dhatabhesi backups. Backups inobvumidza iwe kugadzira ma backups yedata muchiitiko chekutadza kwehurongwa, kukanganisa kwevanhu kana njodzi dzinongoitika dzoga. Saizvozvo, backups yakakosha kudzoreredza data. dhatabhesi muchiitiko chekurasikirwa kwedata kana kukuvadzwa kweiyo database chimiro.

MuMicrosoft SQL Server Management Studio, unogona kuita backups nenzira dzakasiyana, sekushandisa graphical interface kana kumhanya SQL mirairo. Kuti uite backup ye database uchishandisa iyo graphical interface, unofanirwa kutevedzera anotevera matanho:
1. Vhura Microsoft SQL Server Management Studio.
2. Batanidza kune yakakodzera database server.
3. Enda kune dhatabhesi chinhu chaunoda kuchengetedza.
4. Right tinya pane dhatabhesi uye sarudza "Mabasa" uye ipapo "Database Backup".
5. Muhwindo rekuchengetedza dhatabhesi, sarudza sarudzo yakakodzera yekuchengetedza, senge backup yakazara, mutsauko, kana dhizaini regi.
6. Taura nzvimbo uye zita rekuchengetedza faira.
7. Click "OK" kutanga negadziriro yeparutivi.

Muchidimbu, Microsoft SQL Server Management Studio chishandiso chakakosha chekutonga nekugadzira dhatabhesi rinogarwa paMicrosoft SQL Server. Kuita zvenguva dzose dhatabhesi backups kwakakosha kuve nechokwadi chekuvimbika kwedata uye kufambisa kudzoreredza muchiitiko chekurasikirwa nedata kana huwori hwedatabase. NeMicrosoft SQL Server Management Studio, unogona nyore kuita mabhaisikopo epa database uchishandisa graphical interface, uchitevera mashoma akapusa.

-Kugadzira dhatabhesi yekuchengetedza

Kugadzirwa kwe kuchengetedza Dhatabhesi manejimendi idanho rakakosha kuona kuchengetedzwa uye kuvimbika kwedata rakachengetwa muMicrosoft SQL Server Management Studio. Pazasi pane matanho anodiwa kuita iyi backup zvinobudirira:

1. Saina kuMicrosoft SQL Server Management Studio wovhura Object Explorer.
2. Enda kune dhatabhesi yaunoda kuchengetedza uye tinya-kurudyi pairi kuratidza menyu yemukati.
3. Sarudza "Mabasa" sarudzo uye ipapo "negadziriro yeparutivi Database" kuvhura negadziriro yeparutivi wizari.

Mune iyo backup wizard, iwe uchaunzwa nehuwandu hwesarudzo kugadzirisa yako yekuchengetedza database. Iva nechokwadi chekuongorora uye kugadzirisa zvinotevera marongero kana zvichidikanwa:

– Rudzi rwekuchengetedza: Sarudza kubva kuzere, kusiyanisa, kana faira uye filegroup backup zvinoenderana nezvaunoda uye huwandu hwe data raunoda kutsigira.
– Sevha backup ku: Sarudza nzvimbo yaunoda kuchengetedza iyo backup faira. Izvi zvinogona kuve dhiraivha yemuno, network share, kana kunyange tepi mudziyo.
– Rongedza backup: Kana iwe uchida kuita otomatiki backups pa nguva nenguva, unogona kuisa purogiramu yacho. Izvi zvichasimbisa izvozvo ruzivo rwako dzinogara dzichitsigirwa uye dzinodzivirirwa.

Paunenge uchinge wagadzirisa zvese zvinodikanwa sarudzo, tinya bhatani rekuti "OK" kuti utange iyo database yekuchengetedza maitiro. Iva nechokwadi chekuchengeta cheki dzenguva dzose pane ako backups uye nguva nenguva kuyedza kudzoreredza kwako kwekuvimbika uye chokwadi. Rangarira kuti kugadzira makopi ekuchengetedza itsika yakakosha kuti uve nechokwadi chekuchengetedza uye kuwanikwa kwedata rako kana paine chiitiko chisingatarisirwe.

-Otomatiki backup kuronga

Automated backup kuronga

Automated backup kuronga kwakakosha kuchengetedza kutendeseka ye database muMicrosoft SQL Server Management Studio. Kuburikidza nekushanda uku, zvinokwanisika kuita zvenguva dzose backups yedatabase otomatiki, nekudaro kudzivirira kurasikirwa nedata uye kuvimbisa kuenderera kwebhizinesi.

Kuchengetedza dhatabhesi muSQL Server Management Studio, nzira yakapusa asi chaiyo inofanirwa kuteverwa. Kutanga, pinda iyo sevha muenzaniso uye wedzera iyo "Databases" node muObject Explorer. Wobva wadzvanya-kurudyi pane dhatabhesi raunoda kutsigira uye sarudza iyo "Mabasa" sarudzo, ichiteverwa ne "Backup." Tevere, hwindo rinovhurika paunofanirwa kusarudza sarudzo dzaunoda dzekuchengetedza, senge nzvimbo yefaira rekuchengetedza, rudzi rwe backup (yakazara, musiyano), uye otomatiki kuronga kwe periodic backups.

Pamusoro pezvo, zvakakosha kuti uzive kuti otomatiki backup kuronga inobvumidza iwe kumisa hurongwa hwekuita ma backups. Izvi zvinonyanya kukosha munzvimbo dzebhizinesi, uko dhatabhesi inogona kugara ichivandudzwa. Nekuronga ma backups, iwe unoita shuwa kuwanikwa kweazvino backup muchiitiko chechero chiitiko chisingatarisirwe, sekutadza kwehurongwa kana kukanganisa kwevanhu. Nokudaro, ruzivo rwakakosha runodzivirirwa uye njodzi dzine chokuita nekurasikirwa kwemashoko dzinoderedzwa. Muchidimbu, automated backup kuronga muSQL Server Management Studio itsika yakakosha yekuve nechokwadi chekuchengetedza uye kuwanikwa kwedata muMicrosoft SQL Server dhatabhesi. Nematanho mashoma, unogona kuseta iyo hurongwa uye ive nechokwadi chekuti backups inoitika nguva nenguva uye nekuvimbika, kuchengetedza kuvimbika kwedatabase uye kuchengetedza kuenderera kwebhizinesi.

-Kusarudza akakodzera backup sarudzo

Kuti uchengetedze dhatabhesi yako muMicrosoft SQL Server Management Studio, zvakakosha kuve nechokwadi kuti unosarudza sarudzo dzakakodzera. Izvi zvinovimbisa kuti backup yakwana uye inogona kudzoserwa zvakanaka kana system yatadza. Pazasi pane zvimwe zvakakosha zvekuchengeta mupfungwa kana uchisarudza backup sarudzo:

1. Backup type: Usati wasarudza backup sarudzo, iwe unofanirwa kusarudza kuti ndeupi rudzi rwe backup yaunoda kuita. Mhando dzakajairwa dzinosanganisira yakazara backup, mutsauko backup, uye transaction log backup. Imwe neimwe ine zvayakanakira nezvayakaipira, saka zvakakosha kuti unzwisise kuti ndeipi inonyanya kukodzera kune chaiyo mamiriro.

2. Backup nzira: Paunenge uchisarudza backup sarudzo, iwe unofanirwa kutsanangura nzvimbo yaunoda kuchengetedza iyo backup faira. Zvinokurudzirwa kusarudza nzvimbo yakachengeteka uye inogona kuwanikwa nyore nyore kana iwe uchida kudzorera dhatabhesi. Pamusoro pezvo, nzvimbo iripo munzira yekuchengetedza inofanirwa kuverengerwa kuve nechokwadi chekuti pane nzvimbo yakakwana yekuchengetedza faira rekuchengetedza.

3. Zvimwe zvingasarudzwa: SQL Server Management Studio inopa akati wandei mamwe maitiro ekugadzirisa maitiro ekuchengetedza. Idzi sarudzo dzinosanganisira kudzvanya kwekuchengetedza, izvo zvinokutendera kuti uderedze saizi yefaira rekuchengetedza uye kuchengetedza dhisiki nzvimbo. Iwe unogona zvakare kusarudza kutsigira chete chimiro kana kusanganisira dhatabhesi data. Izvo zvakakosha kuti unyatso ongorora sarudzo idzi uye sarudza idzo dzinonyatsoenderana nezvako zvekuchengetedza zvaunoda.

-Kuisa backup faira nzvimbo

Paunenge wafunga kuita dhatabhesi yekuchengetedza muMicrosoft SQL Server Management Studio, zvakakosha kuseta nzvimbo yefaira rekuchengetedza. Iyi nzvimbo ichaona kuti faira rine dhatabhesi rekuchengetedza richachengetwa kupi. Kuseta nzvimbo yefaira rekuchengetedza, matanho anotevera anofanira kuteverwa:

1. Ziva faira rekuchengetedza faira rekuenda: Usati waita backup, iwe unofanirwa kusarudza kwaunoda kuchengetedza faira. Izvi zvinogona kunge zviri mufodhi yemunharaunda pane sevha kana munzvimbo yakagovaniswa network. Zvakakosha kuve nechokwadi kuti nzvimbo yakasarudzwa ine nzvimbo yekuchengetera yakakwana inowanikwa yefaira rekuchengetedza.

2. Seta nzira yenzvimbo: Kana pakazoonekwa faira rekuchengetedza, nzira yenzvimbo inofanirwa kugadzirwa muSQL Server Management Studio. Izvi Zvinogona kuitwa kuburikidza nechishandiso chegraphical interface kana nekuita SQL mirairo. Izvo zvakakosha kuti ubatanidze iyo yakazara nzira uye zita refaira umo iyo backup ichachengetwa.

3. Simbisa mvumo yekupinda: Usati waita backup, zvakakosha kuona kuti mushandisi ari kufambisa maitiro ane mvumo yakakodzera yekuwana nekunyorera kunzvimbo yakasarudzwa. Izvi zvakakosha kuve nechokwadi chekuti backup inogona kugadzirwa nemazvo uye faira rinochengetwa kunzvimbo yaunoda.

- Backup verification uye kusimbiswa

Kuve nechokwadi chekuti backup yedatabase yakagadzirwa muMicrosoft SQL Server Management Studio ndeyechokwadi uye yakavimbika, zvakakosha kuita backup maitiro. kusimbiswa uye kusimbiswa. Aya mamwe matanho akakosha kuti uve nechokwadi chekuti backup yaitwa nemazvo uye kuti data rakachengetedzwa nemazvo.

La kusimbiswa zvinosanganisira kuenzanisa iyo backup faira neyekutanga dhatabhesi kuti ive nechokwadi chekuti zvakafanana. Izvi zvinogona kuwanikwa kuburikidza nenzira dzakasiyana, senge manyorerwo ekuongorora nekuenzanisa iyo data kana kushandisa hunyanzvi maturusi anogadzirisa maitiro. Verification inoongororawo kuvimbika kweiyo data, kuve nechokwadi kuti hapana zvikanganiso kana huori.

Kune rumwe rutivi, iyo kusimbiswa Zvinosanganisira kuyedza iyo backup kuratidza kuti inogona kudzoreredzwa nemazvo uye kuti data rinogona kudzoserwa pasina matambudziko. Izvi zvinosanganisira kuita bvunzo dzekudzoreredza munzvimbo yekuyedza kuona kuti backup inoshanda uye kuti data rinodzoreredzwa nemazvo. Kusimbisa kunosanganisirawo kuongororwa kwemaitiro ekudzoreredza uye maitiro ekuona kuti ese maficha ekuita anoshanda.

-Kudzoreredza dhatabhesi kubva kune backup

Kudzoreredza dhatabhesi kubva kune backup ibasa rakajairika mune database system management. MuMicrosoft SQL Server Management Studio, kune nzira dzakasiyana dzekuita basa iri zviri nyore uye nemazvo. Mune ino post, isu tichadzidza maitiro ekuchengetedza dhatabhesi uye tozoidzosera kubva kune iyo backup.

1. Gadzira backup yedatabase: Kuita backup yedatabase muSQL Server Management Studio, tevera matanho aya:
-Vhura SQL Server Management Studio uye ubatanidze kune server uye yaunoda dhatabhesi muenzaniso.
- MuObject Explorer, tinya-kurudyi pane dhatabhesi raunoda kuchengetedza uye sarudza "Mabasa" uyezve "Backup Database".
-Mu "Backup database" hwindo, sarudza dhatabhesi yaunoda, sarudza rudzi rwe backup (yakazara, mutsauko, pakati pevamwe), tsanangura nzvimbo uye zita reiyo faira rekuchengetedza uye wopedzisira wadzvanya "OK" bhatani » kutanga backup. process.

2. Dzosera dhatabhesi kubva kune backup: Kana imwe dhatabhesi backup yagadzirwa, inogona kudzoreredzwa uchishandisa anotevera matanho:
-Batanidza kune sevha uye dhatabhesi muenzaniso muSQL Server Management Studio.
- MuObject Explorer, tinya-kurudyi pane dhatabhesi yaunoda kudzoreredza iyo backup uye sarudza "Mabasa" uyezve "Dzosera dhatabhesi".
- Mu "Dzosa Database" hwindo, sarudza "Chishandiso" sechinobva, tinya bhatani rekuti "Wedzera" uye tarisa kune yaunoda backup faira.
-Sarudza dhatabhesi kudzoreredza uye kugadzirisa dzimwe sarudzo sezvinodiwa.
- Pakupedzisira, tinya bhatani rekuti "Zvakanaka" uye mirira kuti maitiro ekudzoreredza apedze.

3. Zvimwe zvekufunga nezvazvo: Paunenge uchidzoreredza dhatabhesi kubva kune backup, zvakakosha kufunga zvinotevera:
-Simbisa kutendeseka kweiyo backup usati wadzoreredza.
– Ita shuwa kuti une zvakakwana nzvimbo yedhisiki nokuda kwekugadzirisa.
-Cherechedza kuti kudzoreredza kuchanyora zvese zvakagadziridzwa kudhatabhesi mushure mekuchengetedza.
-Sevha maneja ropafadzo dzinogona kudikanwa kuti udzorere zvinobudirira.

Kuve nekuchengetedza dhatabhesi kunogona kuve kwakakosha kuve nechokwadi chekudzoreredza data muchiitiko chenjodzi kana kukanganisa kusingatarisirwe. NeMicrosoft SQL Server Management Studio, zvinokwanisika kuita zvese mabheki uye kudzoreredza kwe nzira inoshanda uye zvakachengeteka.

-Kurudziro ye backup inoshanda

Kuita kuchengetedza kwedatabase kwakakosha muMicrosoft SQL Server Management Studio kwakakosha kuve nechokwadi kuwanikwa kweruzivo uye kuchengetedzeka. Pano tinopa zvimwe mazano kiyi yekuwana backup inoshanda:

1. Kuronga uye hurongwa: Usati watanga backup, zvakakosha kuve neyakatsanangurwa zano. Funga zvinotevera:

• Backup nguva: Inosarudza kuti kangani iyo database ichadzoserwa. Izvi zvinoenderana nekukosha kwe data uye nhamba yekuchinja kwakaitwa.
• Rudzi rwekutsigira: Sarudza yakanyatsokodzera backup mhando yechiitiko chako, senge yakazara, yekuwedzera, kana mutsauko backup. Mhando yega yega yebackrest ine zvayakanakira nezvayakaipira, saka zvakakosha kuti uongorore kuti ndeipi inonyatsokodzera zvaunoda.
• Negadziriro yeparutivi: Tsanangura kwauchachengetera backups. Iwe unogona kushandisa madhiraivha emunharaunda, tepi zvishandiso, kana masevhisi ekuchengetedza mugore.

2. Kuzvigadzira otomatiki: Kuita kuti maitiro ekuchengetedza ave nyore uye ita shuwa kuti haukanganwe kuzviita, zvinokurudzirwa kuti uite otomatiki. SQL Server Management Studio inopa kugona kuronga nguva nenguva backups uchishandisa mabasa ekugadzirisa. Nenzira iyi, sisitimu ichave inotarisira kuita mabhapu zvinoenderana nehurongwa hwakagadzwa.

3. Kusimbisa uye kuyedzwa: Usangovimba nema backups ari kuitwa nemazvo. Izvo zvakakosha kuita yekudzoreredza bvunzo kuona kuti backups ndeyechokwadi uye inoshanda. Izvi zvinosanganisira kudzoreredza backups munzvimbo yekuyedza uye kuona kuti ruzivo rwese rwakadzoserwa nemazvo. Kuita bvunzo idzi nguva nenguva kwakakosha pakuona matambudziko angangoitika uye kuve nechokwadi chekutendeseka kwema backups.

-Zvakakosha kufunga paunenge uchigadzira backups

Kufunga kwakakosha pakuita backups

Paunenge uchiita ma backups muMicrosoft SQL Server Management Studio, zvakakosha kuti utarise zvimwe zvakakosha kuti uve nechokwadi chekuti maitiro anoitwa zvinobudirira uye pasina matambudziko. Imwe yeanonyanya kutariswa ndeyekutsanangura yakakodzera kuchengetedza dhatabhesi yako.. Izvi zvinosanganisira kuona kuwanda kwema backups, angave akazara kana kuwedzera, uye rudzii rwekuchengeta ruchashandiswa kumafaira ekuchengetedza. Izvi zvinhu zvakakosha zvinofanirwa kunyatsoongororwa uye kurongwa usati waita chero backup.

Imwe fungidziro ndeyekuita chokwadi chekuti une nzvimbo yekuchengetera yakakwana iripo. Izvo zvakakosha kuve nenzvimbo yakakwana pane dhisiki apo mafaera ekuchengetedza achachengetwa. Kana nzvimbo yakakwana isipo, maitiro ekuchengetedza anogona kukanganiswa uye data yakakosha inogona kurasika. Naizvozvo, zvinokurudzirwa kufungidzira saizi yemabhapu ako uye ive nechokwadi chekuti une nzvimbo yakakwana usati watanga maitiro.

Chekupedzisira, zvakakosha kuti uone kutendeseka kweiyo backups. Usati wanyatsovimba negadziriro yeparutivi, zvakakosha kuve nechokwadi kuti mafaera ari echokwadi uye haana kushatiswa. Kune izvi, unogona kushandisa zvishandiso senge "Dzosera VerifyOnly" sarudzo muSQL Server Management Studio. Ichi chimiro chinokutendera kuti uone kutendeseka kwemafaera ekuchengetedza pasina kuita chero kudzoreredza, ichipa chivimbo uye runyararo rwepfungwa kana iwe uchifanira kuzvishandisa mune ramangwana.

-Kugadzirisa zvakajairika dambudziko rekuchengetedza database

Kana uri kushandisa Microsoft SQL Server Management Studio kuita dhatabhesi backup, unogona kusangana nemamwe matambudziko akajairika. Neraki, kune mhinduro dzakareruka dzekugadzirisa matambudziko aya uye kuona kuti backup yako inobudirira.

Dambudziko: Kukanganisa kuedza kuita backup yedatabase. Rimwe rematambudziko akajairika aungasangana nawo paunenge uchiedza kuita dhatabhesi yekuchengetedza muSQL Server Management Studio iko kukanganisa mukuita. Izvi zvinogona kukonzerwa nezvakati wandei, senge mvumo isina kukwana kana kushomeka kwedhisiki nzvimbo. Kuti ugadzirise dambudziko iri, ita shuwa yako account yemushandisi iva nemvumo dzakakodzera dzekuita backups yedatabase. Zvakare, simbisa kuti une disk nzvimbo yakakwana yekuchengetedza backup. Kana dambudziko rikaramba riripo, ungangoda kuongorora SQL Server matanda kuti uwane rumwe ruzivo nezve chaiyo kukanganisa kwauri kusangana nako.