Thank you so much.

This is the third time it did it. Orginally the database worked fine for 2 days and then corrupted.

Also I am getting the following error in the...

It is fine in Source server. The command doesnt give any errors.

All queries run perfect

Here is the dbcc checkdb

Msg 8928, Level 16, State 1, Line 1

Object ID 343672272, index ID 0, partition ID 72057594067484672, alloc unit ID 72057594193772544 (type In-row data): Page (1:9270) could...

Sorry Sql server 2005

Both are identical versions. When we did backup and restore I think it didnt move the views and stored proc.

Thanks for your help