Cov txheej txheem:

Yuav ua li cas thiaj nrhiav tau SQL Server yuam kev cav?
Yuav ua li cas thiaj nrhiav tau SQL Server yuam kev cav?

Video: Yuav ua li cas thiaj nrhiav tau SQL Server yuam kev cav?

Video: Yuav ua li cas thiaj nrhiav tau SQL Server yuam kev cav?
Video: Kev Muag Khoom thiab Kev Sib Cuam Tshuam Nrog Cov Neeg Qhua Yam Muaj Kev Nyab Xeeb 2024, Kaum ib hlis
Anonim

Saib qhov yuam kev Log nrog SQL Server Management Studio

  1. Hauv Microsoft SQL Server Management Studio, nthuav cov SQL Server .
  2. Hauv Object Explorer, nthuav Kev Tswj → SQL Server Logs .
  3. Xaiv qhov yuam kev log koj xav pom, piv txwv li tam sim no log ntaub ntawv.
  4. Double-click lub log file los yog right-click rau nws thiab xaiv Saib SQL Server Log .

Hauv qhov no, kuv yuav saib SQL Server keeb kwm li cas?

Mus saib cov ntaub ntawv keeb kwm ua haujlwm

  1. Hauv Object Explorer, txuas mus rau ib qho piv txwv ntawm SQL Server Database Cav, thiab tom qab ntawd nthuav qhov piv txwv ntawd.
  2. Nthuav SQL Server Agent, thiab tom qab ntawd nthuav Txoj Haujlwm.
  3. Right-click ib txoj haujlwm, thiab tom qab ntawd nyem Saib Keeb Kwm.
  4. Hauv Log File Viewer, saib cov haujlwm keeb kwm.
  5. Txhawm rau hloov kho cov haujlwm keeb kwm, nyem Refresh.

Qhov thib ob, kuv puas tuaj yeem tshem tawm SQL Server yuam kev cav? Yog li cov lus teb luv luv yog: yog, nyob rau hauv txhua rooj plaub, SQL Server yuav thaum kawg tau nyob ib ncig ntawm rho tawm laus yuam kev log cov ntaub ntawv. SQL Server rov siv dua yuam kev log txiav txim, tsuav yog koj configure kom raug. Saib https://msdn.microsoft.com/en-us/library/ms177285.aspx.

Yog li ntawd, dab tsi yog qhov yuam kev cav hauv SQL Server?

Cov SQL Server yuam kev log yog ib cov ntaub ntawv uas muaj tag nrho cov lus generated los ntawm SQL Server . Los ntawm lub neej ntawd qhov no qhia koj thaum twg log thaub qab tau tshwm sim, lwm yam xwm txheej xov xwm, thiab txawm tias muaj cov khoom thiab qhov chaw ntawm cov khoom pov tseg.

Kuv yuav saib SQL Server cav li cas hauv Event Viewer?

Hauv Search bar, ntaus Event Viewer , thiab ces xaiv lub Event Viewer desktop app. Hauv Event Viewer , qhib Daim Ntawv Thov thiab Kev Pabcuam Cov log . SQL Server Cov xwm txheej raug txheeb xyuas los ntawm kev nkag MSSQLSERVER (cov xwm txheej muaj npe raug txheeb xyuas nrog MSSQL $) nyob rau hauv kab ntawv Source.

Pom zoo: