Home Forums SQL Server 2008 SQL Server 2008 Administration sql 2008 std to 2008 r2 RE: sql 2008 std to 2008 r2

  • December 9, 2013 at 8:48 am

    #1671990

    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