Upgrade - Currently running SQL code

[HRBlock]

I started the upgrade from 3.5 to 4.0 yesterday. My database is about 7GB and the process has been running for about 18 hours. I don't see anything in Windows Event Viewer other than the lansweeper service being stopped at 2:03pm when I started the upgrade. Is there any way to determine how far along in the process ( databse upgrade I presume is what is happening here)we have reached?

How do I know the process is still doing what it is suppoesed to be doing?

Thanks,

John

[HRBlock]

Thanks for the help. I'll let it keep churning.

[HRBlock]

I presume this is run in SQL Server manager against the lansweeper database? There should be about 4200 computers in the DB. So far the query reports back 572. This translates to a couple of days to complete this process. Does this sound even remotely correct?

[Hemoco]

HRBlock wrote:
I presume this is run in SQL Server manager against the lansweeper database? There should be about 4200 computers in the DB. So far the query reports back 572. This translates to a couple of days to complete this process. Does this sound even remotely correct?

Yes, I'm afraid so.
The advantage will be that the database will be smaller and faster after the upgrade.

[Hemoco]

You can try the following query to see how many computers are already upgraded:

select computername from tblcomputers where isnumeric(computername) = 1

I'm afraid 7GB will take a long time.