samsar
asked on
SQL DB restore from SQL 2008 R@ to SQL 2008 Web Edition
I would like to know how can I restore a database from a server which has SQL 2008 R2 to a server which has SQL 2008 Web Edition installed on it
Is the SQL Server 2008 Web Edition R2? if not it is not possible to restore an R2 backup to a none R2 SQL Server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good catch, jacko72. The limitation is in version of SQL and not edition. You can run SQL 2005 or SQL 2008 databases on SQL 2008 R2, but you could run a SQL 2008 R2 database on SQL 2005 as an example.
>>I would like to know how can I restore a database from a server which has SQL 2008 R2 to a server which has SQL 2008 Web Edition installed on it <<
You can't. Consider moving the schema and data with something like Red-Gate's tools:
SQL Compare
SQL Data Compare.
You can't. Consider moving the schema and data with something like Red-Gate's tools:
SQL Compare
SQL Data Compare.
Kevin.
>>but you could run a SQL 2008 R2 database on SQL 2005 as an example. <<
I suspect you are missing a "not" here.
>>but you could run a SQL 2008 R2 database on SQL 2005 as an example. <<
I suspect you are missing a "not" here.
Yes. *laughing*
it is not possible to restore a R2 databata to SQL SERVER the onll option is
Generate the scriprt and execute the date
Generate the scriprt and execute the date
i mean data not date
>>it is not possible to restore a R2 databata to SQL SERVER the onll option is<<
Yes, I think you will find that has been established.
Yes, I think you will find that has been established.
ASKER
Thank you for your help