→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HRBlock
Engaged Sweeper
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
4 REPLIES 4
HRBlock
Engaged Sweeper
Thanks for the help. I'll let it keep churning.
HRBlock
Engaged Sweeper
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
Lansweeper Alumni
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
Lansweeper Alumni
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.