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.Sounds like you've restricted the file growth size...go to the database properties and tell us what it's set to...|||Brett,
You were right, log size was being restricted. Funny how you miss the obvious stuff.....
Many Thanks
Matthew
Showing posts with label reorganise. Show all posts
Showing posts with label reorganise. Show all posts
Subscribe to:
Posts (Atom)