-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.

 
yyjulieAsked:
Who is Participating?
 
EzhilConnect With a Mentor Commented:
Instead of expanding the DB device , Add one more DB device your DB.

Double click your DB, click expand , In Data & log Device select <New> and add these devices to your DB.


0
 
Victor SpiridonovCommented:
first of all dump your transaction log and run
DBCC checktable syslogs command.
0
 
yyjulieAuthor Commented:
Already done but still cannot expand the size of database device.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Victor SpiridonovCommented:
is it still giving you "logsegment full" messages ?
0
 
yyjulieAuthor Commented:
Yes.
0
 
Victor SpiridonovCommented:
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'.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.