I am trying to backup SQL database from old server (SQL 2008) which is installed on windows server 2008R2 to new server (SQL 2014) which is installed on windows server 2012. The database is large (around 200G). I did the backup using SQL management Studio and I got the backup file. However, I tried to restore in the new server using restore database from management studio (SQL 2014) but I got an error.
Any suggestion how to backup and restore database from SQL 2008 to SQL 2014