Ungalivula kanjani Ifayela le-BAK - Umhlahlandlela ophelele

Ungathanda ukufunda ukuthi kanjani vula ifayela le-BAK? Amafayela e-BAK angelinye lalawo mafomethi ngokuvamile angenaso isikhathi eside sokuphila, ngenxa yokuthi angamakhophi ayisipele amadokhumenti ethu. Uma ufuna ukwazi ukuthi ulivula kanjani ifayela le-BAK, ngenxa yelukuluku noma ngoba unalo, lesi sihloko sesakho. Sikumema ukuthi uhlale.

Ayini amafayela e-BAK?

Amafayela e-BAK (umdlalo wamagama we-Back, okusho ukuthi "ngemuva»ngesiNgisi) ziyisandiso sezipele. I-BAK inomsebenzi wokuvikela idatha yanoma iyiphi idokhumenti, kungaba ifayela lombhalo noma ifayela eliyisithombe, ukuze ibuyiselwe esimweni esizinzile sangaphambilini uma eyangempela yonakalisiwe noma yonakalisiwe.

Lapha ungafunda mayelana: Ungawavula Kanjani Amafayela E-BAK

Lawa mafomethi ngokuvamile aklanywa izinhlelo ezifanayo esizisebenzisela ukukhohlisa ifayela. Isoftware efana iZwi, Photoshop, AutoCAD noma Sony Vegas Ayakwazi ukukhiqiza amafayela ngesandiso se-BAK ukuze alondoloze umsebenzi wethu uma kwenzeka iphutha.

Ngenxa yale fomethi, singabuyela ekusebenzeni kumaphrojekthi ethu, noma ngabe uhlelo luvalwa kungazelelwe noma i-PC yethu ivaleka kungazelelwe.

Izinhlelo zokuvula ifayela le-BAK

Ukuze wazi ukuthi livula kanjani ifayela le-BAK, kubalulekile ukwazi ukuthi lolu hlobo lwetheminali aluhlelwanga ukuthi lusebenze njengoba besingenza nge-DOC noma PDF.

Amafayela e-BAK ahloselwe ukuthi avulwe yizinhlelo eziwadalile, kodwa lokho akusho ukuthi ayikho indlela yokuvula amafayela e-BAK ngezinye izinhlelo. Okulandelayo, sizokukhombisa uhlelo esilubona lufaneleka kakhulu lokuvula ifayela le-BAK ngokuphepha.

Indlela 1: WinRAR

Kungani i-WinRAR iyindlela engcono kakhulu yokuvula ifayela le-BAK? Kalula nje, kuvame ukwenzeka ukuthi sithole kukhompuyutha yethu noma kudiski yokugcina izinto isitoreji ifayela le-BAK, elethu noma elomunye umuntu, umsuka walo ongaqinisekile. Amafayela e-BAK anobuqili ngoba uma singawaphatha kabi, singalahlekelwa kalula ukuphela kwekhophi yefayela eselivele lilahlekile noma elinesici.

Uma ungazi kahle ukuthi ifayela le-BAK ofuna ukulikhohlisa livelaphi, iWinRAR iyindlela ephephile yokuhlola ingaphakathi layo ngaphandle kokulilimaza. Kungakhathaliseki ukuthi ikhophi eyisipele ye-AutoCAD, Premier Pro, Sketch Up nanoma yiluphi olunye uhlelo, i-WinRAR izosibonisa ifomethi yoqobo okwazalelwa kuyo i-BAK, ngokuvikeleka okudingekayo ukuze iyisebenzise kamuva ngesofthiwe yayo engumzali.

Ungalivula kanjani ifayela le-BAK ngeWinRAR

1. I-Paso 1: Chofoza kwesokudla ifayela le-BAK
2. I-Paso 2: Iya ku Izakhiwo/Hlela (eduze ne "ivula ngokuthi:")
3. I-Paso 3: Khetha WinRAR
4. I-Paso 4: Chofoza "khipha lapha”, ngale ndlela uzoba nefayela lokuqala liphume ku-BAK futhi lilungele ukusetshenziswa.

Amafayela angaphandle kwe-BAK awekho engcupheni, njengoba iyinguqulo ezinzile yedokhumenti egcinwe nayo Isikhumulo okwangempela (.DOC, .PSD, .PDF, .AI, phakathi kokunye). Uma usuqedile, vele ubone ukuthi leli fayela liqukethe ini uma ungasalikhumbuli, ngaphandle kwalokho, kungcono ukulilondoloza uma ucabanga ukuthi ungalisebenzisa futhi esikhathini esizayo.

Indlela 2: Ungalivula kanjani ifayela le-Bak

Ifayela elilondolozwe njengesandiso se-BAK kuthiwa liyifayela eliyisipele sohlelo lokusebenza elisetshenziswa kakhulu ukugcina ikhophi yamafayela ngezinjongo zokwenza isipele.

Amafayela amaningi e-BAK akhona ohlelweni lwekhompyutha akhiqizwa ngokuzenzakalelayo uhlelo kumafolda esistimu. Amafayela e-BAK anjalo angaqukatha noma yini ukusuka kumabhukhimakhi kuye isiphequluli sewebhu kumafayela ohlelo lwesofthiwe adinga ukwenza isipele njalo.

Uma uhlelo lokusebenza kuthiwa lulondoloza izinguquko ezenziwe kamuva kudatha egcinwe kukhompuyutha, luqamba kabusha isandiso sefayela le-BAK esidala sibe esisha, ukuze kuthi noma ngabe uhlelo lokusebenza lusaphazeka ngandlela thize, idatha Lost idatha ingakhunjulwa. . Ngale ndlela, ungaqinisekisa ukulahleka kwedatha okuncane kwasekuqaleni.

Amafayela amaningi anesandiso se-bak adalwe futhi agcinwe ngokuzenzakalelayo angamakhophi ayisipele we yolwazi emele isizindalwazi seseva ye-SQL; Nokho, ezinye izinhlelo ezifana ne-Word ne-Excel nazo zingakha amafayela anjalo ayisipele.

Alukho uhlobo olujwayelekile lohlelo olutholakalayo lokungenisa noma ukukhipha ulwazi ngokuqondile kumafayela alondolozwe ngesandiso se-BAK.

Ukubuyisela ifayela le-bak iyona ndlela kuphela yokubuka nokuhlela okuqukethwe okugcinwe ikhophi yasenqolobaneni ngohlelo lokusebenza lwesofthiwe. Uma inefayela lesandiso le-XLS, kufanele usebenzise uhlelo lwe-Excel ukuze uvule ifayela le-XLS.

Izindlela zokuvula ifayela le-bak

Njengoba kuxoxiwe ngenhla, amafayela e-bak angadalwa ngokuzenzakalelayo noma ngesandla ngezinhlelo eziningi futhi uma ungenalo ulwazi ngomlando wefayela, udinga ukulandela izinyathelo ezingakusiza ukuthi ukhiphe kahle ulwazi olukhona efayeleni eliyisipele. .

Uma wazi okuthile ngomlando wefayela ohlobene nohlelo elasekelwa kulo futhi lathunyelwa ngaphandle, kufanele uvule uhlelo olufunayo bese ubheka izinketho zokubuyisela ngalo.

Indlela 1: Izindlela ezingenzeka zokuvula ifayela le-BAK eligciniwe ku-SQL

Okulandelayo isethi yemiyalelo okufanele uyilandele ukuze uvule ifayela le-BAK eligcinwe njengesipele se-SQL Server. Ukuze ufinyelele ulwazi olugcinwe njengefayela eliyisipele, kufanele libuyiselwe esimweni salo sasekuqaleni. Uma uzama ukuvula ifayela le-bak elilondoloziwe usebenzisa i-Notepad njengabahleli bombhalo, ungase ugcine ngokubona uhlu lwezinhlamvu ezingcolile.

1. I-Paso 1: Vula i-SSMS (i-SQL Server Management Studio).
2. I-Paso 2: Kusizindalwazi osuzobuyisela ifayela le-BAK, chofoza kwesokudla kulo bese uzulazulela ku I-Tareas bese uqhafaza Buyisela bese kungena Database, njengoba kushiwo ngezansi.

3. I-Paso 3: Khetha inketho 'Kusuka kudivayisi' bese uchofoza kuyo ukuze uphequlule futhi ulayishe ifayela le-bak endaweni yefolda okuyiwa kuyo.

4. I-Paso 4: Iwindi lizovela 'Cacisa ikhophi yasenqolobaneni', lapho kufanele uchofoze inkinobho 'Engeza' ukuze ukhethe isandiso sefayela le-BAK esilondolozwe ngaphambilini.

5. I-Paso 5: Isikrini esilandelayo sizogcinwa kuhla lwemibhalo lwedrayivu yasendaweni ekhona ohlelweni lwekhompyutha yakho. Zulazulela kufolda enefayela le-bak bese uyikhetha ukuze uqale inqubo yokubuyisela.

6. I-Paso 6: Uma ifayela selikhethiwe, chofoza inkinobho 'KULUNGILE' bese ucindezela inkinobho futhi 'KULUNGILE' ukuze ubuyele esikrinini sasekhaya.
7. I-Paso 7: Qiniseka ukuthi uwamaka kokubili 'Yenza isipele ilogu yokwenziwe engenalutho' njengoba 'Ikhophi yasenqolobaneni egcwele' ukubuyisela kahle ifayela.

8. I-Paso 8: Uma zombili izinketho sezikhethiwe, cindezela inkinobho 'Ukwamukela' bese ulinda kuze kuvele iwindi elishiwo ngezansi.

QAPHELA: Manje zonke izingosi zolwazi ezenziwe isipele ziku-inthanethi futhi ungakwazi ukufinyelela kuzo kalula noma nini lapho ufuna.

Indlela 2: Qamba kabusha isandiso:

Uma wazi isandiso esifanele sohlelo oludale ifayela le-bak, ungalibuyisela ngokuliqamba kabusha libe yifomethi yalo yokuqala yokunweba.

• Isibonelo, uma ufuna ukuvula ifayela le-BAK elihlonzwe njengedokhumenti ye-Word, kufanele ususe isandiso se-bak bese usiqamba kabusha ngesandiso se-DOC. Uma igama lefayela lilondolozwe ngokuthi «mydocumentback«, lapho-ke kufanele ushintshe uhlobo lwefayela ngokuliqamba kabusha libe «doc".

Ngemva kokuyiqamba kabusha, ungakwazi ukuvula ifayela ngqo nge Microsoft Word futhi ufinyelele okuqukethwe okulondoloziwe. Inqubo efanayo iyasebenza kumafayela okubhaka agcinwa njengefayela eliyisipele ledokhumenti ye-Notepad. Udinga ukuqamba kabusha isandiso sefayela le-bak njenge-txt ukuze ubuke idatha elondolozwe kuzo.

Indlela yesi-3: Thola ifomethi yefayela yoqobo yefayela le-bak elenziwe isipele:

Uma ungenalo ulwazi mayelana nefayela le-bak elikhona kukhompyutha yakho ephathekayo noma ikhompuyutha yomuntu siqu, futhi awukwazi ukuthola uhlelo oluqondile oludalile, udinga ukulivula njengombhalo wombhalo usebenzisa isoftware yokuguqula umbhalo njenge Abahleli Bamahhala Bombhalo Abangcono Kakhulu.

Ngokuzama ukuvula ifayela le-BAK ngokusebenzisa abahleli bombhalo abanjalo, ungathola uhlelo olunembile olugcine idatha ekuqaleni. Odinga ukukwenza ukufunda ifayela lombhalo elilayishiwe futhi ubheke izandiso ezingase zibonise ukunwetshwa kwefayela lokuqala ngendlela eyodwa noma enye.

Isibonelo, uma ifayela libizwe ngokuthi «archivebak»futhi kuthiwa itholakala kufolda engaziwa ku-hard drive yakho, kufanele uqale uyivule nge-software yokuhlela umbhalo.

Isithombe esishiwo ngezansi sibonisa ifayela le-bak elivulwe ngomhleli wombhalo I-Notepad++. Ungafakaza izingoma ezifana nokuthi «I-ID3» ekhona efayeleni elilayishiwe.

Uma ujwayele ukusesha ku-inthanethi, ungaqonda futhi ucace ukuthi iyisitsha semethadatha esisetshenziswa kakhulu kumafomethi wefayela. MP3. Manje, okudingeka ukwenze ukuyiqamba kabusha «archivebak"kuya"ifayela.mp3»ukubuyisela futhi ufinyelele ngokushesha ifayela le-BAK.

Ngokufanayo, uma i-BAK ivulwe kusihleli sombhalo ibonisa amathebula amaningi noma izici ezifana nombhalo, kufanele uqaphele ukuthi ifomethi yefayela yoqobo kuthiwa yi-CSV. Landela inqubo efanayo yokushintsha igama ngokungeza csv esikhundleni se-bak bese uyivula nge-Microsoft Excel ukuze uthole ulwazi olwengeziwe mayelana namafayela edatha alondoloziwe.

Indlela yesi-3: Kuyini futhi kanjani ukuvula ifayela le-bak?

Abasebenzisi abaningi kufanele ukuthi babone isandiso sefayela elithi 'bak' elinamafayela aqanjwe ngokuhlukile kunkomba yezinhlelo zabo zokusebenza. Isandiso ngasinye sinomsebenzi nencazelo ehlukile.

Ezinye izinhlelo zenza ikhophi yefayela lakho ngokuzenzakalela ngalesi sandiso njalo lapho ifayela lilondolozwe noma lehluleka. Abasebenzisi banelukuluku lokwazi ukuthi siyini isandiso sefayela le-bat nokuthi sisetshenziselwa ini. Kulesi sihloko, sizoxoxa ngesandiso se-bak nokuthi ungayivula kanjani uma kungenzeka.

Siyini isandiso sefayela le-bak?

BAK kusho Isipele Ifayela, isandiso sefayela esisetshenziswa izinhlelo zokusebenza eziningi ezahlukene ukugcina ikhophi yasenqolobaneni. Izinhlelo eziningi zenza ngokuzenzakalelayo amafayela e-BAK ukuze kugcinwe ikhophi eyisipele yefayela futhi ezinye zizodinga iziqondiso ezenziwa ngesandla kubasebenzisi.

Leli fayela lingasetshenziswa futhi ukuhlela ikhophi yefayela esikhundleni sokusebenzisa elokuqala. Kuyafana nokuqamba izikimu ezifana ifayela ~, ifayela.elidala , ifayela.orig njalonjalo.

I-Microsoft SQL Server iphinde isebenzisa isandiso sefayela le-bak ukuze igcine imininingwane egciniwe. Abasebenzisi bangagcina ikhophi yasenqolobaneni yolwazi lwabo lwe-MS SQL efayeleni elilodwa elinesandiso se-bak kudrayivu futhi basebenzise leli fayela ukubuyisela isizindalwazi kuseva ye-SQL esanda kufakwa.

Ezinye izinhlelo zokusebenza eziningi zisebenzisa izandiso zefayela le-bak ukuze zilondoloze izipele zazo.

Ezinye zezinhlelo zokusebenza ezijwayelekile nezaziwayo yilezi:

1. i-Google Chrome
2. HyperCam
3. MATLAB
4. I-Nootepad++
5. Photoshop
6. I-Sony vegas
7. I-SQL Server
8. I-TeamViewer Manager
9. WhatsApp
10. y Microsoft Word.

Isithombe: ifayela le-bak elisuka kufayela langempela

Ungalivula kanjani ifayela le-bak?

Leli fayela alifani namanye amafayela e-JPG noma e-TXT angavulwa kunoma yiluphi uhlelo ngaphandle kwenkinga. Amafayela e-BAK awasebenzi ngendlela efanayo namanye amafayela. Awukwazi ukuvula ifayela le-bak kwenye isofthiwe ethile kwenye, ngoba isofthiwe ngayinye idala ifayela layo elithile le-bak ukuze lisetshenziswe yona.

Ukuze sikubonise ukuthi isebenza kanjani ngohlelo lokusebenza oluhlukile, sizobonisa izindlela ezimbili ezivela ezinhlelweni ezimbili ezahlukene njengesibonelo.

Indlela 1: Ukusebenzisa ifayela le-bak ku-Notepad++

I-Notepad ++ Idala amafayela ayisipele ngesandiso se-bak, ukuze abasebenzisi bakwazi ukubuyisela umsebenzi wabo uma amafayela esusiwe noma onakala. Lokhu kuzosebenza kuphela uma inketho yokwenza isipele inikwe amandla kuzintandokazi zesofthiwe. Uma uyinike amandla, landela lezi zinyathelo ezingezansi:

1. I-Paso 1: chofoza kabilitu Isinqamuleli se-Notepad++ noma cindezela bese ubamba inkinobho Windows bese ucindezela S ukuvula search umsebenzi, kubhala I-Notepad ++ y Faka.
2. I-Paso 2: Chofoza imenyu Isethaphu ku-Notepad++ bese ukhetha Izintandokazi.
3. I-Paso 3: Kuphaneli yesokunxele, khetha inketho Yenza isipele futhi uqinisekise indlela yohla lwemibhalo kumafayela ayisipele (bak).

4. I-Paso 4: Ivula izintandokazi ze-Notepad++ ukuze uthole indawo yamafayela ayisipele
5. I-Paso 5: Thola ifayela eliyisipele, chofoza inkinobho yesokudla kuyo bese ukhetha vula nge-Notepad++.

I-PRO ICEBISO: Uma inkinga ikukhompyutha yakho noma ikhompyutha ephathekayo/incwajana yokubhalela, kufanele uzame ukuyisebenzisa Ukulungisa i-Restoro, engaskena amakhosombe futhi imiselele amafayela akhohlakele futhi engekho. Lokhu kusebenza ezimweni eziningi, lapho inkinga isuka khona ngenxa yenkohlakalo yesistimu. Ungalanda i-Restoro ngokwenza chofoza lapha

1. I-Paso 6: Uzothola wonke umbhalo efayelini ngaphambi kokugcina kokugcina. Manje usungayigcina njengefayela lombhalo noma ukopishe umbhalo futhi uwusebenzise kwelinye ifayela, kukuwe lokho.

Indlela yesi-2: Vula ifayela le-bak ku-Microsoft SQL Server

Iseva ye-SQL idala ifayela eliyisipele sesizindalwazi ngesandiso se-bak. Lesi sipele singasetshenziswa ukubuyisela isizindalwazi kuseva esanda kufakwa. Ukugcina ikhophi yasenqolobaneni kuhlale kuyingxenye ebalulekile yomsebenzi wakho. Ungakwazi ukubuyisela i-database ngokulandela lezi zinyathelo ezilandelayo:

1. I-Paso 1: vula I-SQL Server Management Studiongokusebenzisa I-Microsoft SQL Server bese uxhuma kuseva yakho ngokukhetha igama leseva.
2. I-Paso 2: Kuphaneli yesokunxele, chofoza kwesokudla ifolda Isizindalwazi bese ukhetha Buyisela Isizindalwazi.

3. I-Paso 3: Iwindi le-Restore Database lizovuleka, manje Khetha i umthombo wokubuyisela njenge" Kusuka kudivayisi »bese uchofoza inkinobho inkinobho yendawo yefayela

4. I-Paso 4: Manje chofoza inkinobho Engeza bese ubheka i- ifolda yokusekelayo yedatha ukubuyisela isizindalwazi. Khetha uhlobo lwefayela njenge-» Ifayela eliyisipele (*bak, *.tm) »kanye negama lefayela njenge » DRMS_Config «, bese uchofoza ukwamukela

1. I-Paso 5: Ewindini elilandelayo, khetha igama lesizindalwazi sakho kumenyu yokudonsela phansi Kusizindalwazi bese uyadayela la Buyisela ibhokisi en Khetha amasethi ekhophi yasenqolobaneni ozowabuyisela njengoba kukhonjiswa kokulandelayo:

1. I-Paso 6: Chofoza ukwamukela futhi uma isiqedile, kuzovela iwindi le-pop-up lesaziso sokubuyisela ngempumelelo.

ISIPHAKAMISO: Uma zingekho izindlela ezikuxazululele inkinga, sincoma ukuthi usebenzise ithuluzi lokulungisa I-restoro, engaskena amakhosombe ukuze amiselele amafayela awonakele nangekho. Lokhu kusebenza ezimweni eziningi, lapho inkinga isuka khona ngenxa yenkohlakalo yesistimu. I-Restoro izophinda ithuthukise isistimu yakho ukuze isebenze kahle kakhulu. Ungalanda i-Restoro ngokwenza chofoza lapha

Indlela yesi-4: Ezinye izindlela zokuvula ifayela le-bak nge-MS SQL Server Backup ku-Excel

Manje, ake sibheke ezinye izindlela zokuvula ifayela le-bak nge-MS SQL Server Backup ku-Excel:

Ingxenye 1: Vula ifayela le-bak SQL ku-Excel

Ngaphambi kokuthi uqale, thola umkhombandlela wefayela le-bak kukhompyutha yakho ye-SQL Server. Lena indlela ezenzakalelayo lapho i-SQL Server igcina khona ifayela le-bak:

• Amafayela Ohlelo > Iseva ye-Microsoft SQL > MSSQL 1.0 > MSSQL > ISIPELE
• C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup

Ake sibone ukuthi ungalivula kanjani ifayela lakho eliyisipele. Idatha ye-SQL ku-Excel ngezindlela ezintathu ezilandelayo:

Indlela 1. Guqula i-SQL Bak ibe yi-Excel ngokwakho

QAPHELA- Le ndlela inikezwa iwebhusayithi yezinkampani zangaphandle njengendlela esheshayo yokuguqula nokuvula ifayela le-bak ku-Excel. Futhi ungazama ngale ndlela ukuvula ifayela lakho le-bak le-SQL Server ku-Excel. Ake siqale:

1. I-Paso 1: Thola futhi uthole ifayela le-SQL bak kudrayivu yakho yasendaweni. Uma ungabonanga ifayela le-bak endaweni enikezwe ngenhla, sebenzisa umyalo olandelayo ku-SSMS ukuze uthole uhla lwemibhalo yefayela lakho eliyisipele lesizindalwazi se-SQL - bak:

KHETHA IsizindalwaziIgama = x.database_name,

LastBackupFileName = x.physical_device_name,

LastBackupDatetime = x.backup_start_date

KUSUKA ( KHETHA bs.database_name,

bs.backup_start_date, bmf.physical_device_name,

Okujwayelekile

= ROW_NUMBER() PHEZULU( ISIQEPHU NGE-bs.database_name I-ORDER BY bs.backup_start_date DESC )

KUSUKA ku-msdb.dbo.backupmediafamily bmf

JOIN msdb.dbo.backupmediaset bms INTO bmf.media_set_id = bms.media_set_id

JOYINA msdb.dbo.backupset bs ON bms.media_set_id = bs.media_set_id

LAPHO bs.[uhlobo] = 'D'

Futhi bs.is_copy_only = 0 ) x

LAPHO x.Ordinal = 1

I-ORDER BY DatabaseName;

2. I-Paso 2: Kopisha bese ulondoloza ifayela le-bak kwenye idivayisi evikelekile.
3. I-Paso 3: Vula i-File Explorer > Buka > Izinketho > susa ukumaka «Fihla izandiso zezinhlobo zamafayela ezaziwayo»Bese uchofoza«ukwamukela".

4. I-Paso 4. Vula idivayisi ngefayela le-bak le-backup yedatha ye-SQL ekopishiwe bese uchofoza kwesokudla kuyo.
5. I-Paso 5. Khetha «Shintsha igama> > shintsha isandiso sefayela elithi "bak" sibe "xls" noma "xlsx".
6. I-Paso 6. Chofoza kabili ifayela eliqanjwe kabusha bese ulivula ku-Excel.

Ungabe usuhlola idatha ye-SQL bak kusipredishithi se-Excel futhi uhlele ngisho nesizindalwazi ngendlela ofuna ngayo.

Indlela 2. Buyisela i-bak kuseva ye-SQL bese uthumela isizindalwazi ku-Excel

Le ndlela ihlanganisa izinqubo ezimbili: 1. Udinga ukubuyisela ifayela eliyisipele lesizindalwazi se-bak ku-SQL Server; 2. Thumela isizindalwazi esibuyiselwe ku-Excel. Nansi imihlahlandlela enemininingwane:

1. Buyisela i-bak ku-SQL Server nge-SQL Server Management Studio

Landela lezi zinyathelo ezingezansi ukuze ubuyisele ifayela le-bak nge-SQL Server Management Studio:

1. I-Paso 1. Vula i-SSMS (SQL Server Management Studio), chofoza kwesokudla kusizindalwazi lapho ufuna ukubuyisela khona i-data bak bese ukhetha "Imisebenzi" > "Buyisela" > "Isizindalwazi".

2. I-Paso 2. Chofoza inkinobho yamachashazi amathathu eduze kwe-«Kusuka kudivayisi«, zulazula ukuze ukhethe ifayela le-bak elondolozwe kudrayivu yakho yasendaweni.

3. I-Paso 3. Chofoza ku-«Engeza»ukucacisa indawo ngqo lapho ugcine khona ifayela le-bak, likhethe bese uchofoza okuthi «ukwamukela"ukuqinisekisa.

4. I-Paso 4. Ibhrendi "Isipele Esigcwele Sesizindalwazi»Futhi«Isipele selogi yokwenziwe«, Chofoza«ukwamukela"ukuqinisekisa.

5. I-Paso 5: Uma uqeda inqubo yokubuyisela, chofoza okuthi «ukwamukela"ukuqeda.

QAPHELA: Uma ifayela le-bak liqukethe ikhophi yasenqolobaneni yesizindalwazi sakho se-SQL, yonke le nqubo iphinde isebenze ukubuyisela isizindalwazi sakho se-SQL Server esonakele esigcinweni.

2. Thumela ifayela le-bak elibuyiselwe - Isizindalwazi se-SQL ku-Excel

I-SQL Server Management Studio, enewizadi yokungenisa nokuthekelisa, ikuvumela ukuthi ukhiphe ifayela le-bak elibuyiselwe: isizindalwazi. SQL kuya ku-Excel. Qaphela ngezinyathelo ezilandelayo zemanuwali zokuthekelisa isizindalwazi se-SQL:

1. Isinyathelo se-1.Vula i-SQL Server Management Studio bese ungena ngemvume nge-akhawunti yakho yomlawuli.
2. Isinyathelo se-2.Iya kokuthi Object Explorer, chofoza kwesokudla noma iyiphi i-database ofuna ukuyivula ku-Excel, bese ukhetha «Imisebenzi» > «Khipha idatha…».

3. Isinyathelo se-3.Faka i-SQL Server Import and Export Wizard, chofoza “Okulandelayo"ukuqhubeka.
4. Isinyathelo se-4.Khetha umthombo wedatha ofuna ukukopisha kuwo idatha njengoba kuboniswe ngezansi bese uchofoza okuthi «Okulandelayo»ukuze uqhubeke:
   1. Umthombo wedatha: SQL Server Native Client 11.0
   2. Igama leseva: Iseva ye-SQL lapho idatha kufanele ikopishwe kuyo
   3. Ukufakazela ubuqiniso- Sebenzisa i-Windows Authentication njengoxhumano lomthombo wedatha
   4. Database- Khetha isizindalwazi osibuyisele efayelini le-bak.

5. Isinyathelo se-5.Khetha indawo ozokopisha kuyo idatha kusuka kusizindalwazi uye ku-Excel bese uchofoza okuthi «Okulandelayo»ukuze uqhubeke:
   1. Indawo - Microsoft Excel
   2. Umzila Wefayela le-Excel - Khetha indawo yedatha ekopishwe kumthombo wedatha we-SQL Server
   3. Inguqulo ye-Excel - Cacisa inguqulo ye-Excel oyisebenzisa ku-PC yakho

6. Isinyathelo se-6.Ikhophi yethebula elithile noma umbuzo: Khetha «Kopisha idatha kuthebula elilodwa noma ngaphezulu noma ukubuka«, Chofoza«Okulandelayo"ukuqhubeka.

7. Isinyathelo se-7.Khetha amathebula omthombo nokubukwa: Khetha amathebula okuyiwona kanye nokubukwa ofuna ukuwavula ku-Excel bese uchofoza okuthi «Okulandelayo"ukuqhubeka.

QAPHELA: Ungaphinda ukhethe ithebula elithile bese uchofoza okuthi «Ukubuka kuqala»ukuqinisekisa idatha kusenesikhathi.

8. Isinyathelo se-8.Khetha "Gijima ngokushesha» ngaphansi kokuthi Gcina bese Ugijima Iphakheji, chofoza «Okulandelayo"ukuqhubeka.

9. Isinyathelo se-9.Chofoza ku- «Qeda»kuWizadi Egcwele.
10. Isinyathelo se-10.Chofoza inkinobho eyehlayo yombiko bese ukhetha okuthi «Londoloza umbiko kufayela..."ukuqhubeka.

1. Isinyathelo se-11.Khetha i-Excel njengefayela okuyiwa kulo bese ungakwazi ukuvula isizindalwazi se-SQL esithunyelwe ku-Excel.

Indlela 3. Sebenzisa I-Bak SQL Yenkampani Yasesithathu kuya Ithuluzi Lokuguqula I-Excel

Kwamanye amawebhusayithi omthombo ovulekile, abanye onjiniyela baphinde bakhiqize i-SQL yenkampani yangaphandle ithuluzi lokuguqula i-Excel. Kulula futhi kulula ukuguqula ifayela le-SQL bak libe yi-Excel. Uma ufuna ukuzama leli thuluzi, sesha ku-inthanethi futhi uzolithola.

• Isibonelo, ukuguqulwa kusuka ku-SQL kuya ku-Excel.

Ingxenye 2. Lungisa Isizindalwazi Se-SQL Esonakele ngaphandle kwefayela le-bak (Isipele Sesizindalwazi)

Ngendlela 1 #1, inqubo yokubuyisela ifayela le-bak ku-SQL Server nge-SSMS ingasiza ukubuyisela isizindalwazi esonakele noma esisusiwe ku-SQL.

Nokho, uma usule ngephutha amarekhodi kusizindalwazi se-SQL noma isizindalwazi se-SQL sonakala ngesizathu esithile, uzokwenzani?

Uzowabuyisela kanjani amalogi asusiwe noma ulungise isizindalwazi esonakele? Ngenhlanhla, ithuluzi lochwepheshe lokutakula i-SQL lingasiza kule nkinga, njengokuvula ifayela le-bak.

I-EaseUS MS SQL Recovery, enesici esinamandla, ingabuyisela ngempumelelo amarekhodi alahlekile kusizindalwazi sakho.

Ungalanda i-EaseUS MS SQL Recovery lapha

Ihambisana nazo zonke izinguqulo ze-MS SQL Server kuhlanganise ne-SQL Server 2017/2016/2014/2012/2008. Landela umhlahlandlela onemininingwane ngezansi ukuze ulungise imininingwane yakho egciniwe ye-SQL Server kalula:

1. Isinyathelo se-1:Khetha isizindalwazi esilimele ukuze ululame
   1. Qala i-EaseUS MS SQL Recovery.
   2. Khetha ifayela lesizindalwazi elonakele ngokuchofoza «Hlola» (ikholoni) noma «Ukucinga".
   3. Ngemva kokukhetha ifayela, chofoza okuthi «Ukulungisa»ukuqala inqubo yokuhlaziya.

Nota: Ukusebenzisa le softhiwe, kufanele umise isevisi ye-SQL Server.

2. Isinyathelo se-2:lungisa isizindalwazi esilimele
   1. Isofthiwe ibonisa zonke izinto ezibuyiselekayo kusakhiwo esifana nesihlahla. Izinto ziboniswa kuphaneli yesokunxele.
   2. Khetha ingxenye ofuna ukuyibuyisela. Efasiteleni, chofoza okuthi «Thumela".

3. Isinyathelo se-3:Thekelisa kusizindalwazi noma njengemibhalo
   1. Khetha ukuthekelisa izinto zesizindalwazi kusizindalwazi noma ukhiphe izinto njengemibhalo
   2. Uma ukhetha «Khipha kusizindalwazi«, faka ulwazi oludingekayo bese ukhetha isizindalwazi sendawo oya kuyo.

4. I-Paso 4: Iwindi liyavela likucela ukuthi unikeze ngemininingwane ukuze uxhume kuseva nendawo oya kuyo ukuze ulondoloze izinto ezitholiwe. Ukuze uqale inqubo yokulungisa, chofoza "Ukwamukela".

QAPHELA: Ngaphambi kokuchofoza «ukwamukela«, kufanele uqale kabusha isevisi ye-SQL Server.

Imibuzo evamise ukubuzwa mayelana nendlela yokuvula ifayela le-BAK

1. Isiqephu 1: Ingabe ukhona owaziyo ukuthi ungavula kanjani ifayela le-SQL bak ku-Excel? Ngimusha ku-SQL futhi angijwayelene kakhulu nombuzo we-SQL. Kuhlala kungithatha isikhathi eside ukufinyelela ifayela le-SQL. Kungenzeka yini ukuvula ifayela le-SQL bak ku-Excel ngendlela elula?
2. Isiqephu 2: Ngingakwazi ukuhlola ifayela le-SQL .back uma isizindalwazi se-SQL sonakalisiwe? Ngingakwazi ukuyivula kufayela le-Excel futhi ngibuyisele ifayela le-bak ku-SQL?

Iningi labalawuli abasha be-MS SQL banomuzwa ofanayo wokuthi kuyinkimbinkimbi ukusebenzisa imibuzo ye-SQL noma izinhlelo zokusebenza ze-SQL ukuhlola noma ukuvula amafayela athile e-SQL bak.

Futhi, ngezinye izikhathi lapho isizindalwazi se-SQL sonakala, isicelo sokubuyisela ifayela le-bak ku-SQL Server sidida abalawuli abasha.

Ungase ube nentshisekelo yokufunda mayelana: Liyini ifayela le-BAK? Engani kanye nendlela yokuyivula

Uma ungomunye walaba balawuli abasha, onenkinga yokuvula ifayela le-SQL bak ku-Excel, khetha izindlela ezithembekile njengalezi esisanda kuzidalula ukuze sixazulule inkinga yakho kalula.

Isiphetho

Sithemba ukuthi lolu lwazi luwuphendulile umbuzo wakho: ulivula kanjani ifayela le-BAK? Manje okumele ukwenze ukuzama lokho esikufundise khona. Ngalokhu ungakwazi ukuvusa lawo mafayela okungewakho, umngane noma umuntu omaziyo owayengazi ukuthi kwenziwa kanjani.