Member_2_220651
asked on
-ve max. size ?
i want to expand the size of a database device, however, it doesn't work and i discovered that the max. size available is negative. Do you know why?
Before that, an error has occurred. the message is :
Can't allocate space for object "Syslog" in database "Netstat" because the "logsegment" segment is full.
Before that, an error has occurred. the message is :
Can't allocate space for object "Syslog" in database "Netstat" because the "logsegment" segment is full.
ASKER
Already done but still cannot expand the size of database device.
is it still giving you "logsegment full" messages ?
ASKER
Yes.
Was the DUMP transaction executed succesefully ? Have you run dbcc checktable syslogs ? if yes right-click on datavase in Sql Enterprise manager 'Server manager' window and choose edit -what does it show for log? Click on 'Truncate' and 'Recalculate'.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DBCC checktable syslogs command.