>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.
If it's not broken, fix it until it is.
My Blog