Tus tswv DB yog dab tsi hauv SQL Server?
Tus tswv DB yog dab tsi hauv SQL Server?

Video: Tus tswv DB yog dab tsi hauv SQL Server?

Video: Tus tswv DB yog dab tsi hauv SQL Server?
Video: Kev Muag Khoom thiab Kev Sib Cuam Tshuam Nrog Cov Neeg Qhua Yam Muaj Kev Nyab Xeeb 2024, Kaum ib hlis
Anonim

dbo, lub tus tswv database , yog tus neeg siv tus account uas tau hais txog kev tso cai los ua txhua yam haujlwm hauv database . Cov tswv cuab ntawm sysadmin tsau server roleare tau mapped rau dbo. dbo kuj yog lub npe ntawm schema, raws li tau tham hauv Cov tswv cuab thiab User-Schema Sib cais hauv SQL Server.

Ntxiv mus, dab tsi yog tus tswv database hauv SQL Server?

Yeej a tus tswv database yog lub default dbo( tus tswv database ) ntawm database , nrog cov database nws tus kheej yog ib database khoom. Lub dbo yog auser uas tau hais txog kev tso cai los ua txhua yam haujlwm hauv database.

Kuj Paub, Kuv yuav hloov tus tswv ntawm SQL Server database li cas? Peb tuaj yeem ua raws li cov kauj ruam no los hloov tus tswv database siv SSMS.

  1. Qhib SQL Server Management Studio (SSMS).
  2. Txoj nyem rau ntawm Database, ces xaiv Properties.
  3. Nyem rau ntawm Files. Cov screenshot hauv qab no yuav tshwm sim.
  4. Yog tias peb xav hloov tus tswv database, nyem rau ntawm lub ellipsisbutton xaiv tus tswv tshiab.

Tsis tas li ntawd, kuv yuav nrhiav tau tus tswv ntawm SQL Server database li cas?

Mus rau SQL Server Management Studio >> RightClick rau ntawm Database >> Mus rau Properties >> Goto Files thiab xaiv Tus tswv . Koj tuaj yeem pom cov duab thaij duab hauv qab no uas piav qhia yuav ua li cas ua haujlwm tib yam. Thov cia kuv paub thaum twg yog zaum kawg koj yuav tsum tau hloov lub tus tswv ntawm lub database thiab koj siv txoj kev twg los doso?

Koj txhais li cas los ntawm database?

A database (DB), nyob rau hauv feem ntau lub ntsiab lus, yog anorganized sau cov ntaub ntawv. Tshwj xeeb tshaj yog, a database yog lub tshuab hluav taws xob uas tso cai rau cov ntaub ntawv nkag mus tau yooj yim, tswj hwm thiab hloov kho tshiab. Niaj hnub databases yog tswj siv database tswj qhov system (DBMS).

Pom zoo: