I'm attempting to reindex a table in my database, but when I do, I receive the following error message
Can't allocate space for object in database STS because the default segment is full. If you run out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to expand the size of the segment.
My database is 500 MB, the log which is on a separate device is 125 MB. I don't (or at least didn't) think that the data contained within is already so much that there would not be space to reindex.
I tried reindexing on a particular index, which works, but when I do all, or the primary key index, it gives the above error. I tried dumping the transaction log, but that didn't make a difference.
My thoughts are to change the size of the database device, and then resize the database. Will that do it? I would think, as I said before, it already has enough space. Any thoughts?