Link to home
Start Free TrialLog in
Avatar of Member_2_220651
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.

 
Avatar of Victor Spiridonov
Victor Spiridonov
Flag of Russian Federation image

first of all dump your transaction log and run
DBCC checktable syslogs command.
Avatar of Member_2_220651
Member_2_220651

ASKER

Already done but still cannot expand the size of database device.
is it still giving you "logsegment full" messages ?
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
Avatar of Ezhil
Ezhil

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial