Skip to main content

DBCC CHECKDB

Checks the logical and physical integrity of all the objects in the specified database.

DBCC CHECKDB('Galaxy');

Message Results:


DBCC results for 'Galaxy'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 1309 rows in 23 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 135 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 166 rows in 3 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 131 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 233 rows in 5 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1596 rows in 35 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 505 rows in 11 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 649 rows in 6 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 596 rows in 136 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 152 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1232 rows in 9 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 213 rows in 3 pages for object "sys.syssoftobjrefs".
DBCC results for 'HCROPsConfigurationCodestest'.
There are 1099 rows in 6 pages for object "HCROPsConfigurationCodestest".
DBCC results for 'HCROPsBreakdownOfPettyCash'.
There are 2 rows in 1 pages for object "HCROPsBreakdownOfPettyCash".
DBCC results for 'HCROPsStockRegister'.
There are 4 rows in 1 pages for object "HCROPsStockRegister".
DBCC results for 'HCROPs_AuditTrail'.
There are 601 rows in 65 pages for object "HCROPs_AuditTrail".
DBCC results for 'HCROPsWaterBillRegister'.
There are 1 rows in 1 pages for object "HCROPsWaterBillRegister".
DBCC results for 'Table_1'.
There are 183 rows in 8 pages for object "Table_1".
DBCC results for 'HCROPsProductSetup'.
There are 565 rows in 5 pages for object "HCROPsProductSetup".
DBCC results for 'HCROPsUserSetup'.
There are 7 rows in 1 pages for object "HCROPsUserSetup".
DBCC results for 'HCROPsStampRegister'.
There are 6 rows in 1 pages for object "HCROPsStampRegister".
DBCC results for 'CIF_Report_Archive'.
There are 14 rows in 1 pages for object "CIF_Report_Archive".
DBCC results for 'CIF_RFCD_FC_DebitCardInformation'.
There are 534 rows in 34 pages for object "CIF_RFCD_FC_DebitCardInformation".
DBCC results for 'ErrorLog'.
There are 16 rows in 7 pages for object "ErrorLog".
DBCC results for 'AuditTrail'.
There are 530 rows in 41 pages for object "AuditTrail".
DBCC results for 'HCROPs_ErrorLog'.
There are 393 rows in 310 pages for object "HCROPs_ErrorLog".
DBCC results for 'CIF_CardPro_IRIS_USDDATA'.
There are 157 rows in 7 pages for object "CIF_CardPro_IRIS_USDDATA".
DBCC results for 'HCROPsStampRequisition'.
There are 17 rows in 1 pages for object "HCROPsStampRequisition".
DBCC results for 'HCROPsStampRegisterHistory'.
There are 6 rows in 1 pages for object "HCROPsStampRegisterHistory".
DBCC results for 'CIF_UsdCountry'.
There are 211 rows in 2 pages for object "CIF_UsdCountry".
DBCC results for 'BTS_WorkOrder'.
There are 0 rows in 0 pages for object "BTS_WorkOrder".
DBCC results for 'BTS_VendorBill'.
There are 0 rows in 0 pages for object "BTS_VendorBill".
DBCC results for 'BTS_StaffBill'.
There are 0 rows in 0 pages for object "BTS_StaffBill".
DBCC results for 'HCROPsCardRegisterHistory'.
There are 1 rows in 1 pages for object "HCROPsCardRegisterHistory".
DBCC results for 'BTS_Vendor'.
There are 0 rows in 0 pages for object "BTS_Vendor".
DBCC results for 'HCROPsPettyCashRegisterHistory'.
There are 4 rows in 1 pages for object "HCROPsPettyCashRegisterHistory".
DBCC results for 'HCROPsUserProductInfo'.
There are 30 rows in 1 pages for object "HCROPsUserProductInfo".
DBCC results for 'HCROPsCardRegister'.
There are 20 rows in 1 pages for object "HCROPsCardRegister".
DBCC results for 'HCROPsBspDollarRegister'.
There are 7 rows in 1 pages for object "HCROPsBspDollarRegister".
DBCC results for 'HCROPsGeneratorFuelRegister'.
There are 4 rows in 1 pages for object "HCROPsGeneratorFuelRegister".
DBCC results for 'HCROPsPettyCashRegister'.
There are 4 rows in 1 pages for object "HCROPsPettyCashRegister".
DBCC results for 'HCROPsChequeBookRegister'.
There are 7 rows in 1 pages for object "HCROPsChequeBookRegister".
DBCC results for 'HCROPsArchiveKeyRegister'.
There are 14 rows in 1 pages for object "HCROPsArchiveKeyRegister".
DBCC results for 'HCROPsChequeBookRegisterHistory'.
There are 4 rows in 1 pages for object "HCROPsChequeBookRegisterHistory".
DBCC results for 'HCROPsUserInfo'.
There are 4 rows in 1 pages for object "HCROPsUserInfo".
DBCC results for 'HCROPsPayOrderStockRegister'.
There are 11 rows in 1 pages for object "HCROPsPayOrderStockRegister".
DBCC results for 'HCROPsPayOrderStockRegisterHistory'.
There are 6 rows in 1 pages for object "HCROPsPayOrderStockRegisterHistory".
DBCC results for 'FATCABankInfo'.
There are 1 rows in 1 pages for object "FATCABankInfo".
DBCC results for 'CIF_ReportMaster'.
There are 14 rows in 1 pages for object "CIF_ReportMaster".
DBCC results for 'HCROPsConfigurationCodes'.
There are 1154 rows in 8 pages for object "HCROPsConfigurationCodes".
DBCC results for 'HCROPsMaterialRequisiton'.
There are 8 rows in 1 pages for object "HCROPsMaterialRequisiton".
DBCC results for 'CIF_ReportConfiguration'.
There are 58 rows in 1 pages for object "CIF_ReportConfiguration".
DBCC results for 'FATCA_BAL_INFO'.
There are 1 rows in 1 pages for object "FATCA_BAL_INFO".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'FATCA_CURRENCY'.
There are 2 rows in 1 pages for object "FATCA_CURRENCY".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'OtherBankInfoAll'.
There are 539 rows in 26 pages for object "OtherBankInfoAll".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Galaxy'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

MSDN
The command “DBCC CHECKDB(<db name>)” checks the logical and physical integrity of all the objects in the specified database. If corruption has occured for any reason, the DBCC CHECKDB command will find it, and tell you exactly where the problem is. DBCC CHECKDB has a few optional arguments to help fix your corrupt database. Depending on how bad it is, you may need to use the “REPAIR_ALLOW_DATA_LOSS”, which, as the name applies, will fix  your database, but some data might get lost. You should _always_ try to recover your database using a backup before using the “REPAIR_ALLOW_DATA_LOSS”argument. Other corruptions which can be fixed without data loss, could be inconsistency between the table and the indexes. Let’s say one of your nonclustered indexes for some reason miss a couple of rows – then a index rebuild will fix it. This argument is called REPAIR_REBUILD.

Comments

Post a Comment

Popular posts from this blog

Database View

View is a database object also called a logical table. it has no psychical existence. It is not like a simple table, but is a virtual or logical table which contains columns and data from different tables (may be one or more tables). A View does not contain any data, it is a set of queries that are applied to one or more tables that is stored within the database as an object. After creating a view from some table(s), it used as a reference of those tables and when executed, it shows only those data which are already mentioned in the query during the creation of the View. Creating view Syntax: ------------------------------------------------- CREATE VIEW [View_Name] AS [ SELECT Statement] ------------------------------------ ------------- CREATE VIEW SampleView As SELECT EmpID, EmpName FROM EmpInfo -------------------------------------------------- Data retrieve from view: SELECT * FROM SampleView WHERE EmpID ='FN0009C1'     View does not modif
Post a Comment
Read more

Efficiently Paging Through Large Amounts of Data (PageIndex, Page Size) -SQL Server

In this article you learn how to fetch data according PageIndex and PageSize. In web application, it is much more important to increase webform performance, loadbalance. In my development experience, some of table hold large amount of records (more than 2GB) and user need to shows records in GridView. But problem is when we select all records and loads in webforms, webform has crashed. In that case, I will simply solved with Table Variable and using Grid Page Number and Page Size. 1. Create Procedure CREATE PROCEDURE Load_Data_WithPaging @PageIndex AS INT , /*Selected Row Index of selected grid*/ @PageSize AS INT , /*Total page size of selected grid*/ @TotalRecords AS INT OUT /*used for display virtual page no*/ AS BEGIN SET NOCOUNT ON ; DECLARE @FromIndex AS INT = 0 , @ToIndex AS INT = 0 ; SET @FromIndex = (@PageIndex * @PageSize) + 1 ; /*First row no selection*/ SET @ToIndex = ((@PageIndex
Post a Comment
Read more

What is an Index? Explain Custered Index and Non-Clustered Index

Index Index is a database object, which can be created on one or more columns (16 Max column combination). When creating the index will read the column(s) and forms a relevant data structure to minimize the number of data comparisons. The index will improve the performance of data retrieval and adds some overhead on data modification such as create, delete and modify. So it depends on how much data retrieval can be performed on table versus how much of DML ( Insert , Delete and Update ) operations. clustered index A clustered index is something that reorganizes the way records in the table are physically stored. Therefore a table can have only one clustered index. The leaf nodes of a clustered index contain the data pages, by which I mean the key-value pair in the clustered index has the index key and the actual data value. Also remember, a clustered index will be created on a table by default the moment a primary key is created on the table. A clustered index is so
Post a Comment
Read more