DataNumen SQL Recovery

Kuv yuav nrhiav tau cov ntaub ntawv rov qab qhov twg?

Cov ntaub ntawv zoo tu qab tso tawm mus rau cov ntaub ntawv tshiab hauv lub SQL Server piv txwv koj txuas rau thaum starting cov txheej txheem SQL MDF rov qab.

MDF cov ntaub ntawv npe ntawm cov ntaub ntawv tso zis tau teev tseg ua ntej koj start rov.

Feem ntau, koj tsis tas yuav nkag mus rau SQL database MDF cov ntaub ntawv ncaj qha. Tom qab cov txheej txheem rov qab, nkag mus rau cov ntaub ntawv rov qab, thov ua raws li hauv qab no:

1. Start SQL Server Tswj Studio.
2. Txuas rau lub SQL Server piv txwv uas yog tib yam li qhov koj siv los rov qab koj cov ntaub ntawv tsis raug.
3. Tom qab kev sib txuas, nyem qhov piv txwv.
4. Tom qab ntawd nias databases ntawm.
5. Tom qab ntawd koj yuav pom ib lossis qee qhov databases hu ua "Database_Recovered_On_yyyy_mm_dd_hh_mm_ss_#", qhov twg yyyy, mm, dd, hh, mm, ss yog lub sijhawm tsim database, piv txwv li, xyoo, hli, hnub, teev, feeb thiab thib ob. Thiab # yog tus lej starting los ntawm 1. Cov ntaub ntawv no tuaj yeem yooj yim pab koj txheeb xyuas cov ntaub ntawv tsim tawm los ntawm cov txheej txheem rov qab tshiab.
6. Nyem qhov node ntawm database koj txheeb xyuas. Tom qab ntawd koj tuaj yeem nkag mus rau tag nrho cov khoom siv SQL database zoo. Piv txwv li, hauv qab ntxhuav node, koj tuaj yeem pom tag nrho cov ntaub ntawv rov qab tau zoo, suav nrog cov schemas thiab cov ntaub ntawv.

Yuav ua li cas txo cov ntaub ntawv poob thaum lub sij hawm a SQL Server data puas tsuaj?

Nws raug nquahu kom npaj cov phiaj xwm rov qab los ntawm kev puas tsuaj (DR) rau koj SQL Server Piv txwv li, uas ib txwm muaj xws li:

1. Txhua zaus backup koj SQL Server cov ntaub ntawv.
2. Muaj ib tug kws SQL rov qab cuab tam xws li DataNumen SQL Recovery ntawm tes. Yog li thaum koj ntsib SQL database kev noj nyiaj txiag, koj tuaj yeem siv nws los kho cov ntaub ntawv tsis raug thiab rov qab tau koj cov ntaub ntawv sai li sai tau.
3. Siv cov yam ntxwv muaj nyob hauv siab SQL Server.

Dab tsi yog koj cov khoom zoo dua li lwm yam MS SQL database rov qab cov cuab yeej?

Koj tuaj yeem pom qhov ua tiav kev sib piv ntawm peb cov khoom nrog lwm yam MS SQL database rov qab cov cuab yeej hauv khw.

Kuv puas tuaj yeem ncua / rov pib kho SQL database txheej txheem?

Uas tsis tau. Yog tias qhov kev kho tau raug started, ces koj tuaj yeem rho nws los yog cia nws ua tiav. Tom qab ntawd yog tias koj xav rov kho tib yam ntaub ntawv SQL database, ces koj yuav tsum rov ua duatart cov txheej txheem kho txij thaum pib.

Txawm li cas los xij, thaum lub sijhawm kho, koj tuaj yeem pom cov ntaub ntawv rov qab hauv SQL Server tswj studio tib lub sijhawm. Yog tias koj xav tias tag nrho cov ntaub ntawv xav tau rov qab los, ces koj tuaj yeem rho tawm cov txheej txheem kho kom txuag koj lub sijhawm, tsis muaj kev puas tsuaj rau cov ntaub ntawv tso tawm.

Kuv tsuas muaj SQL MDF cov ntaub ntawv, cov ntaub ntawv teev npe (LDF) yog lost. Yuav ua li cas?

DataNumen SQL Recovery tuaj yeem rov qab tau koj cov ntaub ntawv los ntawm cov ntaub ntawv tsis raug MDF yam tsis muaj Transformation log (LDF) cov ntaub ntawv. Yog li yog tias koj cov ntaub ntawv teev npe pauv yog lost, uas yuav tsis muaj teeb meem.

Koj puas txhawb kom rov qab tau cov ntaub ntawv hauv XML?

Yog lawm, peb SQL database rov qab software txhawb nqa rov qab cov ntaub ntawv hauv ASCII thiab Unicode XML cov ntaub ntawv hom.

Kuv puas yuav tsum tau ua tus thawj tswj hwm database (DBA) los ua qhov rov qab?

Yog, koj yuav tsum yog tus database administrator (DBA), los yog tsawg kawg tau txais cov ntaub ntawv hauv qab no los ntawm database administrator (DBA):

1. SQL Server npe piv txwv (Server Name)
2. Authentication ntawm lub SQL Server Xws li.

Yog li koj tuaj yeem siv cov ntaub ntawv no los txuas rau lub SQL Server piv txwv thiab ua qhov rov qab.

Microsoft puas SQL Server puas muaj cov cuab yeej built-in kom rov qab tau cov ntaub ntawv tsis raug?

Yog lawm, lawv muaj cov lus txib ua hauv dbcc, piv txwv li, dbcc checkdb thiab dbcc checktable, uas tuaj yeem tshawb xyuas lub rooj schemas thiab cov ntaub ntawv, tom qab ntawd kho cov teeb meem me me hauv koj cov ntaub ntawv tsis raug lossis cov ntaub ntawv database. Txawm li cas los xij, cov cuab yeej no tsuas yog ua haujlwm rau cov neeg mob tsawg heev. Yog tias lawv tsis tuaj yeem kho MDF cov ntaub ntawv kev noj nyiaj txiag, ces koj yuav zoo dua sim DataNumen SQL Recovery, uas ua haujlwm zoo dua.

Qee qhov kev siv yooj yim ntawm dbcc checkdb tau teev tseg hauv qab no:

Hais kom	pab
dbcc checkdb('MyDB.mdf')	Xyuas seb MyDB.mdf puas muaj teeb meem.
dbcc checkdb('MyDB.mdf', REPAIR_ALLOW_DATA_LOS)	Tshawb xyuas MyDB.mdf. Yog tias muaj teeb meem, kho MDF cov ntaub ntawv database, uas yuav ua rau cov ntaub ntawv poob.
dbcc checkdb('MyDB.mdf', REPAIR_REBUILD)	Tshawb xyuas MyDB.mdf. Yog tias muaj teeb meem, kho MDF cov ntaub ntawv database, uas yuav TSIS ua rau cov ntaub ntawv poob, tab sis yuav siv sij hawm ntau dua.

Qee qhov kev siv yooj yim ntawm dbcc checktable yog teev hauv qab no:

Hais kom	pab
dbcc checktable ('MyDB.MyTable')	Xyuas seb MyTable hauv MyDB puas muaj teeb meem.
dbcc checktable('MyDB.MyTable', REPAIR_ALLOW_DATA_LOS)	Tshawb xyuas MyTable hauv MyDB. Yog tias muaj teeb meem, kho lub rooj, uas yuav ua rau cov ntaub ntawv poob.
dbcc checktable('MyDB.MyTable', REPAIR_REBUILD)	Tshawb xyuas MyTable hauv MyDB. Yog tias muaj teeb meem, kho lub rooj, uas yuav TSIS ua rau cov ntaub ntawv poob, tab sis yuav siv sij hawm ntau dua.

Qhov chaw disk ntau npaum li cas kuv xav tau npaj rau cov ntaub ntawv tso zis?

Ua ntej, koj yuav tsum xam tag nrho qhov loj ntawm cov ntaub ntawv, suav nrog SQL database MDF cov ntaub ntawv thiab tag nrho cov ntaub ntawv NDF cuam tshuam. Piv txwv tias yog SdataSize.

Tom qab ntawd, raws li SDataSize, koj yuav tsum npaj tsawg kawg 2 * (SDataSize * 110%) rau cov ntaub ntawv tso tawm ntawm koj qhov chaw xav tau, suav nrog cov ntaub ntawv SQL MDF thiab cov ntaub ntawv LDF.

Vim li cas kuv SQL Server database tau corrupt?

Muaj ntau ntau yam uas yuav ua rau SQL database kev noj nyiaj txiag, suav nrog:

1. Hardware vim li cas: xws li lub hwj chim tsis ua hauj lwm, tsis zoo sectors ntawm disks, hard disk tsis ua hauj lwm, npaj txhij txog kaw system, thiab lwm yam.
2. Software vim li cas: xws li software tsis xws luag, kab mob kis, ransomware tawm tsam, thaub qab tsis ua haujlwm, tsis siv cov ntaub ntawv database header, thiab lwm yam.

DataNumen SQL Recovery yog muaj peev xwm rov qab tau cov ntaub ntawv rau tag nrho cov saum toj no mob.

Hom ntawv ntawm cov ntaub ntawv rov qab yog dab tsi?

DataNumen SQL Recovery yuav txuas rau SQL Server piv txwv thiab siv nws los tsim cov ntaub ntawv rov qab. Yog li cov hom ntawv ntawm cov ntaub ntawv rov qab yog tib yam li cov SQL Server version ntawm qhov piv txwv koj txuas rau thaum ua qhov rov qab. Piv txwv li, yog tias koj txuas rau SQL Server Piv txwv li 2000, ces cov ntaub ntawv tso zis yuav kuj nyob rau hauv SQL Server 2000 format.

Cov version twg SQL server tau txais kev txhawb nqa?

DataNumen SQL Recovery txhawb kom rov qab SQL databases tsim los ntawm cov nram qab no versions ntawm MS SQL Server: SQL Server Xyoo 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.

Nws tuaj yeem txuas mus rau cov qauv hauv qab no ntawm SQL Server piv txwv los tsim cov ntaub ntawv ruaj khov: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019. Cov ntaub ntawv ruaj khov yuav tau txais kev cawmdim hauv version tib yam li cov SQL Server Xws li.

Koj puas tuaj yeem tso cov ntaub ntawv rov qab los ua SQL tsab ntawv?

Cov yav dhau los versions ntawm DataNumen SQL Recovery txhawb nqa zoo li no. Txawm li cas los xij, peb tau tshem tawm qhov tshwj xeeb no hauv cov versions tsis ntev los no.

Koj puas txhawb kom rov qab indexes thiab lwm yam khoom?

Yog lawm, indexes, cov yuam sij tseem ceeb, kev pom, kev tshwm sim, cov cai, cov txheej txheem, cov txheej txheem khaws cia, thiab lwm yam khoom raug txhawb.

Kuv tsis rov qab SQL database nrog koj cov ntaub ntawv rov qab cuab tam. Thov pab.

Thov hu rau peb thiab muab cov ntaub ntawv rov qab. Koj tuaj yeem pom cov ntsiab lus ntxiv ntawm yuav ua li cas kom tau cov ntaub ntawv rov qab.

Qee zaum, vim yog cov ntaub ntawv kev puas tsuaj, MDF cov ntaub ntawv thiab NDF cov ntaub ntawv yuav tsis muaj cov ntaub ntawv SQL tiag. Tab sis lub disk lossis tsav qhov twg koj tau khaws cov ntaub ntawv MDF lossis NDF tseem yuav muaj cov ntaub ntawv rov qab tau. Koj ua tau rov qab tau koj cov ntaub ntawv los ntawm disk lossis tsav ncaj qha.

Kuv puas tuaj yeem khaws cov ntaub ntawv rov qab rau hauv ntau cov ntaub ntawv?

Thov txim tab sis tam sim no peb cov cuab yeej tsis raug SQL cov ntaub ntawv rov qab tsis txhawb nqa kom txuag tau cov ntaub ntawv rov qab rau hauv ntau cov ntaub ntawv cov ntaub ntawv, piv txwv li, ib qho ntaub ntawv tseem ceeb (MDF) thiab ntau cov ntaub ntawv thib ob (NDF).

Txawm li cas los xij, tom qab SQL MDF cov txheej txheem rov qab ua tiav, koj tuaj yeem ua raws li hauv qab no los siv koj lub hom phiaj:

1. Start SQL Server tswj studio.
2. Tsim ib tug tshiab database thiab tsim cov ntaub ntawv thiab filegroups raws li koj xav tau, xws li kis cov ntaub ntawv hla ntau cov ntaub ntawv.
3. Clone cov ntaub ntawv rov qab los ntawm cov ntaub ntawv rov qab mus rau cov ntaub ntawv tshiab tsim nyob rau hauv kauj ruam 2. Xwb, koj tuaj yeem xa cov ntaub ntawv rov qab los ua SQL tsab ntawv, thiab tom qab ntawd import cov ntawv rov qab mus rau cov ntaub ntawv tshiab.

Dab tsi yog qhov txwv ntawm qhov demo version?

Lub demo version siv tib cov ntaub ntawv rov qab lub cav raws li tag nrho version, tshwj tsis yog tias nws yuav ntxig cov ntawv demo hauv qee qhov chaw hauv cov ntaub ntawv rov qab.

Koj puas tuaj yeem rov qab tau lub rooj schema nkaus xwb?

Peb SQL database rov qab software yuav rov qab tau tag nrho cov ntaub ntawv, suav nrog cov ntxhuav thiab tag nrho lwm yam khoom. Rau cov ntxhuav, ob lub rooj schema thiab cov ntaub ntawv teev cov ntaub ntawv yuav raug zoo. Nws tsis tuaj yeem rov qab tau lub rooj schema nkaus xwb.

Cov versions twg ntawm Windows tau txais kev txhawb nqa?

Tam sim no, Windows 95/98/ME/NT/2000/XP/Vista/7/8/8.1/10/11 thiab Windows Server 2003/2008/2012/2016/2019 operating systems tau txais kev txhawb nqa. Tsis tas li, ob qho tib si 32-ntsis thiab 64-ntsis tshuab tau txais kev txhawb nqa.

Koj puas tuaj yeem tso cov ntaub ntawv raws li ib qho MDF thiab ntau NDF cov ntaub ntawv?

Thov txim tab sis tam sim no peb tsuas txhawb kom tso tawm ib qho SQL MDF cov ntaub ntawv.

Koj cov ntaub ntawv rov qab cov cuab yeej qhia tau hais tias qhov yuam kev thaum rov qab qhov ntsuas. Yuav daws qhov teeb meem li cas?

Qee qhov indexes muaj qee qhov tshwj xeeb txwv, xws li tshwj xeeb, thaum cov ntaub ntawv rov qab tuaj yeem tsis ua raws li cov kev txwv no. Tom qab SQL MDF txheej txheem rov qab, koj tuaj yeem ua raws li hauv qab no los daws qhov teeb meem:

1. Tshem tawm qee cov ntaub ntawv rov ua dua kom paub tseeb tias cov ntaub ntawv seem ua tau raws li qhov txwv. Tom qab ntawd rov tsim qhov Performance index manually.

or

2. Tshem tawm qee qhov kev txwv hauv qhov ntsuas thiab rov tsim kho nws tus kheej.

Koj tuaj yeem ua ob qho tib si 1 thiab 2 nrog SQL scripts.

Kuv tsuas muaj corrupted MDF cov ntaub ntawv. Cov ntaub ntawv NDF cuam tshuam ploj lawm. Koj puas tuaj yeem rov qab tau cov ntaub ntawv?

Yog lawm, txawm tias koj tsuas muaj cov ntaub ntawv tseem ceeb, peb MDF rov qab software tseem tuaj yeem rov qab tau cov ntaub ntawv rau koj. Txawm li cas los xij, tsuas yog cov hauv MDF cov ntaub ntawv tuaj yeem rov qab tau. Cov hauv NDF cov ntaub ntawv yog dhau qhov rov qab vim koj tsis muaj cov ntaub ntawv NDF.

Koj puas tuaj yeem rov qab tau cov khoom encrypted?

Yog, peb ua tau. Thiab cov khoom encrypted, xws li cov txheej txheem khaws cia, yuav rov qab tau thiab khaws cia raws li decrypted versions.

Koj puas tuaj yeem rov qab deleted cov ntaub ntawv?

Yog lawm, los ntawm lub neej ntawd, peb cov ntaub ntawv rov qab cov cuab yeej yuav rov qab deleted cov ntaub ntawv. Koj tuaj yeem hloov qhov kev xaiv, raws li hauv qab no:

1. Start peb SQL MDF rov qab cuab tam.
2. Nyem "Options" tab.
3. Kos / Uncheck lub "Rov qab deleted cov ntaub ntawv" xaiv raws li.
4. Kho cov ntaub ntawv MDF.

Yuav ua li cas yog kuv tsis paub lub version ntawm lub SQL Server database?

Tsis muaj kev txhawj xeeb. Peb MDF rov qab software yuav pib-ntaus cov version rau koj, ua ntej nws starts kho corrupt databases.

Koj puas tuaj yeem tso cov ntaub ntawv rov qab ua .CSV cov ntaub ntawv?

Thov txim tab sis tam sim no peb SQL database MDF rov qab software tsis txhawb kom ua li ntawd. Tab sis koj muaj peev xwm export koj lub rooj rau .CSV cov ntaub ntawv nyob rau hauv SQL Server Management Studio ncaj qha.

Kuv tuaj yeem siv qhov puv version ntev npaum li cas?

Daim ntawv tso cai rau tag nrho version yog perpetual. Koj tuaj yeem siv nws mus ib txhis thiab tsis muaj sijhawm.

Dab tsi yog qhov tshwm sim ntawm SQL database kev noj nyiaj txiag?

Muaj ntau ntau:

1. Cov ntaub ntawv poob.
2. Kev ua haujlwm poob qis.
3. Qee qhov haujlwm yuav ua tsis tiav. Xws li backup, replicate, thiab lwm yam.

Yuav ua li cas thiaj paub MDF cov ntaub ntawv kev noj nyiaj txiag?

Yog tias koj ntsib ib qho teeb meem hauv daim ntawv, ces koj cov ntaub ntawv MDF yog corrupt. Ntxiv mus, koj tuaj yeem siv cov lus txib hauv qab no txhawm rau txheeb xyuas MDF cov ntaub ntawv kev noj nyiaj txiag:

SELECT * FROM msdb..suspect_pages WHERE (event_type = 1);

Cov xwm txheej sib txawv sib txawv ntawm qhov sib txawv, raws li hauv qab no:

Yam xwm txheej	kev ua yuam kev
1	823 lossis 824 yuam kev
2	Phem checksum
3	Nplooj tawg

Nco ntsoov cov lus txib saum toj no tsuas tuaj yeem ntes cov kev ua txhaum me me hauv MDF cov ntaub ntawv.

Koj puas tuaj yeem rov qab tau MDF cov ntaub ntawv tawm tsam los ntawm Ransomware?

Ransomware yog ib hom malware. Nws yuav encrypt koj cov ntaub ntawv MDF database. Koj yuav tsum them tus tsim ntawm Ransomware los txiav txim siab koj cov ntaub ntawv thiab tau txais koj cov ntaub ntawv rov qab.

Hmoov zoo, peb SQL database rov qab software tuaj yeem rov qab tau cov ntaub ntawv los ntawm MDF cov ntaub ntawv kis los ntawm Ransomware.

Ntau cov ntawv hauv Knowledgebase