Error moving SQL 2005 Express (32Bit) to SQL express 2008 R2 (64 bit)
Posted on 2010-08-15
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.