Delete records from spt_committab to create space in Master database. v 11.0.2 Get message
- Can't allocate space for object 'syslogs' in database 'master' because the 'system' segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
When I try to do add a device to increase master I get the above msg again followed by.
- No space left in database master; creating user objects in master database not recommended. Else, an old transaction may be active; see Syslogshold table.
The table spt_committab is very large. Is it ok to delete some of the reords from this table?