Solved

Sybase syslogs error

Posted on 1997-10-10
4
510 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This tutorial shows how to create a greeting card by combining two image layers and a text layer on a PC using a free image editing app.
As a business owner, there are many things that keep you up at night. Profit margins, employee retention, human resource protocols, whether your product or service will remain competitive. When you own or manage a technology company that operates la…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

803 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