Learn how to a build a cloud-first strategyRegister Now

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

Sybase syslogs error

I can't execute Dump Transaction anymore , only dump database. When I execute a Dump Transaction appears following error: Syslogs does not exists in its own segment in database (1632)

Thanks
0
soares
Asked:
soares
  • 2
1 Solution
 
mixalis101497Commented:
The database you are trying to dump its transaction log, has a problem with its logsegment. You have to recreate the database.
Try:
  use db
  go
  sp_helpdb db
  go

You must see logsegment associated with a specific device.

0
 
soaresAuthor Commented:
I'm  so Sorry ...

Thanks
0
 
bretCommented:
It is not necessary to recreate the database.  One of two things
has happened.  Either

a) You have recently extended the database and ended up with a
mixed-segment fragment in sysusages (the segmap will probably be
"7"), in which case you should drop the logsegment from that device and procede to part b)

b) You have recently dropped the log segment from a fragment
while that fragment contained part of the log.  Dropping the segment does not move the pages allocated on that fragment.
You should, however, be able to issue "dump tran <db> with truncate_only" to deallocate those records.  Follow up with a full database dump and you should then be able to resume dumping the tran log to file for recovery purposes.

-bret
0
 
soaresAuthor Commented:
I will try ...
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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