I have a database backup file (*.bak) which seems to have been created with SQL Server 2000 (v8.00.0760) and I want to restore it under SQL Server 2012 (v11.00.3128).
That fails because SQL Server Management Studio tells me that this version is incompatible and that I have to recover the backup with a server compatible version.
Is it somehow possible to restore the backup under SQL Server 2012?
Best regards, Stefan
In one step you can't restore backup from SQL 2000 in SQL 2012. The best supported option would be to restore this database on SQL Server 2005 or SQL Server 2008, then back it up again and restore this new backup on SQL Server 2012.