Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noj17
Starting Member
18 Posts |
 Posted - 2008-12-01 : 23:08:39
|
| hello!need help from pros out there. Im new in sql and i was working in a database for my ojt. error logs are as follows...Server: Msg 8905, Level 16, State 1, Line 1Extent (1:247632) in database ID 10 is marked allocated in the GAM, but no SGAM or IAM has allocated it.Server: Msg 8905, Level 16, State 1, Line 1Extent (1:247648) in database ID 10 is marked allocated in the GAM, but no SGAM or IAM has allocated it.DBCC results for 'TRS'.CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.DBCC results for 'sysobjects'.There are 597 rows in 11 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 502 rows in 30 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 2749 rows in 57 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 462 rows in 179 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 18 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 14 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 6361 rows in 43 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 0 rows in 0 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'CategoryPromoGrid'.There are 0 rows in 0 pages for object 'CategoryPromoGrid'.DBCC results for 'ImExItemmaster'.There are 0 rows in 0 pages for object 'ImExItemmaster'.DBCC results for 'ImExSubCategories'.There are 0 rows in 0 pages for object 'ImExSubCategories'.DBCC results for 'ImExDepartments'.There are 0 rows in 0 pages for object 'ImExDepartments'.DBCC results for 'BuyXPriceN'.There are 2 rows in 1 pages for object 'BuyXPriceN'.DBCC results for 'ImExCategories'.There are 0 rows in 0 pages for object 'ImExCategories'.DBCC results for 'ImExBrands'.There are 0 rows in 0 pages for object 'ImExBrands'.DBCC results for 'DamagedGrid'.There are 16104 rows in 117 pages for object 'DamagedGrid'.DBCC results for 'ImExSupplierProduct'.There are 0 rows in 0 pages for object 'ImExSupplierProduct'.DBCC results for 'SupplierProductTemp'.There are 15605 rows in 132 pages for object 'SupplierProductTemp'.DBCC results for 'Customer'.There are 2 rows in 1 pages for object 'Customer'.DBCC results for 'WOBS'.There are 18 rows in 1 pages for object 'WOBS'.DBCC results for 'BORoom'.There are 97 rows in 9 pages for object 'BORoom'.DBCC results for 'SalesLoyalty'.There are 0 rows in 0 pages for object 'SalesLoyalty'.DBCC results for 'SalesLoyaltyTemp'.There are 0 rows in 0 pages for object 'SalesLoyaltyTemp'.DBCC results for 'ReturnItemsTemp'.There are 0 rows in 0 pages for object 'ReturnItemsTemp'.DBCC results for 'SalesCardTemp'.There are 0 rows in 0 pages for object 'SalesCardTemp'.DBCC results for 'SalesCouponTemp'.There are 0 rows in 0 pages for object 'SalesCouponTemp'.DBCC results for 'SalesGiftCheck'.There are 220 rows in 3 pages for object 'SalesGiftCheck'.DBCC results for 'SalesRef'.There are 25 rows in 1 pages for object 'SalesRef'.DBCC results for 'SalesCustomerTemp'.There are 0 rows in 0 pages for object 'SalesCustomerTemp'.DBCC results for 'Sales'.There are 1183606 rows in 15175 pages for object 'Sales'.DBCC results for 'SalesEPSTemp'.There are 0 rows in 0 pages for object 'SalesEPSTemp'.DBCC results for 'SalesGiftCheckTemp'.There are 0 rows in 0 pages for object 'SalesGiftCheckTemp'.DBCC results for 'SalesCard'.There are 18253 rows in 237 pages for object 'SalesCard'.DBCC results for 'SalesGridTemp'.There are 0 rows in 0 pages for object 'SalesGridTemp'.DBCC results for 'SalesCustomer'.There are 0 rows in 0 pages for object 'SalesCustomer'.DBCC results for 'Purchase'.There are 1990 rows in 29 pages for object 'Purchase'.DBCC results for 'SalesSeniorCitizenTemp'.There are 0 rows in 0 pages for object 'SalesSeniorCitizenTemp'.DBCC results for 'SalesEPS'.There are 1314 rows in 15 pages for object 'SalesEPS'.DBCC results for 'PurchaseGrid'.There are 50423 rows in 429 pages for object 'PurchaseGrid'.DBCC results for 'CancelTrx'.There are 15325 rows in 205 pages for object 'CancelTrx'.DBCC results for 'SalesStaffTemp'.There are 0 rows in 0 pages for object 'SalesStaffTemp'.DBCC results for 'SalesTemp'.There are 0 rows in 0 pages for object 'SalesTemp'.DBCC results for 'SalesSeniorCitizen'.There are 1319 rows in 8 pages for object 'SalesSeniorCitizen'.DBCC results for 'SalesTreasuryTemp'.There are 0 rows in 0 pages for object 'SalesTreasuryTemp'.DBCC results for 'SalesStaff'.There are 0 rows in 0 pages for object 'SalesStaff'.DBCC results for 'LoyaltyItems'.There are 1 rows in 1 pages for object 'LoyaltyItems'.DBCC results for 'CreditCards'.There are 5 rows in 1 pages for object 'CreditCards'.DBCC results for 'SalesVoidGridTemp'.There are 0 rows in 0 pages for object 'SalesVoidGridTemp'.DBCC results for 'SalesTreasury'.There are 34 rows in 1 pages for object 'SalesTreasury'.DBCC results for 'ItemMasterCAL'.There are 30945 rows in 487 pages for object 'ItemMasterCAL'.DBCC results for 'AppModule'.There are 39 rows in 1 pages for object 'AppModule'.DBCC results for 'NovSales'.There are 240381 rows in 760 pages for object 'NovSales'.DBCC results for 'SalesVoidTemp'.There are 0 rows in 0 pages for object 'SalesVoidTemp'.DBCC results for 'ImExMultipleFormula'.There are 0 rows in 0 pages for object 'ImExMultipleFormula'.DBCC results for 'Store'.There are 1 rows in 1 pages for object 'Store'.DBCC results for 'SalesVoid'.There are 42 rows in 1 pages for object 'SalesVoid'.DBCC results for 'HoldTrxGrid'.There are 23 rows in 1 pages for object 'HoldTrxGrid'.DBCC results for 'Banks'.There are 9 rows in 1 pages for object 'Banks'.DBCC results for 'ImExMultipleCosts'.There are 0 rows in 0 pages for object 'ImExMultipleCosts'.DBCC results for 'Departments'.There are 61 rows in 1 pages for object 'Departments'.DBCC results for 'StockCardTemp'.There are 0 rows in 0 pages for object 'StockCardTemp'.DBCC results for 'MultipleFormulaTemp'.There are 6055 rows in 91 pages for object 'MultipleFormulaTemp'.DBCC results for 'ImExPurchase'.There are 0 rows in 0 pages for object 'ImExPurchase'.DBCC results for 'Costs'.There are 82938 rows in 871 pages for object 'Costs'.DBCC results for 'MultipleCostsTemp'.There are 1261 rows in 16 pages for object 'MultipleCostsTemp'.DBCC results for 'CashOut'.There are 0 rows in 0 pages for object 'CashOut'.DBCC results for 'ImExPurchaseGrid'.There are 0 rows in 0 pages for object 'ImExPurchaseGrid'.DBCC results for 'CostsTemp'.There are 14485 rows in 151 pages for object 'CostsTemp'.DBCC results for 'MultipleCosts'.There are 85479 rows in 1047 pages for object 'MultipleCosts'.DBCC results for 'PurchaseGridTemp'.There are 0 rows in 0 pages for object 'PurchaseGridTemp'.DBCC results for 'ChangeFund'.There are 2994 rows in 19 pages for object 'ChangeFund'.DBCC results for 'CashCollSummary'.There are 2101 rows in 19 pages for object 'CashCollSummary'.DBCC results for 'MultipleFormula'.There are 81500 rows in 1208 pages for object 'MultipleFormula'.DBCC results for 'PurchaseTemp'.There are 0 rows in 0 pages for object 'PurchaseTemp'.DBCC results for 'RefNo'.There are 6 rows in 1 pages for object 'RefNo'.DBCC results for 'UsersTemp'.There are 0 rows in 0 pages for object 'UsersTemp'.DBCC results for 'TrxType'.There are 14 rows in 1 pages for object 'TrxType'.DBCC results for 'SalesBusinessClub'.There are 0 rows in 0 pages for object 'SalesBusinessClub'.DBCC results for 'StockTransferIn'.There are 7 rows in 1 pages for object 'StockTransferIn'.DBCC results for 'SalesBusinessClubTemp'.There are 0 rows in 0 pages for object 'SalesBusinessClubTemp'.DBCC results for 'Prices'.There are 82932 rows in 861 pages for object 'Prices'.DBCC results for 'LOCR'.There are 156 rows in 1 pages for object 'LOCR'.DBCC results for 'ValuePack'.There are 0 rows in 0 pages for object 'ValuePack'.DBCC results for 'PricesTemp'.There are 14485 rows in 149 pages for object 'PricesTemp'.DBCC results for 'ReturnItems'.There are 2207 rows in 40 pages for object 'ReturnItems'.DBCC results for 'ItemMasterTemp'.There are 14481 rows in 238 pages for object 'ItemMasterTemp'.DBCC results for 'Supplier'.There are 2434 rows in 47 pages for object 'Supplier'.DBCC results for 'Site'.There are 35 rows in 1 pages for object 'Site'.DBCC results for 'Position'.There are 13 rows in 1 pages for object 'Position'.DBCC results for 'ImExSupplier'.There are 0 rows in 0 pages for object 'ImExSupplier'.DBCC results for 'AppliedMargin'.There are 1638 rows in 7 pages for object 'AppliedMargin'.DBCC results for 'Staffs'.There are 2 rows in 1 pages for object 'Staffs'.DBCC results for 'Users'.There are 68 rows in 2 pages for object 'Users'.DBCC results for 'KVItem'.There are 163 rows in 2 pages for object 'KVItem'.DBCC results for 'ImExItemsFormula'.There are 0 rows in 0 pages for object 'ImExItemsFormula'.DBCC results for 'ItemsFormula'.There are 80260 rows in 1047 pages for object 'ItemsFormula'.DBCC results for 'SalesCoupon'.There are 0 rows in 0 pages for object 'SalesCoupon'.DBCC results for 'AppModuleRight'.There are 604 rows in 4 pages for object 'AppModuleRight'.DBCC results for 'StockCard'.There are 2590224 rows in 22129 pages for object 'StockCard'.DBCC results for 'ItemsFormulaTemp'.There are 14485 rows in 189 pages for object 'ItemsFormulaTemp'.DBCC results for 'TerminalSerials'.There are 12 rows in 1 pages for object 'TerminalSerials'.DBCC results for 'MainSupp'.There are 81951 rows in 387 pages for object 'MainSupp'.DBCC results for 'HoldTrx'.There are 4 rows in 4 pages for object 'HoldTrx'.DBCC results for 'ItemMaster'.There are 82930 rows in 1337 pages for object 'ItemMaster'.DBCC results for 'CashCollection'.There are 2101 rows in 27 pages for object 'CashCollection'.DBCC results for 'ImExItemPackage'.There are 0 rows in 0 pages for object 'ImExItemPackage'.DBCC results for 'StockTransferOutGrid'.There are 542 rows in 4 pages for object 'StockTransferOutGrid'.DBCC results for 'ItemPackageTemp'.There are 14485 rows in 82 pages for object 'ItemPackageTemp'.DBCC results for 'tblXProductCategory'.There are 360 rows in 3 pages for object 'tblXProductCategory'.DBCC results for 'ItemPackage'.There are 82880 rows in 477 pages for object 'ItemPackage'.DBCC results for 'SupplierProduct'.There are 78926 rows in 702 pages for object 'SupplierProduct'.DBCC results for 'Defaults'.There are 1 rows in 1 pages for object 'Defaults'.DBCC results for 'StockTransferInGrid'.There are 15 rows in 1 pages for object 'StockTransferInGrid'.DBCC results for 'CashCollection2'.There are 1611 rows in 21 pages for object 'CashCollection2'.DBCC results for 'Packaging'.There are 6 rows in 1 pages for object 'Packaging'.DBCC results for 'CashCollection3'.There are 718 rows in 10 pages for object 'CashCollection3'.DBCC results for 'CashCollection4'.There are 14 rows in 1 pages for object 'CashCollection4'.DBCC results for 'Inventory'.There are 218 rows in 2 pages for object 'Inventory'.DBCC results for 'StockTransferOut'.There are 162 rows in 3 pages for object 'StockTransferOut'.DBCC results for 'InventoryGrid'.There are 1050 rows in 7 pages for object 'InventoryGrid'.DBCC results for 'SalesGrid'.There are 6823537 rows in 88712 pages for object 'SalesGrid'.DBCC results for 'Delivery'.There are 1042 rows in 13 pages for object 'Delivery'.DBCC results for 'SalesVoidGrid'.There are 240 rows in 3 pages for object 'SalesVoidGrid'.DBCC results for 'ImExCosts'.There are 0 rows in 0 pages for object 'ImExCosts'.DBCC results for 'ClientDamaged'.There are 0 rows in 0 pages for object 'ClientDamaged'.DBCC results for 'DeliveryGrid'.There are 15595 rows in 191 pages for object 'DeliveryGrid'.DBCC results for 'ClientDamagedGrid'.There are 0 rows in 0 pages for object 'ClientDamagedGrid'.DBCC results for 'Categories'.There are 377 rows in 3 pages for object 'Categories'.DBCC results for 'DeliveredGrid'.There are 0 rows in 0 pages for object 'DeliveredGrid'.DBCC results for 'SubCategories'.There are 1970 rows in 15 pages for object 'SubCategories'.DBCC results for 'Delivered'.There are 0 rows in 0 pages for object 'Delivered'.DBCC results for 'Brands'.There are 2040 rows in 12 pages for object 'Brands'.DBCC results for 'Storage'.There are 2 rows in 1 pages for object 'Storage'.DBCC results for 'ClientPurchase'.There are 0 rows in 0 pages for object 'ClientPurchase'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'ClientPurchaseGrid'.There are 0 rows in 0 pages for object 'ClientPurchaseGrid'.DBCC results for 'SystemLog'.There are 5618 rows in 109 pages for object 'SystemLog'.DBCC results for 'RMreason'.There are 7 rows in 1 pages for object 'RMreason'.DBCC results for 'Results'.There are 135 rows in 2 pages for object 'Results'.DBCC results for 'Damaged'.There are 1813 rows in 21 pages for object 'Damaged'.DBCC results for 'PriceUpdate'.There are 38001 rows in 318 pages for object 'PriceUpdate'.DBCC results for 'LoyaltyParameter'.There are 1 rows in 1 pages for object 'LoyaltyParameter'.DBCC results for 'ImExPrices'.There are 0 rows in 0 pages for object 'ImExPrices'.DBCC results for 'CategoryPromo'.There are 0 rows in 0 pages for object 'CategoryPromo'.DBCC results for 'SKUPromo'.There are 0 rows in 0 pages for object 'SKUPromo'.CHECKDB found 2 allocation errors and 0 consistency errors in database 'TRS'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (TRS ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.im also having problems on how to switch it in a single user mode. ive tried to reindex it but allocation errors still show.All your help will be greatly appreciated!Thanks in advance! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-01 : 23:11:00
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114305 |
 |
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-02 : 03:27:18
|
| thanks for the link! ^_^ |
|
|
|
|
|
|
need help in allocation errors