The output for CheckAlloc was quite long. I searched for errors and it had
nothing. The last few lines are below.
I do not understand the output. I hope someone in the Newsgroup can help or
point me to someone that can help.
Total number of extents = 20817, used pages = 150288, referenced pages =
149591 in this database.
(number of mixed extents = 349, mixed pages = 2579) in this database.
CHECKALLOC found 0 allocation errors and 0 consistency errors in database
'PM_DATA2_Mdsped'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator
--
Sincerely,
Paul Sedor
V.P. & C.T.O.
SecureMed Corporation
psedor@securemed.com
520-917-1060
[quoted text, click to view] "Paul Sedor" <psedor@securemed.com> wrote in message
news:uq1CgANRDHA.1016@TK2MSFTNGP11.phx.gbl...
> Steve,
> At first I thought it was a hardware issue. So I ran checkdisk on the
drive
> with no errors. So, that is why I think it might be some corruption
issue.
> I also have six other databases running on the same drive with no
problems.
> I have it running database maintenance using the wizard on a nightly basis
> and when I look at the log I see the error. I have not put it into single
> user mode and run DBCC NEWALLOC. I will give it a try tonight and see
what
> I find. Thanks for giving me something to try. I will let you know what
> happens.
> --
> Sincerely,
> Paul Sedor
> V.P. & C.T.O.
> SecureMed Corporation
> psedor@securemed.com
>
> "Steve Thompson" <SteveThompson@nomail.please> wrote in message
> news:OGjaXzLRDHA.2008@TK2MSFTNGP11.phx.gbl...
> > "Paul Sedor" <psedor@securemed.com> wrote in message
> > news:uWEruAJRDHA.1724@TK2MSFTNGP10.phx.gbl...
> > > The following error shows up in the SQL log:
> > > I/O error (Bad Page ID) detected during read of BUF pointer=
> > > What are the steps to repair the database?
> >
> > Are you sure it's a database issue -- sometimes hardware issues can
cause
> > some strange messages. Have you put the database in single use mode and
> run
> > DBCC NEWALLOC?
> >
> > Steve
> >
> >
>
>
