[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sybase syslogs error

Posted on 1997-10-10
4
Medium Priority
?
525 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

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.

Question has a verified solution.

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

Working from home is a dream for many people who aren’t happy about getting up early, going to the office, and spending long hours at work. There are lots of benefits of remote work for employees.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

650 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