Check data is the same after restore SQL I've backed up, transferred to another location and restored a database. Is there anyway to check that the data is the exact same? 

Would I be best using the CHECKSUM and then the VERIFYONLY method? 

Thanks.
First, CHECKSUM and VERIFYONLY do not do what you think they do.  Backing up with CHECKSUM merely verifies that the page checksums (if there and valid) are valid when writing the backup file.  VERIFYONLY only verifies that the backup file is complete and readable.  

But none of this will protect you from corruption in the source database, it is entirely possible for there to be corrupt pages, have them backed up and then restore them into the new database.  

What and why are you trying to do the verificaton?  You can do row counts for each table and compare that way.  RedGate has a comparison tool (paid, but with a trial) that can compare and display the differences.