Well reverting to the last good backup we be a loss of more than a weeks data. Gail said that running the checkdb with repair I could lose anywhere from...

Thanks Perry.

How important are these messages in the checkdb results?

The Index Allocation Map (IAM) page (3:443009) is pointed to by the next pointer of IAM page (3:46916) in object ID...

That is a good idea. I need to let them know the potential danger in keeping them in simple recovery.

Here is the last dbcc

Msg 8905, Level 16, State 1, Line...

I will try restoring the data from the backup after copying the current table to a temp table. The run a compare and try to sync the data. Will let...

This is a new job and i inherited this database which is in simple recovery restoring logs won't help. The checkdb on the backup i have is good.

Yes I do have a clean backup from right before the errors started. What do you suggest?

Yes I will do that. By the way If I:

--Copy the current(corrupt table) table data to a temp table to another db.

--Run repair_allow_data_loss on the db

--Run a compare with Not...

Wouldn't last nights backup have the same corruption? If so I would have to use one from a few days ago.

Would DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS fix the issue?

DBCC results for 'Marlin'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services analyzed: 3.

Service...

Thank you guys!

Chris..That worked great, thanks and thank all you guys for the input.

Thanks for the education. I will change the where clause and give it a try.

Sorry for the initial messy post.

I think you guys are right. I have tried writing the view without joins and the result set is never the same. I will look...

Will do thanks.

Now I need to change the data type of one of the destination (external)columns in the advanced editor but every time I change it it goes back to the original...