move database


I need move database from server A to server B. (one PC to other)
server A: SQL server Express 2008
server B: SQL server Express 2008 R2

How can I do that ? I don't have much experience with SQL servers.
I tried connect over network both PC and use import export tool but gives me auth error.
Also tried backup and restore on 2nd machine. Error when restoring - backup database version is different.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Olaf DoschkeSoftware DeveloperCommented:
In each new installation, security of SQL Server is very high and remote access is disabled. First fix that.
Follow these steps:

This is written for SQL 2008 Express but should also be valid for 2008 Express.

Bye, Olaf.
Guy Hengel [angelIII / a3]Billing EngineerCommented:

>Error when restoring - backup database version is different.
means that your 2 sql instances have different versions, aka the restore instance is lower version that the source instance.

in which case you cannot go the backup/restore method, but you need to migrate the schema and data differently.
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Olaf DoschkeSoftware DeveloperCommented:
... should also be valid for R2, of course.
Ephraim WangoyaCommented:
You can try Detaching the database. Copy the database files ( .mdf and .log) files to the new server and attach to sql server. (not my prefered method)
That should work, just make sure not to delete the database when detaching
Can you clarify if you want to move from SQL 2008 to R2 or in the other way? If its from R2 to 2008 you cannot do that.
henryk123Author Commented:
After fix error in database I uses backup and restore.
thx for help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.