Lub Microsoft SQL Cov Ntaub Ntawv rau kev tswj fwm niaj hnub no yog ib qho ntawm feem hloov thiab muaj zog. Txhua cov ntaub ntawv ntawm cov ntaub ntawv khaws tseg los ntawm nws tau muab cia rau hauv mdf-files (Master Database File). Nrog kev siv dav ntawm cov ntaub ntawv khaws tseg (ntau cov kab nkag thiab cov kab ntawm cov rooj), cov thawv ntim cov ntawv ua kom tawg. Nws cov ntim pib pib ntau dua qhov tiag tiag ntawm cov ntaub ntawv khaws cia hauv lub chaw khaws ntaub ntawv. Yog tias tsim nyog, koj tuaj yeem ceev cov ntaub ntawv mdf siv SQL Server.
Tsim nyog
- - Microsoft SQL Server khiav ntawm lub computer hauv zos;
- - SQL neeg rau zaub mov tswj Studio.
Cov Lus Qhia
Kauj ruam 1
Txuas mus rau qhov chaw khaws ntaub ntawv. Hauv SQL Server Management Studio, xaiv cov khoom "Txuas Khoom Tshawb …" nyob rau hauv nqe lus Qhia ntawm cov ntawv qhia zaub mov tseem ceeb. Daim Ntawv Txuas Rau Server nkag yuav tshwm. Cov tib cov lus pom yog tso tawm ncaj qha tom qab pib SQL Server Management Studio. Xaiv Database Engine nkag los ntawm Server daim ntawv teev-down daim ntawv teev. Nyob rau ntawm tus neeg rau zaub mov lub npe ntawv lub thawv, sau lub npe hauv lub computer. Nyob rau hauv daim ntawv txheeb xyuas qhov tseeb, ua cov khoom tam sim no sib xws rau hom kev lees paub uas txhawb los ntawm lub chaw pabcuam hauv SQL. Yog tias koj xaiv SQL Server Authentication, nkag mus siv cov ntawv pov thawj hauv tus neeg siv lub npe thiab Tus password. Nyem Rau Txuas Txuas khawm.
Kauj ruam 2
Pib cov txheej txheem ntawm kev ntxiv ib qho chaw khaws ntaub ntawv uas twb muaj lawm. Xaiv cov ntawv sau ntawm cov ntawv hauv yam khoom kem. Txoj nyem rau nws. Xaiv "Txuas …" los ntawm cov ntawv qhia zaub mov.
Kauj ruam 3
Xaiv mdf ntawv los xa. Hauv Daim Ntawv Txuas Rau Databases window dialog, nyem lub pob "Add …". Hauv Qhov Xaiv Xaiv cov ntoo nplaub tshev ntawm Daim Ntawv Teev Cov Ntaub Ntawv Cov Ntaub Ntawv sib tham, nrhiav thiab nthuav cov kab ntawv nrog cov ntawv mdf. Highlight nws thiab nyem OK.
Kauj ruam 4
Ntxiv cov ntaub ntawv tshiab uas muaj nyob hauv cov ntawv mdf. Hauv Daim Ntawv Qhia Txuas Database, xyuas qhov tseeb ntawm txoj kev. Xaiv cov khoom nkaus xwb hauv Cov Ntaub Ntawv los muab cov npe sau cia. Hauv Cov Ntaub Ntawv Cov ntsiab lus pab pawg ntawm kev tswj hwm, lwv tawm cov khoom sib thooj rau cov ntawv sau cia, yog tias tsis pom (cov lus pom tsis pom nyob hauv Daim Teb Xov). Txhawm rau ua qhov no, nyem lub khawm Tshem Tawm. Nyem OK.
Kauj ruam 5
Pib compressing mdf cov ntaub ntawv. Hauv qhov Object Explorer lub qhov rai, pom cov khoom sib raug rau lub chaw khaws ntaub ntawv tshiab. Thas xim rau nws. Nyem rau nws nrog txoj khawm nas. Hauv cov ntawv qhia txog khoom lag luam, xaiv Cov Ntawv Ua Haujlwm, Ntsws, Cov Ntaub Ntawv cov khoom.
Kauj Ruam 6
Hlob lub mdf ntawv. Hauv Shrink File window, xaiv qhov Tso Tawm yam tsis muaj kev xaiv lub chaw. Nyem OK thiab tos rau lub lag luam kom tiav.
Kauj Ruam 7
Siv cov ntaub ntawv txuas nrog yav dhau los tawm ntawm kev tswj ntawm tus neeg rau zaub mov. Hauv qhov Object Explorer lub qhov rais, nyem rau ntawm cov khoom sib raug rau cov ntawv sau nkag hauv ntxiv plaub plaub. Hauv cov ntawv qhia txog khoom ntiag tug, xaiv Cov Haujlwm thiab Tshawb cov khoom. Nyem rau lawv xav tshuaj khawm nyob rau hauv lub qhov rai uas tshwm. Tom qab ntawd, cov ntawv mdf tuaj yeem siv ntawm koj qhov kev txiav txim siab.
