Post Database upgrade on new instance

Question

I reviewed the SQL Server 2012 technical upgrade guide and also googled for more recommendations.

I am migrating a SQL Server 2008 R2 instance to SQL Server 2012 on a separate machine.

Here is what I plan to do. Please correct and advise your recommendations.

• On SQL Server 2008 R2 instance:

  • I ran the SQL Server upgrade advisor instance.
  • Take backup after all activity is stopped.

• On SQL Server 2012 instance:

  • Restored SQL Server 2008 R2 backups
  • Update the database compatibility level to 110
  • dbcc checkdb with data_purity
  • EXEC sp_updatestats;
  • EXEC sp_MSforeachtable @command1='UPDATE STATISTICS ? WITH FULLSCAN';
  • DBCC UPDATEUSAGE(dbname);

I will have the logins, job setup separately.

Do I need to rebuild the indexes? Any thing else?

I truly value your input and hope to hear your recommendations.

Thank you.