Rstore the backup file problem in SQL server

Andreas_Gunawan

Dear All,
I find the following message when I restore a backup file of navision database (fdb).
The following SQL Server error(s) occured while accessing the User Menu Level table:
601,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data
movement.

SQL:
SELECT[name],[usertype],[xtype],[length],[prec],[scale],[status]FROM"selcom".[dbo].[syscolumns]WHERE[id]=
OBJECT_ID(?)

I can actually delete the database and recreate database in the SQL, but I want to maintain it.
Any answers from you are apreciated. tku

Rgds,
Andreas

ara3n

Delete all the records from User Menu Level table and try to restore the backup.