SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server 2008 R2 backup/restore - simple Tip

Simple, but I think somebody will ask:

Can restore the SQL Server 2008 R2 database to SQL Server 2008 ?

Simple answer, No! You cannot restore your databases in SQL Server 2008 from SQL Server 2008 R2, (just simple test)!

Stay Tuned!

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...


Posted by Jerry Hung on 12 May 2010

Can you do it the OTHER way though, restore R2 backups to SQL 2008 RTM?

I hope so. After all, they are still SQL Server 2008

One can restore 2005 backup to 2008, but not 2008 backups to 2005

Posted by Dukagjin Maloku on 12 May 2010

No, it is not allowed downgrade database from SQL 10.5(2008 R2) to SQL 10(2008)!!!

Posted by Jason Brimhall on 12 May 2010

I think Jerry might have swapped his versions and meant to ask if a 2008 backup could be restored to 2008 R2.  If you follow the trend with prior versions for this, the answer would be yes.  The database would be upgraded to R2 at restore time.

Posted by Dukagjin Maloku on 12 May 2010

Clarifying the situation:

Restore process is not valid from SQL Server 2008 R2 to SQL Server 2008.


Restore process is valid from SQL Server 2008 to SQL Server 2008 R2!

Posted by Anonymous on 13 May 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, SQL Server 2008 R2 backup/restore - simple Tip - Dukagjin Maloku - Dugi'SQL         [sqlservercentral.com]        on Topsy.com

Posted by wclemmer on 25 October 2010

So... If you needed to get a database from a SQL2008 R2 box onto a SQL2008 box, how would you go about it?

Posted by Dukagjin Maloku on 26 October 2010


You can do it, with Import/Export or to script out everything (Data and Objects) and run them to the SQL Server 2008.

Posted by slaforge on 13 January 2011

So is it possible to install SQL 2008 R2 on Windows 7 64-bit?  The installation runs, but I always wind up with the SQL 2008 version.  Is there a trick that I don't know?

Posted by Dukagjin Maloku on 13 January 2011

Yes you can install SQL Server 2008 R2 on Win 7 64 bit without any problem ...what is your issue, can you tell us more in details, however we are discussing here for the backups between SQL Server versions!

Leave a Comment

Please register or log in to leave a comment.