Posted by Neil on 06/20/07 22:06

I'm not familiar with DBCC. Can you point me in the right direction?

Thanks.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9955ED0DF77BAYazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> So, while I have a hard time believing that SQL Server would just "lose"
>> a record, I also know that anything's possible, so I thought I'd ask if
>> anyone had ever heard of such a thing.
>
> Well, I have lost rows, but that was a on a system where no one was
> looking
> at the event log or the DBCC logs, and finally the database broke down,
> with several levels of corruption.
>
> As Roy said, run DBCC. If it comes up with corruption, then that may be
> the answer.
>
> But I'm prepared to place my bets that there was a human involved.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]