i have one existing sql server 2008 express r2 database file.
in my mechine there is only sql server 2008 express.
how to open that existing file in sql server 2008 express.
import and export database in sql server
Hello
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Renish PatelPosted May 31, 2013, 6:31 AM
Thanks
sujit kalagaraPosted May 31, 2013, 2:56 AM
Renish PatelPosted May 31, 2013, 2:30 AM
You can't attach/restore a 2008 R2 database to a 2008 instance. You either need to upgrade the 2008 instance to 2008 R2, or you need to move the schema and data in another way. For Example You can generate the scripts from the sql server 2008 express r2 instance and run them on the 2008 express instance.
This can solve your problem
Thanks
Renish Patel