[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1053
  • Last Modified:

'logsegment' segment is full.

I get an error from SQL server

Can't allocate space for object 'Syslogs' in database 'MyDB'
because the 'logsegment' 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.

How can I dump transaction log? I can't expand database space.
0
hansmtbank
Asked:
hansmtbank
1 Solution
 
Victor SpiridonovCommented:
You need to execute:
DUMP TRANSACTION mydb WITH TRUNCATE_ONLY or WITH NO_LOG
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now