SQL Server 2008 R2 Upgrade / Server Move to SQL Server 2014 -

SQL Server 2008 R2 Upgrade / Server Move to SQL Server 2014 -

i have new server , want install sql server 2014 standard , migrate database across old server runs sql server 2008 r2 (10.50.1600.1).

i have upgraded locally, having move servers on production environment complicates matters, thought i'd inquire best way progress giving situation. can think of different options upgrade, not sure best choice:

would best upgrade current sql server 2008 r2 box service pack 2 before thinking upgrade, or not create difference if i'm upgrading? if do, best alternative below?

1) install sql server 2008 r2 service pack 2 on current server, upgrade in-situ sql server 2014, perform backup. restore sql server 2014 backup on new server.

2) install sql server 2008 r2 service pack 2 on current server, perform backup. restore sql server 2008 r2 backup on new server on sql server 2014.

i understand sql server 2014 includes new total text search features not available in 2008 prompted part of installation process, i'm thinking if restore 2008 backup on 2014 not 'upgrading' in full. hence improve take alternative 1 (above) on alternative 2?

-> restoring backup not upgrade database. so, 1)microsoft sql server 2014 installation setup provide options upgrade database either 2008 r2 or 2012. preform process , provide info if database upgrade able or required create changes old database. after can proceed upgrade database 2008 r2 2014.

eg. click start, point programs, point microsoft sql server 2014 , , click sql server 2014 upgrade advisor. farther details http://msdn.microsoft.com/en-us/library/ms144256.aspx

my recommendation install sql server 2014 instance , backup , migrate database sql server 2008 r2 sql server 2014

2) there other 3rd party tools preform necessary processes , messaging before upgrade.

sql-server sql-server-2008 sql-server-2014 sql-server-administration