Copy database from sql express to sql server 2008

Question

How to copy database from sql server 2008 to sql server 2008?

Wim Sturkenboom · Answer

[quote] I tried restore database but not working. [/quote] 'Not working' does not mean anything. Please be as complete in the description. Are you getting error(s)? Which one(s)? Does the second method (attach) work?

Ranjit Powar · Answer

I tried restore database but not working.

Wim Sturkenboom · Answer

Two options that should work Create a backup in sql server express and restore in sql server. Copy the file (mdf) and attach the copy using ssms to the other server.