Home Forums SQL Server 2008 SQL Server 2008 Administration Move DB from 2008R2 Enterprise to 2008 Standard RE: Move DB from 2008R2 Enterprise to 2008 Standard
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 24, 2012 at 11:15 am
#1541532
If you are going from 2008 R2 to 2008, you won't be able to use the backup/restore. You will need to script your database on SQL Server 2008 R2, and create an empty database in 2008. Then use SSIS to transfer the data from 2008 R2 to 2008.