Hi,

Unfortunately we don't have a clean backup.

I've tried to perform checkDB with repair_allow_data_loss, but error messages were returned.

-- Alina

Hi,

Thank you for your suggestions. Here is what I have tried to do:

1) Try dropping and recreate the nonclustered index (ID 3) on MultiSpuEndpointProperties table

I used the following:

USE Test_DataCorrupt

GO

CREATE NONCLUSTERED...

Hello,

I have for example this table:

CREATE TABLE #Salary

( EmployeeId INT ,

WeekEndingDate DATETIME,

...

hi,

here is the table

CREATE TABLE #Salary

( EmployeeId INT ,

WeekEndingDate DATETIME,

Days...