Results 1 to 8 of 8

Thread: Urgent!!

  1. 05-29-2003, 04:22 PM #1
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123

    Urgent!!

    I ran a DBCC CheckDB & got some errors saying the following:

    Server: Msg 8905, Level 16, State 1, Line 1
    Extent (1:54752) in database ID 64 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    I found this article :
    http://support.microsoft.com/default...b;en-us;278366

    Will just running a dbcc checkDB with repair take care of this? What about any loss of data? Does Extent (1:54752) mean anything regarding which table might have this problem??

    Thanks!
    Reply With Quote Reply With Quote
  2. 05-29-2003, 05:39 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Make backup then run dbcc to repair.
    Reply With Quote Reply With Quote
  3. 05-29-2003, 07:02 PM #3
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    i did... the output said it repaired all errors...
    is there anything else I should run ?

    Thanks !!!
    Reply With Quote Reply With Quote
  4. 05-29-2003, 09:05 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Do db full bckup so you have a healthy one in case need restore.
    Reply With Quote Reply With Quote
  5. 05-30-2003, 08:23 AM #5
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    Yes, I had done that too..thank for all
    your help!
    Reply With Quote Reply With Quote
  6. 05-30-2003, 09:30 AM #6
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123

    New problem!!

    I have a maintenance job set up to do Integrity checks on the database. That job generally rins for 10 secs... now it is running for like 5 hrs...
    however if i run a dbcc checkdb i get no errors reported. Isnt the iNtegrity check job doing the same thing?

    This is running on sql 7.0 sp 3...

    Thanks!
    Reply With Quote Reply With Quote
  7. 05-30-2003, 01:46 PM #7
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check plan log file to see which step takes so long time, and ensure you don't have blocking issue on the db.
    Reply With Quote Reply With Quote
  8. 05-30-2003, 02:12 PM #8
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    I dropped the job & recreated it. & it ran fine.

    Thanks!
    Have a good weekend everbody !
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules