I believe Jeffery is onto something. The OP did say "database" (singular) had data deleted and the associated data files shrank by 3/5. The OP then verified that the backup...

Good to read that the offender has been identified and SQL ServerCentral is taking the right action. Here is a way to get the sales order counts by year...

That was a great question. Especially the similarity of the column names to demonstrate how easily a typo can be overlooked and still return what you expect (since in...

Thanks for the good question. Learned something new today, and that is why I like the QotD!!