We backup the database from the Production Server and then restore it to a
Test Server.

Is there an option in Backup Exec that can compare if the original and
restored database are actually the same???

If not, anyone knows how to compare databases from different server using
Transact-SQL or any MS-SQL tools???