Ib qho chaw khaws ntaub ntawv yog kev sau cov ntaub ntawv uas tau teeb tsa raws li qee txoj cai thiab nyob hauv lub hlwb nco. Nws cim txog lub xeev tam sim no ntawm hom kev kawm tshwj xeeb.
Tsim nyog
- - khoos phis tawj;
- - neeg rau zaub mov;
- - Sql database.
Cov Lus Qhia
Kauj ruam 1
Mus rau SQL Server Management Studio los muab cov ntawv sau, tom qab ntawd mus rau Object Explorer thiab txuas rau MicrosoftSQL Server Database Cav Piv txwv, nthuav nws. Hu cov ntsiab lus teb ua zaub mov ntawm "Databases" ntawm. Nyem rau ntawm lo "Txuas" qhov hais kom ua.
Kauj ruam 2
Hauv "Txuas databases" khawm lub thawv, nyem rau "Ntxiv" khawm, xaiv hauv "Database files location" qhov rai uas yuav tsum muaj disk uas lub chaw khaws ntaub ntawv nyob, nthuav cov ntoo nplaub tshev los tshawb thiab xaiv cov ntawv ua hom Mdf. Yog tias koj sim xaiv lub hauv paus uas twb txuas nrog lawm, ib qho kev ua yuam kev yuav tshwm sim. Txhawm rau hloov nws lub npe, sau nws rau ntawm kab Txuas Nrog hauv kab ntawv ntawm kab ntawv Database.
Kauj ruam 3
Hloov pauv tus tswv, yog tias tsim nyog, thaum muab cov ntawv pov thawj, los ua qhov no, xaiv cov nqi yam xav hauv "Tus Tswv". Yog tias txhua yam npaj txhij txuas lub hauv paus rau lub server, nyem rau lub pob "OK". Cov ntaub ntawv tshiab tso tawm tsuas yog yuav tshwm sim hauv Databases node hauv qhov browser tom qab koj rov qab kho txoj kev pom. Ua li no, nyem rau ntawm qhov browser browser, mus rau "Saib" cov ntawv qhia zaub mov, xaiv qhov "Refresh" hais kom ua.
Kauj ruam 4
Nco ntsoov tias txhua cov ntaub ntawv cov ntaub ntawv yuav tsum muaj thaum muab cov ntaub ntawv rau lub server. Yog tias cov ntaub ntawv cov ntaub ntawv muaj ib txoj hauv kev sib txawv ntawm qhov ib txwm tsim los yog los ntawm cov ntawv tom kawg, sau cov kab tam sim no rau cov ntawv. Thaum kev sib txuas ntawm cov ntawv txheeb ntawm lub cim rau lub server thawj zaug, qhib lub database master key los ntawm kev khiav qhov lus txib: OPEN MASTER QHOV TSEEM CEEB LOS NTAWM PASSWORD = "Nkag mus rau koj lo lus zais".
Kauj ruam 5
Xu siab ntawm decryption tsis siv neeg. Yog tias lub chaw khaws ntaub ntawv muaj peev xwm nyeem tau thiab nyeem tau, muab cov ntawv sau cia rau qhov chaw tshiab. Khaws lawv kom txog thaum lub hauv paus koom nrog tsis tau lawv. Yog tias lub chaw khaws ntaub ntawv muaj ib lub cav ntim thiab koj tsis qhia qhov chaw tshiab rau nws, lub lag luam yuav siv qhov chaw nyob qub ntawm cov ntawv.
