Migrating From MSSQL 2008 to MSSQL 2014

Here is what you need to do:

• Download and install SQL Server Upgrade Advisor for SQL Server 2014 and run it against SQL Server 2008 instance to find out any issues related to migration. 
• Backup all user databases on your SQL Server 2008 instance
• Restore them onto new SQL Server 2014 instance. 
• Migrate logins from SQL Server 2008 to SQL Server 2014
• Fix orphaned logins in databases
• Run sp_updatestats against all databases
• Run DBCC UPDATEUSAGE against all databases
• Script SQL Server Agent jobs (if any) from SQL Server 2008 instance and run this script on SQL Server 2014 instance to create these jobs

I suggest to read my following article on TechTarget:

Four points to consider for a SQL Server 2014 installation

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://ift.tt/1yDQKBd

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.