Backup/restore check data is the same SQL Server I'm a trainee SQL DBA. I'm using SSMS 2008r2. 
I've backed up a database and restored this as a new database on a new instance. 
I want to check to see if the data is the same on both databases. Is there a way I can do this without running select commands on both databases and comparing? 

Thanks. 
Ryan.
SQL Server Data Tools offers a Data/Schema comparison option. You need to install it, previous download of it, and then do the comparison.

More information on how to compare in How to: Compare and Synchronize the Data of Two Databases.

To download the free tool, please visit https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx.