데이터베이스 확인(DBCC)
Microsoft.SQLServer.2005.Database.DBCC.CheckDB (Task)
지정한 데이터베이스에 있는 모든 개체의 할당, 구조적 및 논리적 무결성을 확인합니다.
Element properties:
Member Modules:
Source Code:
<Task ID="Microsoft.SQLServer.2005.Database.DBCC.CheckDB" Target="SQL2005Core!Microsoft.SQLServer.2005.Database" Accessibility="Internal" Enabled="true">
<Category>Maintenance</Category>
<ProbeAction ID="PA" TypeID="System!System.CommandExecuterProbe" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">
<ApplicationName>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ToolsPath$\Binn\OSQL.EXE</ApplicationName>
<WorkingDirectory>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ToolsPath$\Binn</WorkingDirectory>
<CommandLine>-S $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$ -E -Q "DBCC CHECKDB('$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$')"</CommandLine>
<TimeoutSeconds>300</TimeoutSeconds>
<RequireOutput>true</RequireOutput>
</ProbeAction>
</Task>