Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. Am I only stuck with installing the non-R2 SQL server to run side-by-side with my R2 database server?

share|improve this question
add comment

2 Answers

up vote 5 down vote accepted

Is there a way to create non-R2 databases in an R2 database server?

No. Once a database has been attached to a version of SQL server, it can never be re-attached to a previous version, even if the compatibility level stays the same.

Am I only stuck with installing the non-R2 SQL server to run side-by-side with my R2 database server?

Yes.

share|improve this answer
add comment

There is no SQL 2008 R2 compatibility mode, only the SQL 2008 compatibility mode. This is because there are no syntax changes between SQL 2008 and SQL 2008 R2.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.