Tuesday, April 23, 2013

The database cannot be opened because it is version 706. This server supports version 661 and earlier

Today I was trying to Attach a database in SQL server 2008 R2.

I got below error while attaching database:

This is because the data file I was trying to attach is from SQL server 2012. I was trying to attach this in SQL Server 2008. The only solution to this problem is to generate script from SQL server 2012 and than run that script in SQL server 2008.

1 comment: