Solved

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

Posted on 2010-08-15
1
1,089 Views
Last Modified: 2012-05-10
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
Comment
Question by:mpdillon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
mpdillon earned 0 total points
ID: 33441539
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question