Yuav Faib Cov Ntaub Ntawv Rau SQL Server

Cov txheej txheem:

Yuav Faib Cov Ntaub Ntawv Rau SQL Server
Yuav Faib Cov Ntaub Ntawv Rau SQL Server

Video: Yuav Faib Cov Ntaub Ntawv Rau SQL Server

Video: Yuav Faib Cov Ntaub Ntawv Rau SQL Server
Video: Paj ntaub hmoob ua hlab se 2024, Kaum ib hlis
Anonim

Tsim cov ntaub ntawv siv SQL Server Management Studio yog ib qho qauv ua haujlwm thiab tsis tas yuav muaj kev nkag siab tob ntawm cov khoom siv computer los ntawm tus neeg siv khoom. Hauv qhov no, SQL Server 2008 R2 yog xav tau.

Yuav faib cov ntaub ntawv rau SQL Server
Yuav faib cov ntaub ntawv rau SQL Server

Cov Lus Qhia

Kauj ruam 1

Txuas mus rau qhov yuav tsum tau ua piv txwv ntawm SQL Database Cav hauv Object Explorer thiab nthuav tawm qhov xav tau ntawm qhov xaiv piv txwv. Hu cov ntsiab lus teb ntawv qhia ntawm "Database" keeb kwm los ntawm nias lub khawm txoj cai thiab xaiv lo lus "Tsim cov ntaub ntawv". Nkag mus rau qhov xav tau tus nqi rau lub npe ntawm cov ntaub ntawv tab tom tsim nyob rau hauv kab "Tshiab database" thiab paub meej tias daim ntawv thov ntawm tag nrho cov txiaj ntsig.

Kauj ruam 2

Tsis txhob sim hloov qhov Siv Cov Ntawv Qhia Tag Nrho Cov Lus Qhia vim qhov kev hloov no tsis tuaj yeem hloov pauv thiab tsis tuaj yeem nkag mus. Siv daim teb nrog tus cim (…) txhawm rau hloov lub npe ntawm tus tswv ntawm cov chaw khaws ntaub ntawv raug tsim, lossis xaiv lub xovtooj ntawm yuav raug kho hauv "Database files" cov lus los pauv cov txiaj ntsig ntawm cov ntaub ntawv tseem ceeb thiab nkag mus yam xav tau tus nqi. Mus rau nplooj "Cov Ntawv" rau kev hloov kho cov teeb tsa txheeb cais ntawm cov qauv tsim thiab hais kom meej cov chaw yam xav tau hauv phau ntawv teev npe. Siv lub sijhawm los hloov tus qauv uas yuav tsum muaj los yog hloov kho qhov ntsuas ntawm lub hauv paus ntawm nws tus kheej ntawm tib nplooj ntawv.

Kauj ruam 3

Xaiv "Filegroups" nplooj ntawv los tsim cov ntawv qhia tshiab thiab siv "Ntxiv" kev xaiv. Nkag mus rau qhov xav tau qhov tseem ceeb rau txhua pab pawg ntxiv nyob hauv cov teb uas tsim nyog thiab mus rau nplooj ntawv "Advanced Properties" txhawm rau ntxiv cov khoom tsis muaj nyob rau lub chaw tsim tshiab. Nkag mus rau qhov kev xav tau tus nqi ntawm lub npe ntawm cov khoom ntiag tug ntxiv hauv Lub Npe Lub npe thiab ntaus cov lus piav qhia luv luv ntawm cov ntawv tsim hauv kab ntawv hauv Tus Nqi nqe yog li koj tuaj yeem txheeb tau ceev cov ntaub ntawv khaws cia. yuav tsum tau database hauv SQL Server Management Studio los ntawm nias OK.

Pom zoo: