restore navision backup file in SQL server

Business Central/NAV Technical Forum
1

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 abd recreate but I dislike to do it.

Any answers from you are apreciated. tku

Rgds,
Andreas

2

Try setting the database to singleuser.

Is it a fresh new database, or is it an old navision database you are restoring over the top of?