Friday, February 24, 2012

dbcc checktable(sysindexes)

I'm trying to attach a copy of a database to another server. When I do
this, the attach fails due to an index problem. The error message
indicates that I should run:
dbcc checktable(sysindexes)
when I run this on the original server (where the database is attached)
I get a missing sysindexes object error.
However, I am able to run this:
select * from sysindexes
without any apparent problem.
What do I do now?
FYI: dbcc checkdb reports no problems.
TIA.Hi Karl
Did you try DBCC CHECKCATALOG?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Karl" <karlt@.nospam.nospame> wrote in message
news:O6WspeMbGHA.3740@.TK2MSFTNGP03.phx.gbl...
> I'm trying to attach a copy of a database to another server. When I do
> this, the attach fails due to an index problem. The error message
> indicates that I should run:
> dbcc checktable(sysindexes)
> when I run this on the original server (where the database is attached) I
> get a missing sysindexes object error.
> However, I am able to run this:
> select * from sysindexes
> without any apparent problem.
> What do I do now?
> FYI: dbcc checkdb reports no problems.
>
> TIA.|||Thanks for the reply.
DBCC CHECKCATALOG reports no errors. It also doesn't give any other
information other than that command completed successfully.
Now what?
Kalen Delaney wrote:
> Hi Karl
> Did you try DBCC CHECKCATALOG?
>|||Karl
So , you don't see the database since as you said the attach command is
failed, am I right?
Do you detach the database on the "source" server?
Can you perfom BACKUP DATABASE on the source server , then copy the .BAK
file to the "destination" server and run RESTORE DATABASE command? Do you
get the same error?
"Karl" <karlt@.nospam.nospame> wrote in message
news:%23iKyzWPbGHA.3376@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Thanks for the reply.
> DBCC CHECKCATALOG reports no errors. It also doesn't give any other
> information other than that command completed successfully.
> Now what?
>
>
> Kalen Delaney wrote:

No comments:

Post a Comment