On 11/07/2012 11:56 AM, Igor Neyman wrote:
> The only 100% fool-proof test would be to restore from your backup files.
>
> Regards,
> Igor Neyman
Our internal process is to back up production databases regularly, and
then use the backups offsite to populate copies of databases for
developer use. This allows us to test with real data, identifying real
world bugs that would not appear with often-limited, manually created,
"sample data", as well as verify our backups on a regular, daily basis.
I'd strongly recommend something similar if it works for you.
-Ben