Restoring database to an instance with a lower version

Question

The database was backed up on a server running version 10.50.1600. That version is incompatible with server, which is running version 10.00.1600. so, is there any solution or plugin's for restore the database ?

Your question is a duplicate. Read the answer here: http://stackoverflow.com/questions/6183139/sql-server-database-backup-restore-on-lower-version — dcaswell, Aug 23 '13 at 04:30

score 1 · Answer 1 · answered Aug 23 '13 at 04:27

You can download SQL Express 2008 R2 (free edition) or 2012 to restore the database. The problem is not the management studio but the SQL Server engine itself. Here are the versions:

http://sqlserverbuilds.blogspot.com/

As you can see, 10.50 is the 2008 R2 and 10.00 is the 2008.

score 0 · Answer 2 · edited May 23 '17 at 11:56

0

-Frst, you export the database on the server running version 10.50.1600 by following this link. Export to SQL Script

After that, you can, import again into your current database which is running version 10.00.1600

edited May 23 '17 at 11:56

Community

1
1

answered Aug 23 '13 at 04:34

user1482210

16
2

score 0 · Answer 3 · answered Aug 23 '13 at 04:41

I would suggest an this might be a rather sloppy way is to use Database Publishing Wizard or you can click right on the Database in SQL Server Management Studio -> Tasks -> Generate Scripts.

Select all the objects. Then when it shows the path of the script file click on the Advanced button. Ensure to include

Types of data to script = Schema and Data

Script USE DATABASE = True

You can check if their might be anything else required. Once the script execute try and restore it on the previous SQL Server version. If any problems arise, I would think you might have some control by fixing the scripts to inserts. It might take long but I would think it's probably the best shot.

INSTRUCTIONS ON GENERATING SCRIPTS

score 0 · Answer 4 · edited May 23 '17 at 12:21

Nopes, not possible. Only thing you can do is to upgrade your instance or a newer version or generate scripts in some way and then execute these on the previous version.

Generate scripts – use this only if this is a small database because scripts are not necessarily in correct execution order.

Third party tools – there are tools that can generate scripts in correct execution order from the live database or read the backup and generate scripts from there.

More details here SQL Server database backup restore on lower version

Restoring database to an instance with a lower version

4 Answers4