Paul and Steve,

First of all, thank you so much for your professional advice! I really appreciate it!

I just want to bring to your attention that I wouldn't do anything like that in the production environment. I was testing the backup-restore for one of our prod databases on the test servers. The restores on one particular test server resulted in corruption but the restores on other servers didn't - I was testing the same database backup file.

I kept restoring the backup to this "problematic" test server and I ran different dbcc checkdb options over it and documented the errors.

Per Paul's advice, I am currently running the SQLIOSim on the server with the database corruption.

Thank you,

Sincerely,

Yulia