Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Post Unanswered: distribution log file size is reached upto 33GB

    Dear All participants.

    My distribution log file size is reached upto 33GB, What I should do?

    Any clue or helps are too appreciable.

    Thanks
    R.Mall

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    It depends.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Sep 2004
    Posts
    76
    I checked by distribution db so I found following errors -

    DBCC results for 'sysfilegroups'.
    Server: Msg 2511, Level 16, State 1, Line 1
    Table error: Object ID 69575286, Index ID 2. Keys out of order on page (1:8527), slots 137 and 138.
    There are 1 rows in 1 pages for object 'sysfilegroups'.

    Is there any solution for same

  4. #4
    Join Date
    Sep 2004
    Posts
    76

    Post Server: Msg 2511, Level 16, State 1, Line 1

    Hello guy ,

    I am receiving following msg at the time of dbcc.

    DBCC results for 'sysfilegroups'.
    Server: Msg 2511, Level 16, State 1, Line 1
    Table error: Object ID 69575286, Index ID 2. Keys out of order on page (1:8527), slots 137 and 138.
    There are 1 rows in 1 pages for object 'sysfilegroups'

    Let me helpout from above problem.

Posting Permissions

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