| Author |
Topic |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2008-08-05 : 05:29:47
|
| helloI have a production system and in the past 2 or 3 weeks it has rebooted automatically so many times,and yesterday i got exception in the java applications that the database is inconsistent and when i run the dbbcc checkdb for the database it shows the three inconsistencies in one of the tables which i removed and migrated the database to another server but again found the same error. although i have removed the inconsistencies.PLEASE tell me the actual reason of inconsistencies and how to remove them completely.Thank u.....all. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-05 : 07:54:52
|
| moved from sql server administration (2000) forum because here the problem will be solved faster._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-08-06 : 14:33:57
|
quote:
Originally posted by steel
helloI have a production system and in the past 2 or 3 weeks it has rebooted automatically so many times
quote:
PLEASE tell me the actual reason of inconsistencies and how to remove them completely.
The answer to your question as to the reason of inconsistencies is in the first line of your post. What's causing the server to "rebooted automatically so many times"? Disk failures, spikes, OS issues? Until you get that resolved or move to a different server, no matter how many times you try to repair the database, potentially losing data, depending on how you're fixing the database, you'll continue to have these issues. Fix the root of the problem and then move forward. And be sure you have good, clean backups somewhere, if at all possible. One of these times you may not be able to "remove the inconsistencies" so you better have a good fallback plan.- Edit - And as Tara said, post the results of the DBCC CheckDB..Terry |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-08-07 : 00:00:16
|
| Hello all ,I am sending you people the errors which are there in the outputServer: Msg 8928, Level 16, State 1, Line 1Object ID 293576084, index ID 0: Page (1:91487) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 293576084, index ID 0, page (1:91487), row 0. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 98333 and 45.DBCC results for 'tbl_a_a'.There are 127302 rows in 1328 pages for object 'tbl_a_a'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'tbl_a_a' (object ID 293576084).==================DBCC results for 'radio.tbl_d_d'.There are 82996 rows in 555 pages for object 'radio.tbl_d_'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'radio.tbl_d_d' (object ID 1630628852). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-08-07 : 05:03:24
|
| the output of the querry is:DBCC results for 'radio'.DBCC results for 'sysobjects'.There are 291 rows in 6 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 513 rows in 20 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 1365 rows in 20 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 208 rows in 41 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 4 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 52 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 1292 rows in 6 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 'tbl_fm_subscription_log'.There are 1409886 rows in 15176 pages for object 'tbl_fm_subscription_log'.DBCC results for 'radio.song_details_check'.There are 313 rows in 4 pages for object 'radio.song_details_check'.DBCC results for 'tbl_invalid_numbers'.There are 16427 rows in 86 pages for object 'tbl_invalid_numbers'.DBCC results for 'tbl_myzone'.There are 53992 rows in 640 pages for object 'tbl_myzone'.DBCC results for 'radio.tbl_fm_chk_subscription'.There are 967731 rows in 4659 pages for object 'radio.tbl_fm_chk_subscription'.DBCC results for 'tbl_myzone_history'.There are 20475 rows in 263 pages for object 'tbl_myzone_history'.DBCC results for 'radio.tbl_free_minutes'.There are 787640 rows in 4930 pages for object 'radio.tbl_free_minutes'.DBCC results for 'tbl_preference_album'.There are 0 rows in 1 pages for object 'tbl_preference_album'.DBCC results for 'radio.match_count_check_sidhesh'.There are 1617265 rows in 4829 pages for object 'radio.match_count_check_sidhesh'.DBCC results for 'tbl_preference_artist'.There are 0 rows in 1 pages for object 'tbl_preference_artist'.DBCC results for 'radio.tbl_ams_calllog_summary'.There are 217 rows in 9 pages for object 'radio.tbl_ams_calllog_summary'.DBCC results for 'tbl_preference_category'.There are 1025371 rows in 5772 pages for object 'tbl_preference_category'.DBCC results for 'radio.tbl_hbo_details'.There are 45191 rows in 244 pages for object 'radio.tbl_hbo_details'.DBCC results for 'tbl_preference_genre'.There are 0 rows in 1 pages for object 'tbl_preference_genre'.DBCC results for 'radio.tbl_hbo_backup'.There are 6991 rows in 24 pages for object 'radio.tbl_hbo_backup'.DBCC results for 'tbl_ringtone_download'.There are 0 rows in 0 pages for object 'tbl_ringtone_download'.DBCC results for 'radio.tbl_hbo_sub'.There are 351811 rows in 1228 pages for object 'radio.tbl_hbo_sub'.DBCC results for 'tbl_running_categories'.There are 0 rows in 0 pages for object 'tbl_running_categories'.DBCC results for 'tbl_sms'.There are 6 rows in 1 pages for object 'tbl_sms'.DBCC results for 'radio.tbl_hbo_dummy'.There are 6000 rows in 28 pages for object 'radio.tbl_hbo_dummy'.DBCC results for 'tbl_song_dedication'.There are 0 rows in 0 pages for object 'tbl_song_dedication'.DBCC results for 'radio.TBL_NEW_USR_LOGGING'.There are 164464 rows in 661 pages for object 'radio.TBL_NEW_USR_LOGGING'.DBCC results for 'tbl_song_logs'.There are 0 rows in 1 pages for object 'tbl_song_logs'.DBCC results for 'radio.match_count_check_one97'.There are 31522 rows in 95 pages for object 'radio.match_count_check_one97'.DBCC results for 'tbl_song_logs_deleted'.There are 0 rows in 0 pages for object 'tbl_song_logs_deleted'.DBCC results for 'radio.TBL_UNSUB_LOWBALANCE'.There are 44 rows in 1 pages for object 'radio.TBL_UNSUB_LOWBALANCE'.DBCC results for 'tbl_song_logs_today'.There are 0 rows in 0 pages for object 'tbl_song_logs_today'.DBCC results for 'radio.TBL_Comedy_Log'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 293576084, index ID 0: Page (1:91487) could not be processed. See other errors for details.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 293576084, index ID 0, page (1:91487), row 0. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 98333 and 45.There are 73861 rows in 1114 pages for object 'radio.TBL_Comedy_Log'.DBCC results for 'tbl_time_zone'.There are 0 rows in 0 pages for object 'tbl_time_zone'.DBCC results for 'tbl_user_balance'.There are 127302 rows in 1328 pages for object 'tbl_user_balance'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'tbl_user_balance' (object ID 293576084).DBCC results for 'tbl_valid_mseries'.There are 4 rows in 1 pages for object 'tbl_valid_mseries'.DBCC results for 'test'.There are 0 rows in 0 pages for object 'test'.DBCC results for 'radio.mou_dummay'.There are 5505 rows in 17 pages for object 'radio.mou_dummay'.DBCC results for 'tbl_user_balance_aug2'.There are 0 rows in 0 pages for object 'tbl_user_balance_aug2'.DBCC results for 'tbl_user_balance_correct'.There are 0 rows in 0 pages for object 'tbl_user_balance_correct'.DBCC results for 'radio.tbl_user_balance_aug2'.There are 13037 rows in 53 pages for object 'radio.tbl_user_balance_aug2'.DBCC results for 'radio.tbl_cbs_reqs_success'.There are 0 rows in 0 pages for object 'radio.tbl_cbs_reqs_success'.DBCC results for 'radio.tbl_billing_events_log'.There are 3745892 rows in 43319 pages for object 'radio.tbl_billing_events_log'.DBCC results for 'radio.tbl_cbs_reqs_failure'.There are 1173 rows in 13 pages for object 'radio.tbl_cbs_reqs_failure'.DBCC results for 'radio.tbl_fm_callLog_summary'.There are 401 rows in 10 pages for object 'radio.tbl_fm_callLog_summary'.DBCC results for 'radio.tbl_fm_summary'.There are 401 rows in 12 pages for object 'radio.tbl_fm_summary'.DBCC results for 'radio.tbl_fm_revenue'.There are 401 rows in 10 pages for object 'radio.tbl_fm_revenue'.DBCC results for 'tbl_fm_exposure'.There are 47438 rows in 448 pages for object 'tbl_fm_exposure'.DBCC results for 'radio.tbl_cbs_reqs_log'.There are 3046859 rows in 59989 pages for object 'radio.tbl_cbs_reqs_log'.DBCC results for 'radio.tbl_cbs_reqs'.There are 11713 rows in 91 pages for object 'radio.tbl_cbs_reqs'.DBCC results for 'radio.tbl_cbs_reconcilation'.There are 10646 rows in 85 pages for object 'radio.tbl_cbs_reconcilation'.DBCC results for 'tbl_user_balance_logs'.There are 1075674 rows in 5722 pages for object 'tbl_user_balance_logs'.DBCC results for 'radio.tbl_content_details_retry'.There are 607 rows in 9 pages for object 'radio.tbl_content_details_retry'.DBCC results for 'radio.tbl_fm_promo_logging'.There are 55627 rows in 768 pages for object 'radio.tbl_fm_promo_logging'.DBCC results for 'tbl_fm_ringtones_retry'.There are 18638 rows in 648 pages for object 'tbl_fm_ringtones_retry'.DBCC results for 'radio.tbl_fm_exposure'.There are 861 rows in 9 pages for object 'radio.tbl_fm_exposure'.DBCC results for 'radio.tbl_billing_events_failure'.There are 36 rows in 1 pages for object 'radio.tbl_billing_events_failure'.DBCC results for 'radio.tbl_bill_events_apr'.There are 79452 rows in 704 pages for object 'radio.tbl_bill_events_apr'.DBCC results for 'radio.tbl_sawariya_song_log'.There are 1386 rows in 9 pages for object 'radio.tbl_sawariya_song_log'.DBCC results for 'radio.tbl_ams_circleSummary'.There are 1 rows in 1 pages for object 'radio.tbl_ams_circleSummary'.DBCC results for 'radio.TBL_543213'.There are 25623 rows in 244 pages for object 'radio.TBL_543213'.DBCC results for 'radio.tbl_ams_download_summary'.There are 317 rows in 8 pages for object 'radio.tbl_ams_download_summary'.DBCC results for 'radio.TBL_57777'.There are 37249 rows in 349 pages for object 'radio.TBL_57777'.DBCC results for 'radio.tbl_ams_topup_summary'.There are 317 rows in 8 pages for object 'radio.tbl_ams_topup_summary'.DBCC results for 'radio.tbl_callrate_MIS'.There are 9384 rows in 86 pages for object 'radio.tbl_callrate_MIS'.DBCC results for 'radio.tbl_ams_general_summary'.There are 317 rows in 9 pages for object 'radio.tbl_ams_general_summary'.DBCC results for 'radio.data_dummy'.There are 14529 rows in 44 pages for object 'radio.data_dummy'.DBCC results for 'radio.tbl_ams_usage_pattern'.There are 317 rows in 9 pages for object 'radio.tbl_ams_usage_pattern'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'radio.tbl_circle_data'.There are 0 rows in 0 pages for object 'radio.tbl_circle_data'.DBCC results for 'tbl_fm_subscription_new'.There are 0 rows in 1 pages for object 'tbl_fm_subscription_new'.DBCC results for 'radio.tbl_HT_Requests_log'.There are 0 rows in 0 pages for object 'radio.tbl_HT_Requests_log'.DBCC results for 'tbl_fm_subscription_backup'.There are 7694 rows in 61 pages for object 'tbl_fm_subscription_backup'.DBCC results for 'radio.tbl_fm_count_subtop'.There are 47153 rows in 324 pages for object 'radio.tbl_fm_count_subtop'.DBCC results for 'radio.tbl_circle_data4'.There are 18680 rows in 141 pages for object 'radio.tbl_circle_data4'.DBCC results for 'radio.tbl_fm_count_subtop_log'.There are 0 rows in 0 pages for object 'radio.tbl_fm_count_subtop_log'.DBCC results for 'radio.dummyfm_subscription'.There are 922 rows in 7 pages for object 'radio.dummyfm_subscription'.DBCC results for 'radio.tbl_cbs_requests'.There are 331990 rows in 1209 pages for object 'radio.tbl_cbs_requests'.DBCC results for 'radio.tbl_pending_reconcile'.There are 440 rows in 5 pages for object 'radio.tbl_pending_reconcile'.DBCC results for 'radio.tbl_cbs_requests_duplicate'.There are 0 rows in 0 pages for object 'radio.tbl_cbs_requests_duplicate'.DBCC results for 'radio.tbl_mode_of_sub'.There are 77 rows in 2 pages for object 'radio.tbl_mode_of_sub'.DBCC results for 'radio.tbl_FM_SONGLOG'.There are 11435 rows in 511 pages for object 'radio.tbl_FM_SONGLOG'.DBCC results for 'radio.tbl_hbo_sub_MAPP'.There are 10430 rows in 37 pages for object 'radio.tbl_hbo_sub_MAPP'.DBCC results for 'radio.tbl_OmShantiOM_song_log'.There are 696 rows in 6 pages for object 'radio.tbl_OmShantiOM_song_log'.DBCC results for 'radio.tbl_handset_model'.There are 77319 rows in 961 pages for object 'radio.tbl_handset_model'.DBCC results for 'radio.tbl_BBB_song_log'.There are 1834 rows in 12 pages for object 'radio.tbl_BBB_song_log'.DBCC results for 'radio.tbl_fm_newringtones'.There are 18234 rows in 870 pages for object 'radio.tbl_fm_newringtones'.DBCC results for 'radio.tbl_temp_ani'.There are 6545 rows in 20 pages for object 'radio.tbl_temp_ani'.DBCC results for 'radio.dummy_ringtone'.There are 11951 rows in 796 pages for object 'radio.dummy_ringtone'.DBCC results for 'radio.tbl_dedication_check'.There are 0 rows in 8 pages for object 'radio.tbl_dedication_check'.DBCC results for 'tbl_content_details_duplicate'.There are 0 rows in 1 pages for object 'tbl_content_details_duplicate'.DBCC results for 'radio.tbl_dedication_check_log'.There are 1062 rows in 26 pages for object 'radio.tbl_dedication_check_log'.DBCC results for 'tbl_content_details'.There are 10911 rows in 122 pages for object 'tbl_content_details'.DBCC results for 'radio.TBL_Comedy_Content'.There are 1810 rows in 26 pages for object 'radio.TBL_Comedy_Content'.DBCC results for 'radio.tbl_FM_SONGLOG_BACKUP'.There are 93419 rows in 1235 pages for object 'radio.tbl_FM_SONGLOG_BACKUP'.DBCC results for 'radio.TBL_AMS_MIS_REPORTS'.There are 106034 rows in 2590 pages for object 'radio.TBL_AMS_MIS_REPORTS'.DBCC results for 'radio.tbl_retailsub_pin'.There are 51337 rows in 274 pages for object 'radio.tbl_retailsub_pin'.DBCC results for 'radio.TBL_B_RATING'.There are 88219 rows in 592 pages for object 'radio.TBL_B_RATING'.DBCC results for 'radio.tbl_retailsub_detail'.There are 12 rows in 1 pages for object 'radio.tbl_retailsub_detail'.DBCC results for 'radio.TBL_P_RATING'.There are 1437 rows in 15 pages for object 'radio.TBL_P_RATING'.DBCC results for 'radio.TBL_E_RATING'.There are 8498 rows in 64 pages for object 'radio.TBL_E_RATING'.DBCC results for 'radio.TBL_HR_RATING'.There are 134 rows in 2 pages for object 'radio.TBL_HR_RATING'.DBCC results for 'tbl_fm_ringtones'.There are 21507 rows in 1155 pages for object 'tbl_fm_ringtones'.DBCC results for 'radio.tbl_HT_Requests'.There are 1838 rows in 28 pages for object 'radio.tbl_HT_Requests'.DBCC results for 'radio.TBL_R_RATING'.There are 243 rows in 8 pages for object 'radio.TBL_R_RATING'.DBCC results for 'radio.tbl_fsd_Requests'.There are 360 rows in 5 pages for object 'radio.tbl_fsd_Requests'.DBCC results for 'radio.TBL_T_RATING'.There are 1281 rows in 12 pages for object 'radio.TBL_T_RATING'.DBCC results for 'radio.TBL_TG_RATING'.There are 739 rows in 11 pages for object 'radio.TBL_TG_RATING'.DBCC results for 'radio.tbl_optin_details'.There are 12210 rows in 52 pages for object 'radio.tbl_optin_details'.DBCC results for 'radio.TBL_M_RATING'.There are 766 rows in 10 pages for object 'radio.TBL_M_RATING'.DBCC results for 'radio.TBL_K_RATING'.There are 465 rows in 10 pages for object 'radio.TBL_K_RATING'.DBCC results for 'radio.TBL_KS_RATING'.There are 355 rows in 9 pages for object 'radio.TBL_KS_RATING'.DBCC results for 'radio.tbl_categories'.There are 21 rows in 1 pages for object 'radio.tbl_categories'.DBCC results for 'radio.TBL_BN_RATING'.There are 44824 rows in 309 pages for object 'radio.TBL_BN_RATING'.DBCC results for 'radio.tbl_ht'.There are 7452 rows in 87 pages for object 'radio.tbl_ht'.DBCC results for 'radio.TBL_C_RATING'.There are 2269 rows in 20 pages for object 'radio.TBL_C_RATING'.DBCC results for 'radio.tbl_fsd'.There are 435 rows in 17 pages for object 'radio.tbl_fsd'.DBCC results for 'radio.TBL_HP_RATING'.There are 0 rows in 0 pages for object 'radio.TBL_HP_RATING'.DBCC results for 'radio.TBL_DG_RATING'.There are 0 rows in 0 pages for object 'radio.TBL_DG_RATING'.DBCC results for 'radio.TBL_Comedy_Content_retry'.There are 0 rows in 0 pages for object 'radio.TBL_Comedy_Content_retry'.DBCC results for 'radio.TBL_MT_RATING'.There are 547 rows in 10 pages for object 'radio.TBL_MT_RATING'.DBCC results for 'radio.tbl_ams_charging_plan'.There are 1 rows in 1 pages for object 'radio.tbl_ams_charging_plan'.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1630628852, Index ID 3. Keys out of order on page (1:290231), slots 159 and 160.DBCC results for 'radio.TBL_OR_RATING'.There are 5484 rows in 42 pages for object 'radio.TBL_OR_RATING'.DBCC results for 'radio.tbl_ded_viral'.There are 82996 rows in 555 pages for object 'radio.tbl_ded_viral'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'radio.tbl_ded_viral' (object ID 1630628852).DBCC results for 'radio.TBL_BJ_RATING'.There are 9552 rows in 66 pages for object 'radio.TBL_BJ_RATING'.DBCC results for 'radio.TBL_GJ_RATING'.There are 587 rows in 10 pages for object 'radio.TBL_GJ_RATING'.DBCC results for 'radio.tbl_ams_charging_plan_ringtone'.There are 0 rows in 0 pages for object 'radio.tbl_ams_charging_plan_ringtone'.DBCC results for 'radio.TBL_AM_RATING'.There are 1886 rows in 15 pages for object 'radio.TBL_AM_RATING'.DBCC results for 'radio.tbl_rng_viral'.There are 0 rows in 0 pages for object 'radio.tbl_rng_viral'.DBCC results for 'radio.tbl_rng_viral_backUp_23_June_2008'.There are 7914 rows in 51 pages for object 'radio.tbl_rng_viral_backUp_23_June_2008'.DBCC results for 'tbl_fm_cci_log'.There are 2167 rows in 25 pages for object 'tbl_fm_cci_log'.DBCC results for 'radio.tbl_singhisking_log'.There are 852 rows in 7 pages for object 'radio.tbl_singhisking_log'.DBCC results for 'tbl_fmradio_user'.There are 1 rows in 1 pages for object 'tbl_fmradio_user'.DBCC results for 'tbl_fmradio_user_logindetails'.There are 134767 rows in 682 pages for object 'tbl_fmradio_user_logindetails'.DBCC results for 'radio.tbl_ams_topup_summary_backup'.There are 102 rows in 1 pages for object 'radio.tbl_ams_topup_summary_backup'.DBCC results for 'radio.tbl_ring_obd_log'.There are 145 rows in 8 pages for object 'radio.tbl_ring_obd_log'.DBCC results for 'radio.TBL_TOPUPQUIZ_HISTORY'.There are 3798 rows in 22 pages for object 'radio.TBL_TOPUPQUIZ_HISTORY'.DBCC results for 'radio.tbl_FM_migration'.There are 1705 rows in 9 pages for object 'radio.tbl_FM_migration'.DBCC results for 'radio.MM_CHECK'.There are 1815 rows in 6 pages for object 'radio.MM_CHECK'.DBCC results for 'radio.tbl_wave_files'.There are 66970 rows in 405 pages for object 'radio.tbl_wave_files'.DBCC results for 'radio.tbl_ring_obd_dummy'.There are 10814 rows in 43 pages for object 'radio.tbl_ring_obd_dummy'.DBCC results for 'radio.tbl_ring_obd'.There are 21825 rows in 128 pages for object 'radio.tbl_ring_obd'.DBCC results for 'radio.tbl_bulk_activation'.There are 11 rows in 17 pages for object 'radio.tbl_bulk_activation'.DBCC results for 'radio.tbl_bulk_deactivation'.There are 353 rows in 9 pages for object 'radio.tbl_bulk_deactivation'.DBCC results for 'radio.tbl_fm_callLog_bulk'.There are 0 rows in 0 pages for object 'radio.tbl_fm_callLog_bulk'.DBCC results for 'radio.tbl_fm_sub_cellebrum_log'.There are 187794 rows in 1643 pages for object 'radio.tbl_fm_sub_cellebrum_log'.DBCC results for 'TBL_FM_SUBSCRIPTION_RETRY'.There are 195290 rows in 1330 pages for object 'TBL_FM_SUBSCRIPTION_RETRY'.DBCC results for 'radio.MM_CHECK302010'.There are 2401 rows in 8 pages for object 'radio.MM_CHECK302010'.DBCC results for 'radio.song_details'.There are 22006 rows in 278 pages for object 'radio.song_details'.DBCC results for 'radio.tbl_fmfile_log'.There are 200072 rows in 1457 pages for object 'radio.tbl_fmfile_log'.DBCC results for 'TBL_RING_DOWNLOAD'.There are 13194 rows in 102 pages for object 'TBL_RING_DOWNLOAD'.DBCC results for 'radio.tbl_resub_events'.There are 21159 rows in 279 pages for object 'radio.tbl_resub_events'.DBCC results for 'tbl_billing_events'.There are 961662 rows in 10889 pages for object 'tbl_billing_events'.DBCC results for 'radio.tbl_fm_callLog'.There are 5677919 rows in 48796 pages for object 'radio.tbl_fm_callLog'.DBCC results for 'radio.song_details_retry'.There are 4375 rows in 61 pages for object 'radio.song_details_retry'.DBCC results for 'radio.TBL_CONTENT_PROPERTIES'.There are 0 rows in 0 pages for object 'radio.TBL_CONTENT_PROPERTIES'.DBCC results for 'radio.tbl_reconcile'.There are 88365 rows in 1169 pages for object 'radio.tbl_reconcile'.DBCC results for 'tbl_fm_daily_revenue'.There are 0 rows in 0 pages for object 'tbl_fm_daily_revenue'.DBCC results for 'radio.tbl_pending_reco'.There are 753 rows in 8 pages for object 'radio.tbl_pending_reco'.DBCC results for 'tbl_fm_daily_summary'.There are 0 rows in 0 pages for object 'tbl_fm_daily_summary'.DBCC results for 'tbl_fm_dedication'.There are 5670 rows in 90 pages for object 'tbl_fm_dedication'.DBCC results for 'radio.tbl_freedom_offer'.There are 1 rows in 1 pages for object 'radio.tbl_freedom_offer'.DBCC results for 'tbl_fm_subscription'.There are 127452 rows in 1884 pages for object 'tbl_fm_subscription'.CHECKDB found 0 allocation errors and 3 consistency errors in database 'radio'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (radio ).DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-08-10 : 01:05:15
|
| hello all,No one is replying,i am in trouble ......... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-10 : 02:05:49
|
| Unfortunately, our subscriptions are disabled, so Paul isn't getting emails that posts are being made in this forum. You could try opening a case with Microsoft or see if you can contact Paul on his web site.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-08-12 : 20:12:40
|
| Preliminary CheckFrom MSDN :Msg 8928ExplanationPage P_ID was marked allocated in a PFS page (and therefore should be readable), but reading the page failed. The reason is given in accompanying error messages.Msg 8944Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)VAL1 is the offset of the end of the variable column offset array (lhs of expression).VAL2 is the size of the record (rhs of expression). Seems like the offset value exceeds the calculated record size.Please sends the DBCC PAGE of particular page for further detail checkMsg 2511The two slots specified are in the wrong order, according to a comparison of their keys.Please sends the DBCC PAGE of particular page for further detail checkRgdsEka S.Here is a thing about the future : every time you look at it, it changes. Because you look at it, that changes everything else.-Frank Cadillac in NEXT |
|
|
|
|
urgent: inconsistency in the database