Kev sib tov, lossis cov cim cov ntaub ntawv sib txuam cov txheej txheem, siv nyob rau hauv kev ua thiab khaws cov ntaub ntawv ntawm MS SQL neeg rau zaub mov. Kev sib hais ob leeg suav nrog tag nrho cov qauv cim thiab kev sib xyaw thiab kev sib tsoo. Hloov cov ntawv qhia cov phiaj xwm yuav xav tau thaum tsim cov ntaub ntawv tshiab lossis thaum koj tau txais cov lus qhia yuam kev.
Cov Lus Qhia
Kauj ruam 1
Thov thim rov qab tag nrho cov chaw khaws ntaub ntawv pov thawj raws li qhov system databases yuav rov qab kho tom qab qhov kev sib hloov hloov tau tiav.
Kauj ruam 2
Nkag mus rau C: / Program Files / Microsoft SQL Server / 80 / Cuab Yeej / Bin thiab khiav cov nqi hluav taws xob rov qab tsim kho.exe txhawm rau hloov cov neeg rau zaub mov tsim daim phiaj tsis thas nruab (rau Microsoft SQL Server 2000).
Kauj ruam 3
Qhia meej txoj hauv kev rau qhov chaw nyob qhov qub chaw cov ntaub ntawv tsim cov ntaub ntawv khaws tseg (los ntawm lub neej ntawd, cov / x86 / Cov ntaub ntawv / ceev ntawm Microsoft SQL Server boot disk) (rau Microsoft SQL Server 2000).
Kauj ruam 4
Hloov cov phiaj xwm los ntawm kev khiav cov teeb tsa.exe los ntawm Microsoft SQL Server boot disk nrog tus yuam sij:
setup.exe / qn InctanceName = MSSQLServer Reinstall = SQL_Engine Rebuilddatabase = 1 SAPWD = new_password SA SQLCollation = new_schema_assignment (rau Microsoft SQL Server 2005).
Kauj ruam 5
Nco ntsoov tias / / qn hloov tivthaiv yuav ua rau lub ntsej muag ntawm cov teeb tsa ntawm lub ntsej muag sib dhos thiab txuag cov ntaub ntawv yuam kev hauv cov lus nkag (rau Microsoft SQL Server 2005).
Kauj Ruam 6
Restore tag nrho cov chaw tsim khoom raws li hloov cov phiaj xwm kev qhia ua rau lub databases system muab tso rau hauv kev pib lub xeev (rau Microsoft SQL Server 2005).
Kauj Ruam 7
Siv cov nqe lus nug SQL hauv qab no los hloov qhov kev tsim ua tsis tau - Cyrillic_General_CI_AS:
LAWV DATABASE database_name_to_modify COLLATE required_encoding_name.
Kauj ruam 8
Thov nco ntsoov tias kev ua haujlwm saum toj no tej zaum yuav xav tau hloov cov khoom ntawm cov chaw khaws ntaub ntawv raug xaiv rau kev siv tshwj xeeb. Hauv qhov no, qhov kev thov yuav raug hloov kho rau:
ALTER DATABASE db_name to_modify Teem Ib Single_User nrog Rollback Tam Sim Ntawd
LAWV DATABASE database_name_to_modify COLLATE required_encoding_name
TXHEEJ TXHEEM database_name_to_modify Teev Multi_User.
