Solved

Sybase syslogs error

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
An analysis of the phishing scam that has been affecting Google users, along with steps to take for protection, as well as what to do if you receive one of the emails.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now