SiteControl table got currepted

Dear All,

During our routine check , i found that my SQL Monitor and component manager
services are missing in one of my primary server!! I have done a DBCC CHECKDB
against my SMS Database and it land up with 17 consistency errors against the
table 'sitecontrol'. If i do a select *.... for this table, i won't get any
content.

I have tried to do a site reset but in vain. It has thrown an error message
saying "cannot insert the site control image to the database". I have gone
thorugh some of the articles and tried to delete and recreate the Extended
Stored Procedure xp_SMS_notification. But that also did not worked out!!

I have restored almost 1 month back data from the backup but all the
backup's is having a currepted sitecontrol table. Now i am in a tricky
situation. I am not sure whether the backup's before 2 months contains
correct\healthy one....

Now,

Is it possible to repair a single sql table?
If i delete the sitecontrol table manually, will it get recreated?
If i create a copy of the structure of sitecontrol table, and then delete
the faulty one, will it get replicated to the new table? Is that a good
solution?

Any help will be highly appreteated!!

Many thanks in advance,
Jaison

Dear Garth,



Thanks for the reply.

Do you know what is the command to perform a DBCC repair on a table?
something like sp_fixindex which is avaible for system tables.....

Cheers,
JJ

"Garth" wrote:

> Yes is it is possible to restore just one table however the problem you
> describe means that there is a database issue for sure and could be other
> site issue that need to be looked. With that in mind, you should call MS
> support to work through this issue. Even if you can restore just the one
> table there could be many other issues within the database and site that
> might need to be resolved. This is NOT something that anyone on this
> newsgroup can truly help you solve.
>
>
>
> Best of luck to you.
>
>
> "Jaison Jose" <JaisonJose@discussions.microsoft.com> wrote in message
> news:3F327594-7AAD-41C7-AC2C-88F85EE54D76@microsoft.com...
> > Dear All,
> >
> > During our routine check , i found that my SQL Monitor and component
> manager
> > services are missing in one of my primary server!! I have done a DBCC
> CHECKDB
> > against my SMS Database and it land up with 17 consistency errors
> against the
> > table 'sitecontrol'. If i do a select *.... for this table, i won't get
> any
> > content.
> >
> > I have tried to do a site reset but in vain. It has thrown an error
> message
> > saying "cannot insert the site control image to the database". I have
> gone
> > thorugh some of the articles and tried to delete and recreate the
> Extended
> > Stored Procedure xp_SMS_notification. But that also did not worked out!!
> >
> > I have restored almost 1 month back data from the backup but all the
> > backup's is having a currepted sitecontrol table. Now i am in a tricky
> > situation. I am not sure whether the backup's before 2 months contains
> > correct\healthy one....
> >
> > Now,
> >
> > Is it possible to repair a single sql table?
> > If i delete the sitecontrol table manually, will it get recreated?
> > If i create a copy of the structure of sitecontrol table, and then
> delete
> > the faulty one, will it get replicated to the new table? Is that a good
> > solution?
> >
> > Any help will be highly appreteated!!
> >
> > Many thanks in advance,
> > Jaison
>