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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.