Solved

Sybase syslogs error

Posted on 1997-10-10
4
513 Views
Last Modified: 2008-03-06
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
Comment
Question by:soares
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Accepted Solution

by:
mixalis101497 earned 0 total points
ID: 1098044
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
 

Author Comment

by:soares
ID: 1098045
I'm  so Sorry ...

Thanks
0
 
LVL 10

Expert Comment

by:bret
ID: 1098046
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
 

Author Comment

by:soares
ID: 1098047
I will try ...
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While it may be true that the internet is a place of possibilities, it is also a hostile environment lurking with many dangers. By clicking on the wrong link, trusting the wrong person or using a weak password, you are virtually inviting hackers to …
Adults who share images on social media aren’t the only ones who need to worry about their privacy. Our culture’s tendency to share every move and celebration affects the privacy of our children, too.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question