Hi Naomi. Thanks for replying.
I ended up here stopping and Restarting SQL SErver and this got rif og the problem.

Is there any Reindex or FOXFIX type products for SQL SErver, in case it happens again

Regards,
Gerard


>>Hi.
>>I am getting following error in SQL SERVER EXPRESS
>>Attempt to fetch logial page(1:3142) in databse 5 failed...It belongs to allocation unit 0
>> not to 123456789
>>
>>If I use SSMS , and retrive record, it gives message after about 30,000 and there ae lots more records on file
>>Anybody know what this is or how to fix
>>Regards,
>>Gerard
>
>Do you have a full backup of the database? I didn't search on this error, but it sounds like you may need to restore your data from the backup.