On Wed, 09 Apr 2008 06:13:09 GMT, changliw@online.microsoft.com (Charles
Wang[MSFT]) wrote:

> Hi Luc,
> I am interested in this issue. Would you mind letting me know the result of
> the suggestions? If you need further assistance, feel free to let me know.
> I will be more than happy to be of assistance.

Sorry for the delay.

REPAIR_REBUILD returns the same error as the other repair options, saying
one of the database files is read only.

Before that, I had also tried to rebuild the indexes on a freshly restored
copy of the database through SQL Server Management Studio, select each
index of the affected tables in turn in the object browser tree,
right-click and select Rebuild: that succeeded without any error message,
which I find even stranger.



But I had to give up on the issue, because the customer still hasn't
provided me with a copy of the original MDF after I asked them for the
second time (in fact, I haven't heard from them again).

If I've been informed correctly, the behavior of the original database is
not fully the same as that of the restored backup, so I see no point in
trying to fix such a restored backup.