tran log dump error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Socrates - 28 Jul 2008 17:29 GMT

hi,
i'm trying to dump my tran logs and get the following error:

Server: Msg 8968, Level 16, State 10, Line 1
Table error: IAM page (6:258638) (object ID 2, index ID 255) is out of the
range of this database.

Reply to this Message

Kevin3NF - 28 Jul 2008 18:18 GMT

Run DBCC CHeckDB on the database you are trynig to backup/dump

Signature

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

> hi,
> i'm trying to dump my tran logs and get the following error:
>
> Server: Msg 8968, Level 16, State 10, Line 1
> Table error: IAM page (6:258638) (object ID 2, index ID 255) is out of the
> range of this database.

Reply to this Message

Socrates - 28 Jul 2008 19:38 GMT

I ran DBCC CHECKDB on the databases with 0 errors.

> Run DBCC CHeckDB on the database you are trynig to backup/dump
>
[quoted text clipped - 4 lines]
> > Table error: IAM page (6:258638) (object ID 2, index ID 255) is out of the
> > range of this database.

Reply to this Message

Kevin3NF - 29 Jul 2008 13:42 GMT

Odd. This typically indicates corruption:

http://msdn.microsoft.com/en-us/library/aa238190(SQL.80).aspx

Did you run it on the correct db?

Use YourDB
Go

DBCC CheckDB

Signature

>I ran DBCC CHECKDB on the databases with 0 errors.
>
[quoted text clipped - 7 lines]
>> > the
>> > range of this database.

Reply to this Message