Tuesday, February 14, 2012

dbcc checkcatalog problem

Hi,
we are msdn partner and have sql server 2000 enterprise.
We installed it three times and on every server we get errors, when using
dbcc checkcatalog in the msdb.
Can it be an error on the cd, has anny one else this problem?
Regards
Alexander PfingstlWorks fine for me. Do you have the latest service pack installed?
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> we are msdn partner and have sql server 2000 enterprise.
> We installed it three times and on every server we get errors, when using
> dbcc checkcatalog in the msdb.
> Can it be an error on the cd, has anny one else this problem?
> Regards
> Alexander Pfingstl
>|||Yes I have.
We now found out, that on a new CD the database is correct.
Is it possible to exchange the database.
I would stop the server:
then delete the old msdb-Database Files and copy the new ones into the
directory.
Then start the Server again.
Will this work?
Or can´t I do this with msdb?
Thanks!
Alexander
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Works fine for me. Do you have the latest service pack installed?
> --
> Andrew J. Kelly SQL MVP
>
> "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > we are msdn partner and have sql server 2000 enterprise.
> > We installed it three times and on every server we get errors, when
using
> > dbcc checkcatalog in the msdb.
> >
> > Can it be an error on the cd, has anny one else this problem?
> >
> > Regards
> > Alexander Pfingstl
> >
> >
>|||I guess this is theoretically possible but I don't know if it would be
supported officially or not. You would at the least loose any info you may
have in the MSDB database if any.
--
Andrew J. Kelly SQL MVP
"Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
news:u3rWcaSeEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Yes I have.
> We now found out, that on a new CD the database is correct.
> Is it possible to exchange the database.
> I would stop the server:
> then delete the old msdb-Database Files and copy the new ones into the
> directory.
> Then start the Server again.
> Will this work?
> Or can´t I do this with msdb?
> Thanks!
> Alexander
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:uvkMotJeEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Works fine for me. Do you have the latest service pack installed?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Alexander Pfingstl" <apfingstl@.systempartner-plus.de> wrote in message
> > news:OD%23UfoIeEHA.3016@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > we are msdn partner and have sql server 2000 enterprise.
> > > We installed it three times and on every server we get errors, when
> using
> > > dbcc checkcatalog in the msdb.
> > >
> > > Can it be an error on the cd, has anny one else this problem?
> > >
> > > Regards
> > > Alexander Pfingstl
> > >
> > >
> >
> >
>

No comments:

Post a Comment