How do I repair a corrupted table

7 Dec 2005 4:23 PM

POP3.demon.co.uk

We are using a third party erp system that uses MSSQL

We have over the years created additional tables.

One of these 'bespoke' tables appears to be corrupted and I am stuffed!

I cannot access it using the select statement, or even via MS Access (ODBC
call failure).

Can someone advise me on how I may be able to repair/recover it (restoring
the whole database is not an option unless I am contemplating a career move)

Tony

8 Dec 2005 12:41 AM

Andrew J. Kelly

Why is restoring the entire db an issue? If you have proper backups you can
potentially restore and not loose any transactions. In any case if you have
corruption and restoring is not an option you are best to give PSS a call
and let them work directly with you. It will cost about $225 but they will
help you get the most recovered.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS

--
Andrew J. Kelly SQL MVP

Show quote

"POP3.demon.co.uk" <t***@burgessfurniture.com> wrote in message
news:dn72c1$kud$1$8300dec7@news.demon.co.uk...
> We are using a third party erp system that uses MSSQL
>
> We have over the years created additional tables.
>
> One of these 'bespoke' tables appears to be corrupted and I am stuffed!
>
> I cannot access it using the select statement, or even via MS Access (ODBC
> call failure).
>
> Can someone advise me on how I may be able to repair/recover it (restoring
> the whole database is not an option unless I am contemplating a career
> move)
>
> Tony
>

How do I repair a corrupted table - SQL2000