Results 1 to 2 of 2

Thread: Dbcc Checktable

  1. 09-03-2007, 06:41 PM #1
    rob71
    rob71 is offline Registered User
    Join Date
    Sep 2007
    Posts
    1

    Dbcc Checktable

    I have a database (150 Gb), this data base has corrupted tables, I ran the DBCC CHECKTABLE command, but this comand delays 50 hours (this table has 21 millions records).
    I know the table is very long, Is there something i can do to do it faster?
    Reply With Quote Reply With Quote
  2. 09-03-2007, 08:22 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Double check with 'sp_who2 active', maybe dbcc is blocked by other processes.
    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