Restore a back up taken from SQL 2000 to SQL 2012?

When trying to restore a backup taken on SQL Server 2000 on a SQL Server 2012 RESTORE DATABASE is terminated?

“The database was backed up on a server running version <Old Version>. That version is incompatible with this server, which is running version <New Version>. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.”

The problem is that on a SQL Server 2012 instance you cannot restore a SQL Server 2000 backup. Practically on SQL Server 2012 you can restore backups taken on SQL Server 2005 or later version.

In such situation you can follow below steps.

- Restoring the SQL Server 2000 backup on SQL Server 2005 or 2008

- Set compatibility level to 90 (SQL Server 2005) or 100 (SQL Server 2008 / SQL Server 2008 R2)

- Backup the same database and restore it on the SQL Server 2012