Kuv yuav qhib MDF thiab LDF cov ntaub ntawv li cas?
Kuv yuav qhib MDF thiab LDF cov ntaub ntawv li cas?

Video: Kuv yuav qhib MDF thiab LDF cov ntaub ntawv li cas?

Video: Kuv yuav qhib MDF thiab LDF cov ntaub ntawv li cas?
Video: Plab Plab Ntswg..(Pluav Pluav Ntswg) Maiv Twm New Song 2023-2024 2024, Kaum ib hlis
Anonim

Nyeem ntawv. ldf cov tsuas yog siv tau cov cuab yeej thib peb xws li ApexSQL Log. Kuj tseem muaj SQL Log Rescue uas yog pub dawb tab sis tsuas yog rau SQL Server 2000. Hauv SQL Server managementstudio koj tuaj yeem " Txuas "ib MDF cov ntaub ntawv , uas yog txuam nrog cov LDF (log ntaub ntawv ).

Kuj nug, Kuv yuav thauj cov ntaub ntawv MDF thiab LDF li cas hauv SQL Server?

  1. Nthuav cov npe SQL server.
  2. Right-click Databases, xaiv Txhua Txoj Haujlwm -> AttachDatabase
  3. Nyem qhov "" khawm kom xauj rau cov ntaub ntawv.mdf.
  4. Qhia qhov tsim nyog.mdf cov ntaub ntawv thiab nyem OK.
  5. Nyem OK dua.
  6. Cov ntaub ntawv tam sim no yuav tshwm sim hauv Enterprise Manager.

Tsis tas li ntawd, kuv tuaj yeem qhib LDF cov ntaub ntawv hauv SQL Server li cas? Saib cov ntaub ntawv log

  1. Txoj cai-nias SQL Server Logs, taw tes rau Saib, thiab tom qab ntawd nyem rau ntawm SQL Server Log lossis SQL Server thiab Windows Log.
  2. Nthuav SQL Server Logs, right-click any log file, and thennclick View SQL Server Log. Koj tseem tuaj yeem nyem ob npaug rau txhua lub logfile.

Qhov thib ob, MDF thiab LDF cov ntaub ntawv yog dab tsi?

1. MDF yog cov ntaub ntawv tseem ceeb ntaub ntawv rau MSSQL. The LDF , ntawm qhov tod tes, yog kev txhawb nqa ntaub ntawv andis characterized as a server transaction log ntaub ntawv .2. MDF muaj tag nrho cov ntaub ntawv tseem ceeb thiab tsim nyog nyob rau hauvdatabases thaum lub LDF muaj tag nrho cov kev nqis tes ua uas suav nrog kev hloov pauv thiab hloov pauv hauv MDFfile.

Kuv yuav ua li cas nrog MDF thiab MDS cov ntaub ntawv?

. MDF Cov ntaub ntawv Association 2 Ib MDF cov ntaub ntawv yog ib daim duab disc tau txais kev cawmdim los ntawm qhov kev pab cuam disauthoring xws li Cawv 120%. Nws khaws cov ntaub ntawv CD lossis DVD disc tiag tiag, thaum lub header thiab cov ntaub ntawv taug qab tau khaws cia tsis sib xws. MDS cov ntaub ntawv . MDF cov ntaub ntawv zoo ib yam li. ISO cov ntaub ntawv , tab sis tau txais kev cawmdim hauv ib hom ntawv sib txawv.

Pom zoo: