Link to home
Start Free TrialLog in
Avatar of mpdillon
mpdillon

asked on

Error moving SQL 2005 Express (32Bit) to SQL express 2008 R2 (64 bit)

I am trying to install a new SQL server 2008 R2 (64 Bit). I need to move a small database from the old SQL Server Express 2005 (32 bit).

Making a backup of 2005 and trying to restore to 2008 R2 did not work.

I detached the SQL 2005 .mdf and the .ldf, copied to new server and tried to attach. I was using the management console to attach the database as I do not know the command line syntax. The current error is

"Could not continue scan with NOLOCK Due to Data movement. Converting Database "GMF" from version 622 to 661. Database "GMF " running the upgrade step from 662 to 25.(Microsoft SQL server 601)



Any suggestion on how to move this database would really be appreciated.



Thanks,

pat
ASKER CERTIFIED SOLUTION
Avatar of mpdillon
mpdillon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial