Database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported.

This is the error message or similar to it when you try to attach a database from a more advanced version of SQL Server to an old one.

To resolved
1. Try to locate a SQL Server Version most advanced in your environment on any other server / PC
3. Attach the .mdf file
4. Use one of the following methods to create a database with same schema on the intended target server
a) MS Visual Studio SQL Server Tools
b) SQL Server data export and import from SSMS

Visual Studio tools are good for schema comparisons but sometimes breakdown on large data sometimes, vice versa for Data import export with SSMS.

Have tried this on SQL 2012 onwards.

Advertisements
About

IT professional with wider interest in technology

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: