Ngoba DataNumen SQL Recovery?


#1 Ireyithi yoBuyiselo

Ukubuyisela kwakhona # 1
izinga

I-10+ yezigidi zabasebenzisi

I-10 + yezigidi
abasebenzisi

Iminyaka eli-20 + yamava

I-20 + iminyaka ye
amava

Isiqinisekiso sokwaneliseka kwe-100%

I-100% Ukoneliseka
Isiqinisekiso

Ukufumana kwakhona ngaphezulu kwabaKhuphiswano bethu


DataNumen SQL Recovery vs. DBCC Khangela iDB kunye neTableTable, iBhokisi yeZixhobo yoBuyiselo ye SQL Server, Ukulungiswa kweStellar kwi-MS SQL, njl.

Umyinge weRhafu yokuBuyisa

Itshathi yokuthelekisa

Funda ngakumbi malunga nendlela DataNumen SQL Recovery uyatshaya ukhuphiswano

Ubungqina babathengi bethu

Unxibelelwano olulula kakhulu


Isisombululo sokulandela iimpazamo eziqhelekileyo kunye neengxaki kwi SQL Server Ifayile Yesiseko Sedatha


izisombululo

KANINZI


Ukukhuphela mahalaIminyaka engama-20+ yamava
Thenga ngokuIsiqinisekiso sokwaneliseka kwe-100%

Iimpawu eziphambili



Ukukhuphela mahalaIminyaka engama-20+ yamava
Thenga ngokuIsiqinisekiso sokwaneliseka kwe-100%

Phinda Wonakele SQL Server Oovimba beenkcukacha nge DataNumen SQL Recovery


Qalisa DataNumen SQL Recovery.

DataNumen SQL Recovery 7.0

Qaphela: Vala ezinye ii-apps ezinokuguqula ifayile ye-MDF phambi kokuba utshintshetart.

Khetha ifayile ongathanda ukuyilungisa, ngokungenisa igama lefayile ye MDF okanye ukucofa i Khangela incwadi iqhosha. Kwakhona, ungasebenzisa i fumana iqhosha ukuyikhangela.

Khetha Ifayile enguMthombo

Kwimeko apho kukho iifayile ze-NDF enye okanye ezininzi ezinxulumene nefayile ye-MDF eyonakeleyo, yongeze nazo:

Khetha Umthombo weFayile ye-NDF

Chaza ifomathi yefayile yesiseko sedatha ukuba uyayazi:
Khetha iFomathi yeMthombo

Ukuba awuyikhankanyi ifomathi, ngoko DataNumen SQL Recovery izakuzama ukuhlalutya ifayile yemvelaphi ukubona ifomathi.

Ngokuzenzekela, DataNumen SQL Recovery izakugcina idata efunyenweyo kwifayile entsha xxxx_fixed.mdf. xxx imele igama lefayile yemvelaphi. Ngoko ke, ukuba ifayile yemvelaphi ibiyiMySQLDB.mdf, ifayile efunyenweyo iya kuba yiMySQLDB_fixed.mdf. Unokuyiqamba kwakhona:

Khetha iFayile yeNdawo

Ungangenisa igama ngokuthe ngqo. Okanye, betha i Khangela incwadi iqhosha lokuyicwangcisa. Qinisekisa ukuba kukho indawo eyaneleyo kwidisk yayo. Ungaqikelela indawo efunekayo ngokusekelwe kubungakanani befayile yemvelaphi.

nqakraza i Start Ukubuyisela kwakhona iqhosha kwaye DataNumen SQL Recovery izakwenza i "Qhagamshela kwi SQL Server" ibhokisi yencoko yababini, njengoko ifuna ukudibanisa kwi SQL Server umzekelo ukwenza ukubuyisela:

Qhagamshela SQL Server Ibhokisi yencoko

Hlela Igama lomSeva kwaye Ukuqinisekiswa ukwenzela i SQL Server umzekelo kwikhompyuter yasekhaya okanye ekude. Emva koko, cofa i "CALUNGA" iqhosha. Isoftware yethu yokubuyisela i-MDF iya kuzama ukufumanisa ukudityaniswa kwesiseko sedatha, kwaye emva koko usete ukuhlanganiswa kwedatha yendawo yokusingwa ngokufanelekileyo. Ukuba ayikwazi ukubona ukudibanisa, iya kukucela ukuba uyisete. Emva koko iya kukhangela yonke i-database, ilungise ifayile ye-MDF, kwaye iphinde ifumane idatha nge-algorithms ekhethekileyo.

Ibar ibonisa inkqubela yenkqubo yokubuyisela idatha:

Inkqubela yeBar

Nje ukuba inkqubo igqityiwe, uya kubona isaziso esinje ukuba bekunokwenzeka ukubuyisela ifayile yeMDF yoqobo:

Ibhokisi yoMyalezo weMpumelelo

Start Microsoft SQL Server Isitudiyo soLawulo ukufikelela ekufumaneni kwakhona SQL Server indawo yedatha.

Iinkcukacha ezithe xaxe


Ndingayifumana phi idata efunyenweyo?

Idatha efunyenweyo ikhutshwa kwisiseko sedatha entsha kwi SQL Server umzekelo oqhagamshela kuwo xa starting inkqubo yokubuyisela ye-SQL MDF.

Igama lefayile ye MDF yedatabase yemveliso ichaziwe phambi kokuba u start ukuchacha.

Ngokuqhelekileyo, awudingi ukufikelela kwi-SQL database yefayile ye-MDF ngokuthe ngqo. Emva kwenkqubo yokubuyisela, ukufikelela kwidatha efunyenweyo, nceda wenze ngolu hlobo lulandelayo:

  1. Start SQL Server Isitudiyo soLawulo.
  2. Qhagamshela kwi SQL Server umzekelo ofanayo nalowo ubuwusebenzisile ukubuyisela isiseko sakho sedatha esonakeleyo.
  3. Emva koqhagamshelo, cofa umzekelo.
  4. Bese uchofoze neeDathabheyisi indawo yokusebenzela.
  5. Emva koko uya kufumana enye okanye ezinye i-database ebizwa ngokuthi "Database_Recovered_On_yyy_mm_dd_hh_mm_ss_#", apho yyyy, mm, dd, hh, mm, ss lixesha apho i-database yenziwe, oko kukuthi, unyaka, inyanga, usuku, iyure, umzuzu kunye nesibini. Kwaye # linani lolandelelwano u-starting ukusuka 1. Olu lwazi lunokukunceda ngokulula ukuchonga isiseko sedatha esivela kwinkqubo yokubuyisela yamva nje.
  6. Cofa indawo yogcino lwedatha oyichongayo. Ungafikelela kuzo zonke izinto ezifunyenweyo zesiseko sedata seSQL. Umzekelo, ngaphantsi Tables indawo, unokubona zonke iitafile zesiseko sedata ezifunyenweyo, kubandakanya i-schemas kunye neerekhodi.

Indlela yokunciphisa ilahleko yedatha ngexesha SQL Server intlekele data?

Kuyacetyiswa ukuba ulungiselele isicwangciso sokubuyisela intlekele (DR) sakho SQL Server umzekelo, ngokuqhelekileyo kubandakanya:

  1. Gcina i-backup yakho rhoqo SQL Server idatha.
  2. Yiba isixhobo SQL recovery professional ezifana DataNumen SQL Recovery ngesandla. Ngaloo ndlela xa udibana urhwaphilizo lwedatha ye-SQL, ungayisebenzisa ukulungisa iifayile ezonakeleyo kwaye ufumane idatha yakho ngokukhawuleza.
  3. Sebenzisa iimpawu zokufumaneka okuphezulu kwi SQL Server.

Ziziphi izinto eziluncedo kwimveliso yakho ngaphezu kwezinye izixhobo MS SQL Database recovery?

Ungafumana epheleleyo uthelekiso lokhuphiswano yemveliso yethu kunye nezinye izixhobo ze-MS SQL zokufumana kwakhona kwimarike.

Ngaba ndinganqumama/ ndiqalise kwakhona inkqubo yokulungisa isiseko sedatha yeSQL?

Ayinakwenzeka loo nto. Ukuba inkqubo yokulungisa iye started, emva koko ungayilahla okanye uyiyeke igqibezele. Kamva ukuba ufuna ukulungisa kwakhona ifayile yesiseko sedatha yeSQL efanayo, ngoko kufuneka uphinde u-start inkqubo yokulungisa ukusuka ekuqaleni.

Nangona kunjalo, ngexesha lenkqubo yokulungisa, unokubona idatha efunyenweyo SQL Server istudiyo solawulo ngaxeshanye. Ukuba ucinga ukuba yonke idatha efunwayo ifunyenwe, ngoko unokulandula inkqubo yokulungisa ukugcina ixesha lakho, ngaphandle kokonakalisa isiseko sedatha yemveliso.

Ndinefayile ye SQL MDF kuphela, ilog yetransekshini (LDF) ifayile yi lost. Kwenziwe ntoni?

DataNumen SQL Recovery inokubuyisela idatha yakho kwifayile ye-MDF eyonakeleyo ngaphandle kwe ifayile yetransaction log (LDF). Ke ukuba ifayile yakho yentengiselwano yelog yi lost, oko akuyi kuba yingxaki.

Ngaba uyakuxhasa ukubuyisela irekhodi yedatha ngohlobo lwe-XML?

Ewe, isoftware yethu yokubuyisela isiseko sedatha yeSQL ixhasa ukubuyisela iirekhodi kuzo zombini iindidi zedatha ye-ASCII kunye ne-Unicode XML.

Ngaba kufuneka ndibe ngumlawuli wedatha (DBA) ukwenza ukubuyisela kwakhona?

Ewe, kufuneka ube yinyani umlawuli wesiseko sedatha (DBA), okanye ufumane le ngcaciso ilandelayo kumlawuli wedatha (DBA):

  1. SQL Server igama lomzekelo(Igama leseva)
  2. Uqinisekiso lwe SQL Server Umzekelo.

Ngaloo ndlela ungasebenzisa olu lwazi ukuqhagamshela kwi SQL Server umzekelo kwaye wenze ukubuyisela.

Ngaba iMicrosoft SQL Server unesixhobo esakhelwe-ngaphakathi sokubuyisela isiseko sedatha esonakeleyo?

Ewe, banayo imiyalelo eyakhelwe-ngaphakathi ye-dbcc, okt. I-dbcc checkdb kunye ne-dbcc yokukhangela itafile, enokukhangela i-schemas zetafile kunye neerekhodi, emva koko ulungise imiba encinci kwisiseko sakho sedatha eyonakeleyo okanye iitafile zedatha. Nangona kunjalo, ezi zixhobo zisebenza kuphela kwinani elincinci lamatyala. Ukuba abakwazi ukulungisa inkohlakalo yefayile ye-MDF, kungcono uzame DataNumen SQL Recovery, esebenza ngcono ngakumbi.

Olunye usetyenziso olusisiseko lwe-dbcc checkdb zidweliswe ngezantsi:

umyalelo ukusetyenziswa
dbcc checkdb('MyDB.mdf') Khangela ukuba iMyDB.mdf inayo nayiphi na imiba.
dbcc checkdb('MyDB.mdf', REPAIR_ALLOW_DATA_LOSS) Jonga iMyDB.mdf. Ukuba kukho nayiphi na imiba, lungisa ifayile yedatha ye-MDF, enokubangela ukulahleka kwedatha.
dbcc checkdb('MyDB.mdf', REPAIR_REBUILD) Jonga iMyDB.mdf. Ukuba kukho nayiphi na imiba, lungisa ifayile yedatha ye-MDF, eya kuthi NOT kubangele ilahleko yedatha, kodwa kungathatha ixesha elingakumbi.

Olunye usetyenziso olusisiseko lwe-dbcc yokutshekisha zidweliswe ngezantsi:

umyalelo ukusetyenziswa
dbcc checktable('MyDB.MyTable') Jonga ukuba iMyTable kwiMyDB inayo nayiphi na imiba.
dbcc checktable('MyDB.MyTable', REPAIR_ALLOW_DATA_LOSS) Jonga iMyTable kwiMyDB. Ukuba kukho nayiphi na imiba, lungisa itafile, enokubangela ukulahleka kwedatha.
i-dbcc checktable('MyDB.MyTable', REPAIR_REBUILD) Jonga iMyTable kwiMyDB. Ukuba kukho nayiphi na imiba, lungisa itafile, eya kuthi NOT kubangele ilahleko yedatha, kodwa kungathatha ixesha elingakumbi.

Singakanani isithuba sedisk endisidingayo ukulungiselela uvimba wedata wemveliso?

Okokuqala, kufuneka ubale ubungakanani obupheleleyo bedatha yomthombo, kubandakanywa ifayile ye-MDF yedatha ye-SQL kunye nazo zonke iifayile ze-NDF ezinxulumene nazo. Kucingelwa ukuba yi-SDataSize.

Emva koko, ngokusekelwe kwi-SDataSize, kufuneka ulungiselele ubuncinane i-2 * (SDataSize * 110%) kwisiseko sedatha yokuphuma kwindawo yakho oyifunayo, kubandakanywa zombini ifayile ye-SQL MDF kunye nefayile ye-LDF.

Kutheni my SQL Server idatabase yonakele?

Kukho izizathu ezininzi ezinokubangela ukonakala kwesiseko sedatha yeSQL, kubandakanya:

  1. Izizathu ze-Hardware: ezifana nokusilela kwamandla, amacandelo amabi kwiidiski, ukungaphumeleli kwediski enzima, ukuvala inkqubo engalindelekanga, njl.
  2. Izizathu zeSoftware: ezifana neziphene zesoftware, usulelo lwentsholongwane, uhlaselo lweransomware, ukusilela kogcino, iheader yefayile yedata engasebenziyo, njl.

DataNumen SQL Recovery iyakwazi ukubuyisela idatha yazo zonke iimeko ezingentla.

Yeyiphi ifomathi yeefayile ezifunyenweyo?

DataNumen SQL Recovery izakuqhagamshela kwi SQL Server umzekelo kwaye uyisebenzise ukuvelisa idatabase efunyenweyo. Ngoko ke ifomathi yeefayile ezifunyenweyo iyafana ne SQL Server inguqulelo yomzekelo oqhagamsheleka kuwo xa usenza ubuyiselo. Umzekelo, ukuba uqhagamshela kwi SQL Server Umzekelo we-2000, emva koko idatabase yemveliso nayo iya kuba phakathi SQL Server 2000 ifomathi.

Zeziphi iinguqulelo ze SQL server ziyaxhaswa?

DataNumen SQL Recovery inkxaso yokubuyisela ugcino lweenkcukacha ze-SQL ezenziwe ngezi nguqulelo zilandelayo ze-MS SQL Server: SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.

Inokuqhagamshela kwiinguqulelo ezilandelayo ze SQL Server iimeko zokuvelisa isiseko sedatha esisigxina: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019. Iziko ledatha elisisigxina liya kugcinwa kwinguqulelo efanayo naleyo SQL Server Umzekelo.

Ngaba unokukhupha idatabase efunyenweyo njengeskripthi seSQL?

Iinguqulelo zangaphambili ze DataNumen SQL Recovery xhasa into enjalo. Nangona kunjalo, silisusile eli nqaku kwiinguqulelo zamva nje.

Ngaba uyakuxhasa ukubuyisela izalathisi kunye nezinye izinto?

Ewe, izalathisi, izitshixo eziphambili, iimboniselo, izichukumisi, imithetho, ukungagqibeki, iinkqubo ezigciniweyo, kunye nezinye izinto zixhaswa.

Ndiyasilela ukubuyisela isiseko sedatha yeSQL ngesixhobo sakho sokubuyisela ifayile. Ndicela uncedo.

Ndiyacela Qhagamshelana nathi kwaye unikeze ilog yokubuyisela. Ungafumana iinkcukacha ezithe vetshe kwi indlela yokufumana ilog yokubuyisela.

Ngamanye amaxesha, ngenxa yentlekele yedatha, ifayile ye-MDF kunye neefayile ze-NDF zingenakho i-data ye-SQL yangempela. Kodwa idiski okanye idrayivu apho ugcine khona i MDF okanye iifayile ze NDF zisenokuqulatha idatha enokufunyanwa. Unga buyisa idatha yakho kwidiski okanye uqhube ngqo.

Ndingagcina idatabase efunyenweyo kwiifayile ezininzi zedatha?

Uxolo kodwa okwangoku isixhobo sethu sokubuyisela isiseko sedatha esikhohlakeleyo seSQL asixhasi ukugcina idatabase efunyenweyo kwiifayile ezininzi zedatha, okt, ifayile yedatha esisiseko (MDF) kunye neefayile zedatha yesibini (NDF).

Nangona kunjalo, emva kokuba inkqubo yokubuyisela i-SQL MDF igqityiwe, unokwenza oku kulandelayo ukuphumeza injongo yakho:

  1. Start SQL Server istudiyo solawulo.
  2. Yenza i-database entsha kwaye Yila iifayile kunye namaqela efayile ngokusekelwe kwiimfuno zakho, ezifana nokusasazwa kwedatha kwiifayile ezininzi.
  3. Clone database efunyenweyo ukusuka kwisiseko sedatha efunyenweyo kwisiseko sedatha esitsha esenziwe kwinyathelo lesi-2. Kungenjalo, ungathumela ngaphandle isiseko sedatha efunyenweyo njengeskripthi seSQL, kwaye emva koko ungenise umbhalo kwisiseko sedatha entsha.

Yeyiphi imida yenguqulelo yedemo?

Uguqulelo lwedemo lusebenzisa i-injini yokubuyisela idatha njengenguqu epheleleyo, ngaphandle kokuba iya kufaka imibhalo yedemo kwezinye iindawo kwisiseko sedatha efunyenweyo.

Ngaba unokuphinda ufumane iskimu setafile kuphela?

Isoftware yethu yokubuyisela idatabase yeSQL iya kubuyisela yonke idatabase, kuquka iitafile kunye nazo zonke ezinye izinto. Kwiitheyibhile, zombini i-schema yetafile kunye nedatha yerekhodi yetafile iya kufunyanwa kwakhona. Akukwazeki ukuba kubuyiselwe i-schema setafile kuphela.

Zeziphi iinguqulelo zeWindows ezixhaswayo?

Okwangoku, iWindows 95/98/ME/NT/2000/XP/Vista/7/8/8.1/10/11 kunye ne-Windows Server 2003/2008/2012/2016/2019 iinkqubo zokusebenza zixhaswa. Kwakhona, zombini iinkqubo ze-32bit kunye ne-64bit zixhaswa.

Ngaba unokukhupha isiseko sedatha njengeMDF enye kunye neefayile ezininzi ze-NDF?

Uxolo kodwa ngoku sixhasa kuphela ukukhutshwa kwefayile enye yeSQL MDF.

Isixhobo sakho sokubuyisela ifayile sibonisa impazamo xa ufumana kwakhona isalathisi. Indlela yokusombulula ingxaki?

Ezinye izalathisi zinemiqobo ekhethekileyo, efana neyodwa, ngelixa idatha efunyenweyo isenokungahlangani nale miqobo. Emva kwenkqubo yokubuyisela i-SQL MDF, unokwenza oku kulandelayo ukusombulula umba:

  1. Susa idatha engafunekiyo ukuqinisekisa ukuba idatha eseleyo iyahlangabezana nemiqobo. Emva koko wakha kwakhona isalathisi ngesandla.

or

2. Susa ezinye izithintelo kwisalathiso kwaye uyakhe kwakhona ngesandla.

Unokwenza zombini u-1 no-2 ngezikripthi zeSQL.

Ndinefayile ye-MDF eyonakeleyo kuphela. Iifayile ze-NDF ezinxulumeneyo azikho. Ngaba unokufumana kwakhona idatha?

Ewe, nokuba unayo kuphela ifayile yesiseko sesiseko, isoftware yethu yokubuyisela iMDF isenokuyifumanela idatha. Nangona kunjalo, kuphela ezo zikwifayile ye-MDF ezinokufunyanwa. Ezo zikwiifayile ze-NDF zingaphaya kokubuyiselwa kuba awunazo iifayile ze-NDF.

Ngaba ungazibuyisela izinto ezifihliweyo?

Ewe singakwazi. Kwaye izinto ezifihliweyo, njengeenkqubo ezigciniweyo, ziya kufunyanwa kwaye zigcinwe njengeenguqulelo ezifihliweyo.

Ngaba unokuzifumana iirekhodi ezicinyiweyo?

Ewe, ngokuzenzekelayo, isixhobo sethu sokubuyisela iifayile siya kuphinda sibuyise iirekhodi ezicinyiweyo. Unokutshintsha kwakhona ukhetho, ngolu hlobo lulandelayo:

  1. Start isixhobo sethu sokubuyisela iSQL MDF.
  2. Cofa ithebhu ethi "Options".
  3. Khangela / Susa ukukhangela "Buyisa iirekhodi ezicinyiweyo" ngokufanelekileyo.
  4. Lungisa iifayile zeMDF.

Kuthekani ukuba andiyazi inguqulelo ye SQL Server uvimba weenkcukacha?

Akukho maxhala. Isoftware yethu yokubuyisela i-MDF iya kuzifumanela ngokuzenzekelayo uguqulelo, ngaphambi kokuba starts ukulungisa oovimba beenkcukacha ezonakeleyo.

Ngaba ungakhupha idatha efunyenweyo njengefayile zeCSV?

Uxolo kodwa okwangoku i-SQL yethu yedatha ye-MDF yesoftware yokubuyisela ayikuxhasi ukwenza njalo. Kodwa ungayithumela ngaphandle itafile yakho kwi.CSV iifayile ngaphakathi SQL Server Isitudiyo soLawulo ngqo.

Ndingayisebenzisa ixesha elingakanani uguqulelo olupheleleyo?

Iphepha-mvume loguqulelo olupheleleyo lihlala lihleli. Ungayisebenzisa ngonaphakade kwaye ngamaxesha angenamkhawulo.

Ziziphi iziphumo zorhwaphilizo lwesiseko sedatha yeSQL?

Zininzi:

  1. Ilahleko yedatha.
  2. Ukusebenza kuyehla.
  3. Eminye imisebenzi inokusilela. Njengokugcina, ukuphindaphinda, njl.

Indlela yokubona ukonakala kwefayile ye-MDF?

Ukuba ufumana nayiphi na ingxaki kwi uludwe, ke ifayile yakho ye MDF yonakele. Ngapha koko, unokusebenzisa lo myalelo ulandelayo ukubona ukonakala kwefayile ye-MDF:

KHETHA * UKUSUKA msdb..suspect_pages APHO (event_type = 1);

Iindidi zeziganeko ezahlukeneyo zihambelana neempazamo ezahlukeneyo, njengoko kungezantsi:

Uhlobo lomsitho imposiso
1 823 okanye 824 impazamo
2 Itshekhisum embi
3 Iphepha elikrazukileyo

Qaphela lo myalelo ungasentla unokubona kuphela ukonakala okuncinci kwiifayile ze-MDF.

Ngaba unokuzifumana kwakhona iifayile zeMDF ezihlaselwe yiRansomware?

I-Ransomware luhlobo lwe-malware. Iza kufihla iifayile zakho zedatha yeMDF. Kufuneka uhlawule umdali weRansomware ukuze uguqule i-database yakho kwaye ubuyisele idatha yakho.

Ngethamsanqa, isoftware yethu yokubuyisela idatabase yeSQL inokubuyisela idatha kwiifayile zeMDF ezosulelwe yiRansomware.

Amanqaku angakumbi kwi-Knowledgebase