sql 2008 std to 2008 r2

Question

sql 2008 std to 2008 r2

guaro5555

Mr or Mrs. 500

Points: 548
More actions
December 4, 2013 at 9:32 am

#279754

Hi gurus
I just want to confirm that it is possible to take a bak file from sql 2008 and restore it on sql 2008 r2.
Thanks a bunch gurus

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

guaro5555 (12/4/2013)
Hi gurus
I just want to confirm that it is possible to take a bak file from sql 2008 and restore it on sql 2008 r2.
Thanks a bunch gurus

Yes, but I am pretty sure you can't go from 2008 R2 to 2008.

guaro5555 Mr or Mrs. 500 Points: 548 More actions · Answer 2

Thanks a bunch for your reply.

Is this also true for

2008 developer ed to 2008 r2 developer ed

Thanks a bunch

PravB4u Default port Points: 1401 More actions · Answer 3

yes

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 4

Editions of SQL Server is not a problem when you do the restore its Version that matters and SQL server don't have backward compatibility.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Ratheesh.K.Nair (12/9/2013)
Editions of SQL Server is not a problem when you do the restore its Version that matters and SQL server don't have backward compatibility.

Not completely true, if you have a database on Enterprise (or Developer) Edition using Enterprise only features you can't restore that database to a Standard Edition (or less) server.

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 6

VastSQL

SSC-Dedicated

Points: 36067

December 9, 2013 at 8:37 am

#1671980

Thanks Lynn..

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 7

Lynn Pettis (12/9/2013)
Ratheesh.K.Nair (12/9/2013)
Editions of SQL Server is not a problem when you do the restore its Version that matters and SQL server don't have backward compatibility.
Not completely true, if you have a database on Enterprise (or Developer) Edition using Enterprise only features you can't restore that database to a Standard Edition (or less) server.

Is that correct? I thought you could restore it but it simply wouldn't work.. I'll just have to trust you, not going to setup a testing setup to find out..

CEWII

PravB4u Default port Points: 1401 More actions · Answer 8

you can refer Paul's below article.

http://www.sqlskills.com/blogs/paul/sql-server-2008-does-my-database-contain-enterprise-only-features/

Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com

dan-572483 SSCoach Points: 15870 More actions · Answer 9

I was pleased to discover that while SQL Server R2 Express cannot create compressed backups, it can restore compressed backups created on Standard ot Enterprise Edition.