Start Free Trial

asked on

move database

Hello,

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.
help.
thx
henry

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ephraim Wangoya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

After fix error in database I uses backup and restore.
thx for help