Time-out error during restoration

ara3n

Hello. Saw this error today. I was wondering if anybody else has seen it.

Restoring a fbk into sql 2005 with 5.0 sp1 exe.

Getting the following time out error.

---------------------------
Microsoft Dynamics NAV
---------------------------
The following SQL Server error(s) occurred while accessing the Value Entry table:

845,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Time-out occurred while waiting for buffer latch type 2 for page (3:726616), database ID 36.
3621,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

SQL:
CREATE UNIQUE NONCLUSTERED INDEX "$1" ON "CovidienCR10"."dbo"."PROD-LA-COLOMBIA$Value Entry1000005802" ("Item Ledger Entry No_","Entry No_") 

---------------------------
OK   
---------------------------

kine

For me it looks like some problems with reading from the HDD or something like that... check the hardware... :-k

And look into event log for more related info about possible HW failures etc.

ara3n

I was restoring the db into a database that already been used before and had companies in it. I had deleted the existing companies, and loaded the object from the backup. The error would occur again when I restarted the backup.

I ended up deleting the database and creating a new blank db and restore finished successfully.