Sei DataNumen SQL Recovery?


#1 Recovery Rate

# 1 Kudzorera
mutengo

10+ Mamirioni Vashandisi

Miriyoni mazana matatu nemakumi matatu
Users

20+ Makore Ekuziva

20 + Makore
ruzivo

100% Kugutsikana Guarantee

100% Kugutsikana
Chivimbiso

Tora Zvakawanda Kupfuura Vakwikwidzi Vedu


DataNumen SQL Recovery vs. DBCC CheckDB & CheckTable, Recovery Toolbox ye SQL Server, Stellar Kugadziriswa KweMS SQL, nezvimwe.

Avhareji Yekudzoreredza Rate

kuenzanisa Chart

Dzidza zvakawanda nezvekuti sei DataNumen SQL Recovery anosvuta makwikwi

Vedu Vatengi 'Uchapupu

Yakanyanya Nyore interface


Mhinduro yekutevera Zvakajairwa Zvikanganiso uye Matambudziko mu SQL Server Dhatabhesi Faira


zvingaitwa

ZVIMWE


Free Download20+ Makore Echiitiko
Tenga izvozvi100% Kugutsikana Guarantee

Zvinhu Zvikuru



Free Download20+ Makore Echiitiko
Tenga izvozvi100% Kugutsikana Guarantee

Dzorera Zvakakuvadzwa SQL Server Databases with DataNumen SQL Recovery


Tanga DataNumen SQL Recovery.

DataNumen SQL Recovery 7.0

Attention: Dzima mamwe maapplication anogona kushandura iyo MDF faira usati waitatart.

Sarudza faira raunoda kugadzirisa, nekuisa iyo MDF faira zita kana kudzvanya iyo Browse bhatani. Uyezve, unogona kushandisa wana bhatani kuzvitsvaga.

Sarudza Source File

Kana paine imwe kana akawanda mafaera eNDF ane hukama neyakakuvadzwa MDF faira, wedzera iwowo:

Sarudza Source NDF File

Taura chimiro cheiyo source database faira kana uchizviziva:
Sarudza Source Format

Kana iwe usingataure chimiro, saka DataNumen SQL Recovery achaedza kuongorora iyo faira faira kuti aone iyo fomati.

By default, DataNumen SQL Recovery ichachengetedza data rakadzoserwa mufaira idzva xxxx_fixed.mdf. xxx inomiririra zita refaira rekwakabva. Saka, kana faira rekwakabva riri MySQLDB.mdf, faira rakadzoserwa raizova MySQLDB_fixed.mdf. Iwe unogona zvakare kuitumidza zita:

Sarudza Kwekuenda Faira

Iwe unogona kuisa zita racho zvakananga. Kana, rova ​​​​iyo Browse bhatani kuti riise. Ita shuwa kuti pane yakakwana disk nzvimbo yayo. Iwe unogona kufungidzira nzvimbo inodiwa zvichienderana nehukuru hweiyo faira faira.

Baya Start Kupora bhatani uye DataNumen SQL Recovery ichaita kuti "Batanidza ku SQL Server" dialog box, sezvo inoda kubatana nea SQL Server muenzaniso wekuita kudzoreredza:

Batanidza kune SQL Server Bhokisi Rekukurukurirana

Isai Zita reSeva uye Authentication nokuti SQL Server muenzaniso pakombuta yemuno kana iri kure. Zvadaro, tinya pa "APPROX" bhatani. Yedu MDF yekudzoreredza software inoedza kuona kuunganidzwa kweiyo sosi dhatabhesi, uye wobva waisa iyo yekuenda dhatabhesi collation zvinoenderana. Kana isingakwanisi kuona kubatanidzwa, ichakukumbira kuti uise. Ipapo ichaongorora dhatabhesi rese, kugadzirisa iyo MDF faira, uye kudzoreredza data neakakosha algorithms.

Iyo bar inoratidza kufambira mberi kweiyo data yekudzoreredza maitiro:

Kufambira Mberi

Kana maitiro apera, uchaona chiziviso chakadai kana zvaikwanisika kudzoreredza iyo yekutanga MDF faira:

Kubudirira Bhokisi reMharidzo

Start Microsoft SQL Server Management Studio kuti uwane iyo yakadzoserwa SQL Server dhatabhesi.

More Information


Ndingawane kupi data rakadzoserwa?

Iyo data yakadzoserwa inoburitswa kune nyowani dhatabhesi mu SQL Server muenzaniso waunobatanidza apo startarisa iyo SQL MDF yekudzoreredza maitiro.

Iyo MDF faira zita rezvabuda dhatabhesi rinotsanangurwa usati waita start kupora.

Kazhinji, haufanire kuwana iyo SQL database MDF faira zvakananga. Mushure mekuita kudzoreredza, kuti uwane iyo data yakadzoserwa, ndapota ita zvinotevera:

  1. Start SQL Server Management Studio.
  2. Batanidza kune iyo SQL Server muenzaniso wakafanana newawakashandisa kudzoreredza dhatabhesi rako rine huori.
  3. Mushure mekubatanidza, tinya muenzaniso.
  4. Zvadaro penya Databases node.
  5. Ipapo iwe unowana imwe kana mamwe dhatabhesi anonzi "Database_Recovered_On_yyy_mm_dd_hh_mm_ss_#", uko yyyy, mm, dd, hh, mm, ss ndiyo nguva iyo dhatabhesi inogadzirwa, kureva, gore, mwedzi, zuva, awa, miniti uye yechipiri. Uye # inhamba yekutevedzana starting kubva ku1. Ruzivo urwu runogona kukubatsira nyore kuona dhatabhesi inogadzirwa kubva pazvino kudzoreredza maitiro.
  6. Dzvanya iyo node yedatabase yaunozivisa. Iwe unogona ipapo kuwana zvese zvakadzoserwa SQL database zvinhu. Somuenzaniso, pasi matafura node, unogona kuona ese akadzoserwa tafura yematafura, kusanganisira schemas uye marekodhi.

Maitiro ekudzikisa kurasikirwa kwedata panguva ye SQL Server data njodzi?

Zvinokurudzirwa kugadzirira chirongwa chekudzorera njodzi (DR) chako SQL Server semuenzaniso, izvo zvinowanzobatanidza:

  1. Gara uchichengetedza yako SQL Server date.
  2. Iva nehunyanzvi SQL kudzoreredza chishandiso senge DataNumen SQL Recovery paruoko. Saka paunosangana neSQL database huwori, unogona kuishandisa kugadzirisa huwori mafaera uye kudzoreredza data rako nekukurumidza.
  3. Shandisa iyo yepamusoro inowanikwa maficha mukati SQL Server.

Ndeapi mabhenefiti echigadzirwa chako pane mamwe maMS SQL database yekudzoreredza maturusi?

Unogona kuwana yakakwana kuenzanisa kwemakwikwi yechigadzirwa chedu nemamwe maMS SQL database yekudzoreredza maturusi mumusika.

Ndinogona kumbomira / kutangazve iyo SQL database yekugadzirisa maitiro?

Izvozvo hazviiti. Kana nzira yekugadzirisa yave started, ipapo unogona kuibvisa kana kuiregedza kuti ipedze. Gare gare kana iwe uchida kugadzirisa zvakare iyo yakafanana SQL dhatabhesi faira, saka iwe unofanirwa kudzoreratart nzira yekugadzirisa kubva pakutanga.

Nekudaro, panguva yekugadzirisa, iwe unogona kuona iyo yakadzoserwa data mukati SQL Server manejimendi studio panguva imwe chete. Kana iwe uchifunga kuti data rese rinodiwa radzoserwa, saka unogona kubvisa maitiro ekugadzirisa kuchengetedza nguva yako, pasina kukuvadza dhatabhesi rekubuda.

Ini chete ndine SQL MDF faira, iyo transaction log (LDF) faira ndeye lost. Kuita sei?

DataNumen SQL Recovery inogona kudzoreredza data rako kubva kune yakaora MDF faira pasina iyo transaction log (LDF) faira. Saka kana yako yekutengeserana faira faira iri lost, izvo hazvizove dambudziko.

Iwe unotsigira kudzoreredza data rekodhi muXML mhando?

Ehe, yedu SQL dhatabhesi yekudzoreredza software inotsigira kudzoreredza marekodhi mune ese ASCII uye Unicode XML data mhando.

Ini ndinoda kuve maneja wedhatabhesi (DBA) kuti ndiite kudzoreredza?

Ehe, iwe unofanirwa kuve uri dhatabhesi maneja (DBA), kana kuti uwane ruzivo rwunotevera kubva kune dhatabhesi maneja (DBA):

  1. SQL Server zita remuenzaniso(Zita reServer)
  2. Kusimbiswa kwe SQL Server muenzaniso.

Saka iwe unogona kushandisa ruzivo urwu kubatanidza kune iyo SQL Server muenzaniso uye kuita kupora.

Inoita Microsoft SQL Server ine chishandiso chakavakirwa-mukati chekudzorera dhatabhesi ine uori?

Hongu, ivo vane yakavakirwa-mukati dbcc mirairo, kureva, dbcc checkdb uye dbcc checktable, iyo inogona kutarisa tafura schemas uye marekodhi, wobva wagadzirisa zvidiki zvidiki mudhatabhesi rako rakashata kana matafura edhatabhesi. Nekudaro, maturusi aya anoshanda chete kune mashoma mashoma emakesi. Kana vasingakwanise kugadzirisa MDF faira yehuori, saka zviri nani kuedza DataNumen SQL Recovery, iyo inoshanda zvakanyanya zvirinani.

Mamwe ekutanga mashandisirwo edbcc checkdb akanyorwa pazasi:

murayiro Usage
dbcc checkdb('MyDB.mdf') Tarisa kana MyDB.mdf iine nyaya.
dbcc checkdb('MyDB.mdf', REPAIR_ALLOW_DATA_LOSS) Tarisa MyDB.mdf. Kana paine nyaya, gadzirisa MDF dhatabhesi faira, izvo zvinogona kukonzera kurasikirwa kwedata.
dbcc checkdb('MyDB.mdf', REPAIR_REBUILD) Tarisa MyDB.mdf. Kana paine nyaya, gadzirisa MDF dhatabhesi faira, iyo ichaita NOT kukonzera kurasikirwa kwedata, asi zvinogona kutora nguva yakawanda.

Mamwe ekutanga mashandisirwo edbcc checktable akanyorwa pazasi:

murayiro Usage
dbcc checktable ('MyDB.MyTable') Tarisa kana MyTable muMyDB ine chero nyaya.
dbcc checktable('MyDB.MyTable', REPAIR_ALLOW_DATA_LOSS) Tarisa MyTable muMyDB. Kana paine nyaya, gadzirisa tafura, izvo zvinogona kukonzera kurasikirwa kwedata.
dbcc checktable('MyDB.MyTable', REPAIR_REBUILD) Tarisa MyTable muMyDB. Kana pane nyaya, gadzirisa tafura, izvo zvichaita NOT kukonzera kurasikirwa kwedata, asi zvinogona kutora nguva yakawanda.

Yakawanda sei dhisiki nzvimbo yandinoda kugadzirira iyo inobuda dhatabhesi?

Kutanga, iwe unofanirwa kuverenga huwandu hwese hweiyo sosi data, kusanganisira iyo SQL dhatabhesi MDF faira uye ese akabatana NDF mafaera. Tichifunga kuti ndiyo SDataSize.

Zvadaro, zvichibva paSDataSize, iwe unofanirwa kugadzirira kanenge 2 * (SDataSize * 110%) yedhatabhesi rekubuda panzvimbo yaunoda, kusanganisira zvese SQL MDF faira uye LDF faira.

Sei yangu SQL Server Database rinoita huori?

Pane zvikonzero zvakawanda zvinogona kukonzera huwori hwe database yeSQL, kusanganisira:

  1. Zvikonzero zve Hardware: sekutadza kwesimba, zvikamu zvakaipa pamadhisiki, kutadza kwedhisiki yakaoma, kuvharika kwehurongwa husingatarisirwi, nezvimwe.
  2. Zvikonzero zveSoftware: sekukanganisa kwesoftware, hutachiona hwehutachiona, kurwiswa kweransomware, kutadza kuchengetedza, musoro wefaira re database, nezvimwe.

DataNumen SQL Recovery inokwanisa kudzoreredza data kune ese ari pamusoro.

Ndeipi fomati yemafaira akadzoserwa?

DataNumen SQL Recovery ichabatana ne SQL Server muenzaniso uye shandisa iyo kugadzira iyo yakadzoserwa dhatabhesi. Saka mafomati emafaira akadzoserwa akafanana neayo SQL Server vhezheni yemuenzaniso waunosangana nawo paunenge uchigadzirisa. Semuenzaniso, kana iwe uchibatana ne SQL Server 2000 muenzaniso, ipapo dhatabhesi rekubuda richavewo mukati SQL Server 2000 fomati.

Ndedzipi shanduro dze SQL server vanotsigirwa?

DataNumen SQL Recovery tsigiro yekudzoreredza SQL dhatabhesi yakagadzirwa neanotevera mavhezheni eMS SQL Server: SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.

Inogona kubatana neshanduro dzinotevera dze SQL Server zviitiko zvekugadzira iyo yakatarwa database: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019. Database yakagadziriswa ichachengetwa mushanduro yakafanana neyeyo SQL Server muenzaniso.

Unogona here kuburitsa dhatabhesi yakadzoserwa seSQL script?

Mavhezheni ekutanga e DataNumen SQL Recovery tsigira chinhu chakadaro. Zvakadaro, takabvisa chimiro ichi mushanduro dzichangoburwa.

Iwe unotsigira kudzoreredza indexes nezvimwe zvinhu?

Hongu, indexes, makiyi ekutanga, maonero, zvinokonzeresa, mitemo, defaults, akachengetwa maitiro, uye zvimwe zvinhu zvinotsigirwa.

Ini ndinotadza kudzoreredza SQL dhatabhesi nefaira rako rekudzoreredza chishandiso. Please help.

Ndapota taura nesu uye ipa iyo yekudzoreredza log. Unogona kuwana rumwe ruzivo pa nzira yekuwana iyo yekudzoreredza log.

Dzimwe nguva, nekuda kwenjodzi yedata, iyo MDF faira uye NDF mafaera anogona kunge asina iyo chaiyo SQL data. Asi dhisiki kana dhiraivha kwawakachengeta MDF kana NDF mafaera anogona kunge achiine data rinodzoreredzwa. Unogona dzora data rako kubva kudhisiki kana kutyaira zvakananga.

Ndinogona kuchengetedza dhatabhesi yakadzoserwa mumafaira akawanda edata?

Tine hurombo asi parizvino yedu yakaora SQL dhatabhesi yekudzoreredza chishandiso haitsigire kuchengetedza dhatabhesi rakadzoserwa mumafaira edata akawanda, kureva, faira rekutanga data (MDF) uye akati wandei echipiri data mafaera (NDF).

Nekudaro, mushure meiyo SQL MDF yekudzoreredza maitiro yapera, unogona kuita zvinotevera kuita chinangwa chako:

  1. Start SQL Server manejimendi studio.
  2. Gadzira dhatabhesi nyowani uye gadzira mafaira uye mafaira emapoka zvichibva pane zvaunoda, sekuparadzira data pamafaira akati wandei.
  3. Clone iyo database yakadzoserwa kubva kudhatabhesi yakadzoserwa kune dhatabhesi idzva rakagadzirwa mudanho 2. Neimwe nzira, unogona zvakare kutumira iyo yakadzoserwa dhatabhesi seSQL script, uye wozopinza script kumashure kune itsva database.

Ndeipi mipimo yedemo vhezheni?

Iyo demo vhezheni inoshandisa iyo yakafanana data yekudzoreredza injini seiyo yakazara vhezheni, kunze kwekuti ichaisa zvinyorwa zvedemo mune mamwe minda mune yakadzoserwa dhatabhesi.

Unogona kudzoreredza tafura schema chete?

Yedu SQL dhatabhesi yekudzoreredza software inodzoreredza dhatabhesi rese, kusanganisira matafura nezvimwe zvinhu zvese. Kune matafura, ese ari maviri tafura schema uye tafura rekodhi data ichadzoserwa. Izvo hazvigoneke kudzoreredza tafura schema chete.

Ndedzipi shanduro dzeWindows dzinotsigirwa?

Parizvino, Windows 95/98/ME/NT/2000/XP/Vista/7/8/8.1/10/11 uye Windows Server 2003/2008/2012/2016/2019 masisitimu anoshanda. Zvakare, ese ari maviri 32bit uye 64bit masisitimu anotsigirwa.

Unogona here kuburitsa dhatabhesi seMDF imwe uye akawanda NDF mafaera?

Tine urombo asi parizvino tinongotsigira kuburitsa imwechete SQL MDF faira.

Yako faira yekudzoreredza chishandiso inoratidza chikanganiso kana uchidzoreredza index. Nzira yekugadzirisa sei dambudziko?

Mamwe ma index ane zvimwe zvipingamupinyi zvakakosha, senge zvakasarudzika, nepo data rakadzoserwa rinogona kusasangana nezvipingaidzo izvi. Mushure meiyo SQL MDF yekudzoreredza maitiro, unogona kuita zvinotevera kugadzirisa nyaya:

  1. Bvisa imwe data isina basa kuti uve nechokwadi chekuti data rasara rinosangana nezvimhingamipinyi. Wobva wavaka indekisi nemaoko.

or

2. Bvisa zvimwe zvipingamupinyi mumutsara uye uzvivake zvakare nemaoko.

Iwe unogona kuita zvese 1 uye 2 neSQL zvinyorwa.

Ini chete ndine iyo MDF file yakashatiswa. Mafaira eNDF anobatanidzwa haasipo. Unogona kudzoreredza data here?

Ehe, kunyangwe iwe uchingove neyekutanga dhatabhesi faira, yedu MDF yekudzoreredza software inogona kuramba ichikutorera data. Nekudaro, izvo chete zviri muMDF faira zvinogona kudzoserwa. Avo vari muNDF mafaera havagone kupora sezvo usina mafaera eNDF.

Unogona kudzoreredza encrypted zvinhu?

Hungu, tinogona. Uye izvo zvakavharidzirwa zvinhu, senge zvakachengetwa maitiro, zvichadzoserwa uye kuchengetwa seyakadhindwa shanduro.

Unogona here kudzoreredza marekodhi akadzimwa?

Ehe, nekusarudzika, yedu yekudzoreredza faira chishandiso inodzoreredza marekodhi akadzimwa. Iwe unogona zvakare kuchinja sarudzo, sezvinotevera:

  1. Start yedu SQL MDF yekudzoreredza chishandiso.
  2. Dzvanya "Options" tab.
  3. Tarisa / Uncheck iyo "Dzora dzadzimwa marekodhi" sarudzo zvinoenderana.
  4. Gadzirisa MDF mafaira.

Ko kana ndisingazive shanduro ye SQL Server dhatabhesi?

Hapana kunetseka. Yedu MDF yekudzoreredza software inozoona otomatiki vhezheni yako, isati yasvikatarts kugadzirisa huwori databases.

Unogona here kuburitsa data rakadzoreredzwa se .CSV mafaera?

Tine urombo asi parizvino yedu SQL dhatabhesi MDF yekudzoreredza software haitsigire kuzviita. Asi unogona kutumira tafura yako kune .CSV mafaira mukati SQL Server Management Studio zvakananga.

Inguva yakareba sei yandingashandisa iyo yakazara vhezheni?

Rezinesi revhezheni yakazara isingaperi. Unogona kuishandisa zvachose uye kwenguva dzisingagumi.

Ndeipi mhedzisiro yeSQL database huori?

Kune akawanda:

  1. Data kurasikirwa.
  2. Kuita kunodzikisira.
  3. Mamwe maoparesheni anogona kukundikana. Zvakadai sekuchengetedza, kudzokorora, nezvimwe.

Nzira yekuona sei MDF faira uori?

Kana ukasangana nechero dambudziko mu the list, ipapo faira rako reMDF raora. Uyezve, iwe unogona zvakare kushandisa unotevera kuraira kuona iyo MDF faira uori:

SARUDZA * KUBVA msdb..suspect_pages HERE (chiitiko_type = 1);

Mhando dzakasiyana dzezviitiko zvinoenderana nezvikanganiso zvakasiyana, sepazasi:

Chiitiko chechiitiko mhosho
1 823 kana 824 kukanganisa
2 Checksum yakaipa
3 Peji yakabvaruka

Ziva murairo uri pamusoro unogona kuona huwori hudiki mumafaira eMDF.

Unogona here kudzoreredza MDF mafaera akarwiswa neRansomware?

Ransomware imhando yemalware. Ichavharidzira mafaera ako eMDF database. Iwe unofanirwa kubhadhara mugadziri weRansomware kuti abvise dhatabhesi yako uye udzore data rako.

Neraki, yedu SQL database yekudzoreredza software inogona kudzoreredza data kubva kuMDF mafaera akatapukirwa neRansomware.

Zvimwe Zvinyorwa muRuzivobase