Home > SQL Server > Restore Database

Restore Database


>

Database compatibility issue.

If you try to restore SQL 2008 R2 database, you will get the error message shown above.

solution:
Backup the database with SQL 2008 (10) compatibility in SQL 2008 R2 and then restore it in SQL 2008.

OR

Run Database copy wizard in SQL R2 then Copy or Move the databases from one to another

OR

Run Import and Export wizard to copy data from one to another

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

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: