Items......Disappearing?

maybe their item database finally hit 2,147,483,647 items

No, SQL Server has no limits on number of rows in a table. That's limited by hardware. Even if that was the issue, that would affect new items being inserted into the database, not existing items.