Kungani DataNumen SQL Recovery?


#1 Izinga Lokubuyisela

# 1 Ukubuyiselwa
ubende

10+ Million Abasebenzisi

10+ Izigidi
Abasebenzisi

Iminyaka engu-20 + Yokuhlangenwe nakho

I-20 + Iminyaka
Experience

Isiqinisekiso Sokweneliseka se-100%

Ukwaneliseka okungu-100%
Isiqinisekiso

Phinda Uthole Okungaphezulu Kokuncintisana Kwethu


DataNumen SQL Recovery vs. DBCC CheckDB & CheckTable, Recovery Toolbox for SQL Server, Ukulungiswa kwe-Stellar Ye-MS SQL, njll.

Isilinganiso Sokubuyisela Esimaphakathi

Ukuqhathanisa Ishadi

Funda kabanzi mayelana nokuthi kanjani DataNumen SQL Recovery kubhema umncintiswano

Ubufakazi Bekhasimende Lethu

Isixhumanisi Esilula Kakhulu


Isixazululo Sokulandela Amaphutha Avamile Nezinkinga ku SQL Server Ifayela Lesizindalwazi


izixazululo

OKUNINGI


U-downloader mahhalaIminyaka engu-20+ Yokuhlangenwe nakho
Thenga ManjeIsiqinisekiso Sokweneliseka se-100%

Izici main



U-downloader mahhalaIminyaka engu-20+ Yokuhlangenwe nakho
Thenga ManjeIsiqinisekiso Sokweneliseka se-100%

Buyisa Konakele SQL Server Imininingo egciniwe ene DataNumen SQL Recovery


Qalisa DataNumen SQL Recovery.

DataNumen SQL Recovery 7.0

ukunakwa: Vala ezinye izinhlelo zokusebenza ezingashintsha ifayela le-MDF ngaphambi kokuthi wenzetart.

Khetha ifayela ongathanda ukulilungisa, ngokufaka igama lefayela le-MDF noma ngokuchofoza inkinobho Dlulisa amehlo inkinobho. Futhi, ungasebenzisa i- Thola inkinobho ukuyicinga.

Khetha Ifayela Lomthombo

Uma kwenzeka kukhona ifayela le-NDF elilodwa noma amaningi ahlotshaniswa nefayela le-MDF elimele, wengeze futhi:

Khetha Umthombo NDF Ifayela

Cacisa ifomethi yefayela lesizindalwazi somthombo uma ulazi:
Khetha ifomethi yomthombo

Uma ungayicacisi ifomethi, ke DataNumen SQL Recovery izozama ukuhlaziya ifayela elingumthombo ukuze ithole ifomethi.

Ngephutha, DataNumen SQL Recovery izolondoloza idatha etholiwe kufayela elisha xxxx_fixed.mdf. I-xxx imele igama lefayela elingumthombo. Ngakho-ke, uma ifayela elingumthombo bekuyi-MySQLDB.mdf, ifayela elitholiwe lizoba MySQLDB_fixed.mdf. Ungakwazi futhi ukuqamba kabusha:

Khetha Ifayela Lendawo

Ungafaka igama ngqo. Noma, shaya i- Dlulisa amehlo inkinobho ukuyisetha. Qiniseka ukuthi kunesikhala sediski esanele sayo. Ungakwazi ukulinganisa isikhala esidingekayo ngokusekelwe kusayizi wefayela elingumthombo.

Chofoza Start Ukutakula inkinobho futhi DataNumen SQL Recovery izokwazisa i- "Xhuma ku SQL Server" ibhokisi lengxoxo, njengoba lidinga ukuxhuma ku-a SQL Server isibonelo ukwenza ukubuyisela:

Xhuma ku SQL Server Ibhokisi Lezingxoxo

Setha Igama leseva futhi Ukufakazela ubuqiniso Okwe SQL Server isibonelo kukhompuyutha yasendaweni noma ekude. Bese, chofoza okuthi "APPROX" inkinobho. Isofthiwe yethu yokutholwa kwe-MDF izozama ukuthola ukuqoqwa kwesizindalwazi somthombo, bese isetha ukuqoqwa kwesizindalwazi sendawo okuyiwa kuyo ngokufanele. Uma ingakwazi ukubona ukugoqa, izokucela ukuthi ukusethe. Ngemuva kwalokho izoskena yonke imininingwane egciniwe, ilungise ifayela le-MDF, futhi ibuyisele idatha ngama-algorithms akhethekile.

Ibha ibonisa ukuqhubeka kwenqubo yokutholwa kwedatha:

Progress Bar

Uma inqubo isiqediwe, uzobona isaziso esinjengalesi uma kungenzeka ukubuyisela ifayela loqobo le-MDF:

Impumelelo Box Box

Start Microsoft SQL Server I-Management Studio ukuze ufinyelele okutholiwe SQL Server imininingwane.

Ulwazi olubanzi


Ngingayithola kuphi idatha etholiwe?

Idatha etholiwe ikhishwa kusizindalwazi esisha ku- SQL Server isibonelo oxhuma kuso lapho u-starvula inqubo yokutakula ye-SQL MDF.

Igama lefayela le-MDF lesizindalwazi esiphumayo licaciswa ngaphambi kokuthi u-start ukululama.

Ngokuvamile, awudingi ukufinyelela ifayela le-MDF ledathabhesi le-SQL ngokuqondile. Ngemva kwenqubo yokutakula, ukuze ufinyelele idatha etholiwe, sicela wenze kanje:

  1. Start SQL Server Ukuphathwa Studio.
  2. Xhuma kufayela le- SQL Server isibonelo esifanayo naleso osisebenzisile ukuthola isizindalwazi sakho esonakele.
  3. Ngemva kokuxhumana, chofoza isenzakalo.
  4. Bese uchofoza yolwazi indawo.
  5. Bese uzothola isizindalwazi esisodwa noma ezinye ezibizwa ngokuthi “Database_Recovered_On_yyy_mm_dd_hh_mm_ss_#”, lapho yyyy, mm, dd, hh, mm, ss kuyisikhathi lapho isizindalwazi sidalwa, okungukuthi, unyaka, inyanga, usuku, ihora, umzuzu nomzuzwana. Futhi u-# uyinombolo yokulandelana u-starting kusuka ku-1. Lolu lwazi lungakusiza kalula ukuthi ubone isizindalwazi esikhiqizwe enqubweni yakamuva yokutakula.
  6. Chofoza i-node ye-database oyihlonzayo. Ungabe usufinyelela zonke izinto ezitholiwe ze-SQL database. Ngokwesibonelo, ngaphansi Amathebula node, ungabona wonke amathebula esizindalwazi atholiwe, okuhlanganisa ama-schema namarekhodi.

Indlela yokunciphisa ukulahleka kwedatha ngesikhathi se- SQL Server inhlekelele yedatha?

Kunconywa ukuthi ulungisele uhlelo lwakho lokuhlenga izinhlekelele (DR) SQL Server isibonelo, ngokuvamile okuhlanganisa:

  1. Yenza isipele sakho njalo SQL Server idatha.
  2. Iba nethuluzi lokuthola kabusha le-SQL lochwepheshe njenge DataNumen SQL Recovery esandleni. Ngakho-ke lapho uhlangabezana nenkohlakalo yesizindalwazi se-SQL, ungayisebenzisela ukulungisa amafayela akhohlakele futhi ubuyisele idatha yakho ngokushesha okukhulu.
  3. Sebenzisa izici zokutholakala okuphezulu ku SQL Server.

Yiziphi izinzuzo zomkhiqizo wakho ngaphezu kwamanye amathuluzi okuthola imininingwane egciniwe ye-MS SQL?

Ungathola okuphelele ukuqhathanisa ukuncintisana yomkhiqizo wethu namanye amathuluzi okuthola imininingwane egciniwe ye-MS SQL emakethe.

Ngingamisa isikhashana/ngiqalise kabusha inqubo yokulungisa imininingwane ye-SQL?

Lokho akunakwenzeka. Uma inqubo yokulungisa ibe started, khona-ke ungakwazi ukukuhoxisa noma ukuyeke kuqedele. Kamuva uma ufuna ukulungisa kabusha ifayela elifanayo lesizindalwazi se-SQL, udinga ukuphinda ulungisetart inqubo yokulungisa kusukela ekuqaleni.

Nokho, phakathi nenqubo yokulungisa, ungabona idatha walulama ku SQL Server isitudiyo sokuphatha ngesikhathi esifanayo. Uma ucabanga ukuthi yonke idatha efunwayo isibuyisiwe, ungasusa inqubo yokulungisa ukuze wonge isikhathi sakho, ngaphandle kokulimaza isizindalwazi esiphumayo.

Nginefayela le-SQL MDF kuphela, ifayela le-transaction log (LDF) lithi lost. Okufanele ngikwenze?

DataNumen SQL Recovery ingabuyisa idatha yakho efayeleni le-MDF elonakele ngaphandle kwefayela le-MDF ifayela le-transaction log (LDF). Ngakho-ke uma ifayela lakho lokungena kokuthengiselana lingu-lost, lokho ngeke kube yinkinga.

Ingabe uyasekela ukubuyisela irekhodi ledatha ngohlobo lwe-XML?

Yebo, isofthiwe yethu yokutakula isizindalwazi se-SQL isekela ukubuyisela amarekhodi kuzo zombili izinhlobo zedatha ye-ASCII ne-Unicode XML.

Ingabe ngidinga ukuba umqondisi wesizindalwazi (i-DBA) ukuze ngenze ukutakula?

Yebo, kufanele ube umqondisi wesizindalwazi (i-DBA), noma okungenani uthole ulwazi olulandelayo kumphathi wesizindalwazi (DBA):

  1. SQL Server igama lesibonelo(Igama Leseva)
  2. Ukuqinisekiswa kwe- SQL Server isibonelo.

Ngakho ungasebenzisa lolu lwazi ukuze uxhume ku- SQL Server isibonelo futhi wenze ukubuyisela.

Ingabe iMicrosoft SQL Server unethuluzi elakhelwe ngaphakathi lokubuyisela isizindalwazi esonakele?

Yebo, banayo imiyalo eyakhelwe ngaphakathi ye-dbcc, okungukuthi, i-dbcc checkdb kanye nethebula lokuhlola le-dbcc, elingahlola izikimu zethebula namarekhodi, bese lilungisa izinkinga ezincane kusizindalwazi sakho esonakele noma amathebula esizindalwazi. Kodwa-ke, lawa mathuluzi asebenza kuphela enanini elilinganiselwe lamacala. Uma bengakwazi ukulungisa ukonakala kwefayela le-MDF, kungcono uzame DataNumen SQL Recovery, okusebenza kangcono kakhulu.

Okunye ukusetshenziswa okuyisisekelo kwe-dbcc checkdb kubalwe ngezansi:

Umyalo Ukusetshenziswa
dbcc checkdb('MyDB.mdf') Hlola ukuthi i-MyDB.mdf ayinazo yini izinkinga.
dbcc checkdb('MyDB.mdf', REPAIR_ALLOW_DATA_LOSS) Hlola i-MyDB.mdf. Uma kukhona izinkinga, lungisa ifayela le-MDF lesizindalwazi, okungase kubangele ukulahleka kwedatha.
dbcc checkdb('MyDB.mdf', REPAIR_REBUILD) Hlola i-MyDB.mdf. Uma kukhona izinkinga, lungisa ifayela ledatha ye-MDF, elizokwenza HHAYI kubangele ukulahleka kwedatha, kodwa kungase kuthathe isikhathi esiningi.

Okunye ukusetshenziswa okuyisisekelo kwethebula lokuhlola le-dbcc kubalwe ngezansi:

Umyalo Ukusetshenziswa
dbcc checktable('MyDB.MyTable') Hlola ukuthi i-MyTable ku-MyDB inazo yini izinkinga.
dbcc checktable('MyDB.MyTable', REPAIR_ALLOW_DATA_LOSS) Hlola i-MyTable ku-MyDB. Uma kukhona izinkinga, lungisa ithebula, okungase kubangele ukulahleka kwedatha.
dbcc checktable('MyDB.MyTable', REPAIR_REBUILD) Hlola i-MyTable ku-MyDB. Uma kukhona izinkinga, lungisa itafula, okuzokwenza HHAYI kubangele ukulahleka kwedatha, kodwa kungase kuthathe isikhathi esiningi.

Singakanani isikhala sediski engisidingayo ukuze ngilungiselele imininingwane egciniwe?

Okokuqala, udinga ukubala usayizi ophelele wedatha yomthombo, okuhlanganisa ifayela le-MDF lesizindalwazi se-SQL nawo wonke amafayela e-NDF ahlobene. Kucatshangwa ukuthi yi-SDataSize.

Bese, ngokusekelwe ku-SDataSize, kufanele ulungiselele okungenani u-2 * (SDataSize * 110%) kusizindalwazi sokuphumayo endaweni oyifunayo, okuhlanganisa kokubili ifayela le-SQL MDF nefayela le-LDF.

Kungani my SQL Server I-database iyonakala?

Kunezizathu eziningi ezingabangela inkohlakalo yedatha ye-SQL, kuhlanganise:

  1. Izizathu zezingxenyekazi zekhompuyutha: njengokuhluleka kwamandla, imikhakha emibi kumadiski, ukwehluleka kwe-hard disk, ukuvala shaqa okungalindelekile kwesistimu, njll.
  2. Izizathu zesofthiwe: njengokonakala kwesofthiwe, ukutheleleka ngegciwane, ukuhlaselwa kwe-ransomware, ukwehluleka kwekhophi yasenqolobaneni, isihloko sefayela lesizindalwazi esingavumelekile, njll.

DataNumen SQL Recovery iyakwazi ukubuyisela idatha yazo zonke izimo ezingenhla.

Ithini ifomethi yamafayela atholiwe?

DataNumen SQL Recovery izoxhuma ku SQL Server isibonelo bese uyisebenzisela ukukhiqiza isizindalwazi esitholiwe. Ngakho ifomethi yamafayela atholiwe iyafana ne SQL Server inguqulo yesibonelo oxhumeka kuso lapho wenza ukutakula. Isibonelo, uma uxhuma ku SQL Server Isibonelo sika-2000, khona-ke i-database ephumayo izophinde ibe phakathi SQL Server 2000 ifomethi.

Yiziphi izinhlobo ze- SQL server bayasekelwa?

DataNumen SQL Recovery ukusekela ukubuyisela imininingwane yolwazi ye-SQL edalwe yizinguqulo ezilandelayo ze-MS SQL Server: SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.

Ingakwazi ukuxhuma kuzinguqulo ezilandelayo ze SQL Server izimo zokukhiqiza i-database engashintshi: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019. Isizindalwazi esilungisiwe sizogcinwa enguqulweni efanayo naleyo SQL Server isibonelo.

Ungakwazi yini ukukhipha isizindalwazi esitholiwe njengesikripthi se-SQL?

Izinguqulo zangaphambili ze DataNumen SQL Recovery sekela isici esinjalo. Nokho, sisisusile lesi sici ezinguqulweni zakamuva.

Ingabe uyasekela ukubuyisela izinkomba nezinye izinto?

Yebo, izinkomba, okhiye abayinhloko, ukubuka, izibangeli, imithetho, okumisiwe, izinqubo ezigciniwe, nezinye izinto ziyasekelwa.

Ngehluleka ukuthola isizindalwazi se-SQL ngethuluzi lakho lokutakula ifayela. Ngicela usizo.

Ngiyacela Xhumana nathi futhi unikeze ilogu yokutakula. Ungathola imininingwane eyengeziwe ku indlela yokuthola ilogi yokutakula.

Ngezinye izikhathi, ngenxa yenhlekelele yedatha, ifayela le-MDF namafayela e-NDF angase angaqukathi idatha yangempela ye-SQL. Kodwa idiski noma idrayivu lapho ogcine khona amafayela e-MDF noma e-NDF asengaqukatha idatha ebuyiselekayo. Ungakwazi buyisela idatha yakho kudiski noma shayela ngqo.

Ngingakwazi ukulondoloza isizindalwazi esitholiwe kumafayela edatha amaningi?

Uxolo kodwa okwamanje ithuluzi lethu elikhohlakele le-SQL lokuthola imininingwane egciniwe alikusekeli ukulondoloza imininingwane egciniwe etholiwe kumafayela edatha amaningi, okungukuthi, ifayela elilodwa ledatha eliyisisekelo (MDF) kanye namafayela edatha ambalwa wesibili (NDF).

Nokho, ngemva kokuba inqubo yokutakula ye-SQL MDF isiqediwe, ungenza kanje ukuze usebenzise umgomo wakho:

  1. Start SQL Server isitudiyo sokuphatha.
  2. Dala i-database entsha futhi klama amafayela namaqembu wamafayela ngokusekelwe kuzimfuneko zakho, njengokusabalalisa idatha kumafayela ambalwa.
  3. Clone isizindalwazi esitholiwe kusukela kusizindalwazi esitholiwe kuya kusizindalwazi esisha esidalwe esinyathelweni sesi-2. Okunye, ungakwazi futhi ukuthekelisa isizindalwazi esitholiwe njengombhalo we-SQL, bese ungenisa umbhalo emuva kusizindalwazi esisha.

Iyini imikhawulo yenguqulo yedemo?

Inguqulo yedemo isebenzisa injini yokutakula idatha efanayo njengenguqulo egcwele, ngaphandle kokuthi izofaka imibhalo yedemo kwezinye izinkambu kusizindalwazi esitholiwe.

Ungakwazi ukubuyisela i-schema yetafula kuphela?

Isofthiwe yethu yokubuyisela isizindalwazi se-SQL izobuyisela yonke imininingwane egciniwe, okuhlanganisa amatafula nazo zonke ezinye izinto. Kumathebula, kokubili i-schema yethebula kanye nedatha yerekhodi yethebula izotholwa. Akwenzeki ukubuyisela i-schema yethebula kuphela.

Yiziphi izinguqulo ze-Windows ezisekelwayo?

Okwamanje, izinhlelo zokusebenza ze-Windows 95/98/ME/NT/2000/XP/Vista/7/8/8.1/10/11 kanye ne-Windows Server 2003/2008/2012/2016/2019 ziyasekelwa. Futhi, womabili amasistimu we-32bit kanye ne-64bit asekelwa.

Ungakwazi yini ukukhipha isizindalwazi njenge-MDF eyodwa namafayela amaningi e-NDF?

Uxolo kodwa okwamanje sisekela kuphela ukukhipha ifayela elilodwa le-SQL MDF.

Ithuluzi lakho lokuthola kabusha ifayela libonisa iphutha lapho ubuyisela inkomba. Indlela yokuxazulula inkinga?

Ezinye izinkomba zinemigoqo ethile ekhethekile, efana nehlukile, kuyilapho idatha etholiwe ingase ingahlangabezani nalezi zingqinamba. Ngemva kwenqubo yokutakula i-SQL MDF, ungenza kanje ukuxazulula inkinga:

  1. Susa idatha engasabalulekile ukuze wenze isiqiniseko sokuthi idatha esele ihlangabezana nemikhawulo. Bese wakha kabusha inkomba ngesandla.

or

2. Susa ezinye izithiyo kunkomba bese uyakha kabusha mathupha.

Ungenza kokubili oku-1 no-2 ngemibhalo ye-SQL.

Nginefayela le-MDF elonakele kuphela. Amafayela e-NDF ahlobene awakho. Ungakwazi yini ukubuyisela idatha?

Yebo, ngisho noma unefayela lesizindalwazi eliyisisekelo kuphela, isofthiwe yethu yokutakula ye-MDF isengakubuyisela idatha. Kodwa-ke, yilabo kuphela abakufayela le-MDF elingatholwa. Lawo akumafayela e-NDF awasakwazi ukuphinda alulame njengoba ungenawo amafayela e-NDF.

Ungakwazi yini ukubuyisela izinto ezibethelwe?

Yebo singakwazi. Futhi izinto ezibethelwe, njengezinqubo ezigciniwe, zizobuyiswa futhi zilondolozwe njengezinguqulo ezisusiwe.

Ungakwazi yini ukubuyisela amarekhodi asusiwe?

Yebo, ngokuzenzakalelayo, ithuluzi lethu lokubuyisela ifayela lizobuyisela amarekhodi asusiwe. Ungakwazi futhi ukushintsha inketho, ngokulandelayo:

  1. Start ithuluzi lethu lokutakula le-SQL MDF.
  2. Chofoza ithebhu "Izinketho".
  3. Hlola/Susa ukumaka inketho ethi “Buyisela amarekhodi asusiwe” ngokufanele.
  4. Lungisa amafayela e-MDF.

Kuthiwani uma ngingazi inguqulo ye SQL Server imininingo egciniwe?

Azikho izinkinga. Isofthiwe yethu yokutakula ye-MDF izokutholela ngokuzenzakalela inguqulo, ngaphambi kokuthitarts ukulungisa isizindalwazi esonakele.

Ungakwazi yini ukukhipha idatha etholiwe njengamafayela e-CSV?

Uxolo kodwa okwamanje isofthiwe yethu yokutakula ye-MDF ye-SQL ayisekeli ukwenza njalo. Kodwa ungakwazi ukukhipha ithebula lakho kumafayela e-CSV SQL Server I-Management Studio ngqo.

Ngingasebenzisa isikhathi esingakanani inguqulo egcwele?

Ilayisensi yenguqulo egcwele ingunaphakade. Ungayisebenzisa kuze kube phakade futhi izikhathi ezingenamkhawulo.

Iyini imiphumela yenkohlakalo yedathabhesi ye-SQL?

Kuningi:

  1. Ukulahleka kwedatha.
  2. Ukusebenza kuyehlisa.
  3. Eminye imisebenzi ingase yehluleke. Okufana nokwenza isipele, ukuphindaphinda, njll.

Ungayithola kanjani inkohlakalo yefayela le-MDF?

Uma uhlangabezana nanoma yiziphi izinkinga ku uhlu, bese ifayela lakho le-MDF lonakele. Ngaphezu kwalokho, ungasebenzisa umyalo olandelayo ukuthola ukonakala kwefayela le-MDF:

KHETHA * KUSUKA ku-msdb..suspect_pages LAPHO (event_type = 1);

Izinhlobo ezehlukene zemicimbi zihambisana namaphutha ahlukene, njengoba ngezansi:

Uhlobo lomcimbi Iphutha
1 823 noma 824 iphutha
2 I-checksum embi
3 Ikhasi elidabukile

Qaphela umyalo ongenhla ungathola kuphela ukonakala okuncane kumafayela e-MDF.

Ungakwazi yini ukuthola amafayela e-MDF ahlaselwe yi-Ransomware?

I-Ransomware iwuhlobo lohlelo olungayilungele ikhompuyutha. Izobethela amafayela akho esizindalwazi se-MDF. Udinga ukukhokhela umdali we-Ransomware ukuze asuse ukubethela kusizindalwazi sakho futhi uthole idatha yakho.

Ngenhlanhla, isofthiwe yethu yokutakula isizindalwazi se-SQL ingabuyisa idatha kumafayela e-MDF angenwe yi-Ransomware.

Imibhalo eminingi ku-Knowledgebase