• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1094
  • Last Modified:

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
0
mpdillon
Asked:
mpdillon
1 Solution
 
mpdillonAuthor Commented:
I resolved the problem by removing the LOG file from the directory. I then had to remove the Log file from DATABASE DETAILS. After this the database attached successfully.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now