04-25-2012 08:46 AM
Anyone experienced upgrades with large numbers in the journalarchive table? Looking for an estimate of downtime as there are multiple servers involved.
Thanks,
DB Name Data File Size (MB) Log File Size(MB) Total size(MB)
EnterpriseVaultDirectory 1210 5300 6510
EnterpriseVaultFSAReporting 4100 35980 40080
EnterpriseVaultMonitoring 170 3100 3270
EVConfiguration 10 36 46
EVDiscovery 30000 15489 45489
EVFSAVaultStore 15600 4400 20000
EVMailVaultStore 144400 19000 163400
EVFSAVaultStore
JournalArchive - 2049818
SaveSet - 6373928
EVMailVaultStore
JournalArchive - 91439763
SaveSet - 209482334
EVSharePointVaultStore
JournalArchive - 2290
SaveSet - 191021
EVMailVaultStore2
JournalArchive - 0
SaveSet - 0
EVMailVaultStore2 100 100 200
EVSharePointVaultStore 400 201 601
Solved! Go to Solution.
04-25-2012 08:57 AM
how many items are in the journal archive table?
its really like how long is a piece of string, it all depends on how many items, the sql server itself, whether its shared, what kind of disks are in use, memory, processor etc
and its not really a matter of how much is in the journal archive, but how much is awaiting backup and the number items in your watchfile
Honestly, i wouldn't expect it to take that long at all
04-25-2012 08:57 AM
how many items are in the journal archive table?
its really like how long is a piece of string, it all depends on how many items, the sql server itself, whether its shared, what kind of disks are in use, memory, processor etc
and its not really a matter of how much is in the journal archive, but how much is awaiting backup and the number items in your watchfile
Honestly, i wouldn't expect it to take that long at all
04-25-2012 09:03 AM
I just finished an upgrade from 9 - 10 (13 servers) in an environment of 20k+ users for 5 years. The entire process took about 1 hour per server. The longer portion was data migration. If you are doing an inplace upgrade you should expect less than 1 hour per server.
04-25-2012 09:22 AM
The upgrade that i did from EV8 to to EV9 with tens of thousands users on each site, was about 20 mins per server from start to finish of starting the setup, restarting the server and running the directory and storage and having them upgrade
04-25-2012 01:45 PM
upgrading sharepoint agents should only take a few minutes? will there be a reboot?
05-05-2012 07:17 AM
upgrade of storage db is going on over 9 hours now..
05-05-2012 07:20 AM
--Populate
update JournalArchive
set journalarchive.SavesetIdentity = Saveset.SavesetIdentity
from JournalArchive inner join Saveset on Saveset.IdTransaction = JournalArchive.TransactionID
where JournalArchive.SavesetIdentity IS NULL
this has been running for a long time..