Web Wiz Forums - Error after importing the DB to different Server

Print Page | Close Window

Error after importing the DB to different Server

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28005
Printed Date: 02 April 2026 at 7:58am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error after importing the DB to different Server

Posted By: kharelrupak
Subject: Error after importing the DB to different Server
Date Posted: 07 November 2009 at 10:00pm

Hi,

I am planning to move the hosting server therefore I tried to migrate the SQL server DB to different server. I have successfully exported the DB and the forum code. But its giving me this error.

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_get_birthdays
File Name:- default.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Could not continue scan with NOLOCK due to data movement.

The exception is thrown on other pages as well "Could not continue scan with NOLOCK due to data movement."

Is it something I am missing while transferring.

Thanks.

Replies:

Posted By: kharelrupak
Date Posted: 08 November 2009 at 12:19am

i have figured it out. i performed the database check and repaired it. now it works. must be some problems while importing where the log file is not properly transferred or similar to that.

Posted By: WebWiz-Bruce
Date Posted: 09 November 2009 at 11:59am

The only successful way to move a SQL Server database is either detach and reattach the database or create a backup (.bak file) and then restore it on the new server.

Many of the other methods of importing and exporting data often drop important parts of the database schema.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting