Upgrade 3.7a - 4.0sp3 on SQL

raven44

Hi,
Breakdown:
Nav 3.7a on SQL v8.0
upgrading to Nav 4.0sp3 on SQL 2005

Does this sound problematic already?

The upgrade was going fine up until the Database Test on the upgraded database laying on the new SQL version.
(Step 18 in the 370_400 Quickguides document for the Upgrade Toolkit).

The database test hangs when trying to do all tests excluding the relationships.
Therefore I narrowed it down to just Primary keys and data & Test Blobs.
I got errors as follows:

Error: The following SQL Server error(s) occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]Lock request time out period exceeded.
Error: The following SQL Server error(s) occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.

When opening SQL Mgt. studio and trying to get the Properties of the db, I got the Lock request Time out Period exceeded error.

Anyone have any ideas on the following?
Thanks in advance

raven44

..ok, able to get into the Properties of the database through SQL after closing everything and re-opening

kine

Be sure that you are only user in the DB when running the test. Close all other programs like Management studio etc.

raven44

I have tried to run the test with the following:
- I was the only one on the database.
- Navision is the only application that is running.

Received the same logs.

raven44

let the test run over the weekend.
completed successfully - hopefully the previous error message doesn't result in errors later on.

Administrator

[Topic moved from Navision to SQL General forum]