Posted by Erland Sommarskog on 06/20/07 21:15

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

• Next in forum: Re: Win2003 / Sql2000 Memory usage
• Prev in forum: Re: I need to find the rows that exist in one table but not in the other with condition
• Thread view: Re: Can SQL Lose Records?

[Reply to this message]