And we are having consistency errors in Indexes as well as in Tables also.

And we are having consistency errors in Indexes as well as in Tables also.

And we are having consistency errors in Indexes as well as Tables also.

There is approximate 500KB of output file and I habe tried to paste here but no luck.

total summery of output(DBCC CHECKDB) is the Database is having 85 consistency errors.

Unfortunately we dont have any backups with no consistency errors.

We keep only latest backups.

when i ran DBCC Checkdb(MDB) on the database found 85 consistency errors.

Output of the Checkdb is as...

Unfortunately the Good backup file has deleted, but we have the recent backup file. when i ran DBCC Checkdb on the database found 85 consistency errors.

We are facing this consistency...

Please help in this as this is a seviour issue.

Its SQL Server 2005

Can you please explain how you recovered from the issue ?

Raghavender Chavva

Thank you,

It worked for me.

Raghavender Chavva

Hi Deepak,

Thanks,

Raghavender Chavva

Thank you all for the response.

I have reinstalled the SQL Server and attached the user databases.

Raghavender Chavva

you can try below one if data types of all columns(col1,col2, ___) in old table are same and in new table column is in varchar:

"insert into testcon select convert(varchar(20),col1)+convert(varchar(20),col2)+convert(varchar(20),col3) from...

can you briefly explain actually what is your requirement ?

When I tried to Start the Services from Service Manager it is showing that "The specified services does nnot exist as an installed services."