How to restore DB from bak file created 2008 R2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to restore DB from bak file created 2008 R2

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2011-03-18 : 10:14:46

I created a bakup file on sql server 2008 R2.

But now trying to restore the database from bakup file on sql server 2008 version.

I get an error saying the bakup is created on a different version, cannot restore the database.

I need to debug the application for some errors, but on my machine i only version installed is 2008.

Thanks for the helpful info.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-03-18 : 10:36:47

You cannot restore down-version. A SQL 2008 R2 backup cannot be restored on SQL 2008. A SQL 2008 backup cannot be restored on SQL 2005, etc. You'll need to installSQL 2008 R2 to be able to restore that backup.

--
Gail Shaw
SQL Server MVP

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2011-03-18 : 14:56:00

your other option is to manually pump the data out via BCP or SSIS or Import/Export wizard etc.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-18 : 15:42:09

If you are trying to debug things, then you really need to get 2008 R2 installed. You should be developing, testing, etc on the same version as what production will be.

I would not recommend import/export etc as a result.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2011-03-22 : 14:50:10

Slightly OT, but related:

If I have a database under SQL 2008 with SQL 2005 compatibility level, can I backup and restore to a SQL 2005 server?

Cheers,

Tim

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-22 : 15:03:31

quote:
Originally posted by timmy

If I have a database under SQL 2008 with SQL 2005 compatibility level, can I backup and restore to a SQL 2005 server?

No.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-22 : 15:03:55

No, you can not.

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2011-03-22 : 15:04:51

Bugger.

Thanks anyway.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-03-22 : 15:28:21

Compatibility level just controls how the query processor interprets some T-SQL constructs and what the parser considers valid or not. It has no effect on the structure of the data and log files, the structure of the system tables or the database's internal version.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources