Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Question Unanswered: Error 1105 When Using SQLMaint To Reindex Tables

    I have a standard reorganise/reindex job running against a 32GB database on SQl Srever 2000. When trying to run the job it fails and returns Error 1105 <'PRIMARY' filegroup is full>. What's confusing me is that I have 53GB free on the drive on which my Primary file group sits.

    Has anyone else come accross this problem when trying to set up a regular reindex job?

    (more detail) the maintenance plan only includes the reorganisation/reindex job, no other jobs - including backing up the DB - are included. The DB in question is the only DB on the server: it's a test server.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sounds like you've restricted the file growth size...go to the database properties and tell us what it's set to...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2004
    Posts
    2
    Brett,

    You were right, log size was being restricted. Funny how you miss the obvious stuff......

    Many Thanks

    Matthew

Posting Permissions

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