I have a SQL Server 2008 R2 instance that I need to backup and restore onto a SQL 2008 instance.
When I attempt to restore the back up (.bak) database from the R2 SQL server onto the SQL 2008 server I get the following message:
The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with
this server. (Microsoft.SqlServer.Smo)
How can i backup the SQL 2008 R2 database to be compatible with SQL 2008?Ian Ceicys
View Complete Post