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: 36188 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: 36188 More actions · Answer 6

VastSQL

SSC-Dedicated

Points: 36188

December 9, 2013 at 8:37 am

#1671980

Thanks Lynn..

Elliott Whitlow SSC Guru Points: 102402 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.

sql 2008 std to 2008 r2

Cookies on SQLServerCentral