Yes, we may do that or we may do OnPrem. Either way we are doing the upgrade. Right now it takes 1.35 hours to restore my database from a backup.
For the cloud potential, I have no idea how long it would take to get our DR group to push a non duped database to the cloud site. to be installed in our TEST site. Is that a 8 hour task or is it closer to 20+ hours just due to the size of 1.2 TB of file size today.
In on Prem I can use a compressed backup file and that takes only 1 hr to copy to the new Test server and restore there locally in an hour and 20 min. We are a few versions off the mark and these ports are a massive time crunch when we have to attempt to run them again and again.
On Fri, Dec 29, 2017 at 12:49 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-12-29 13:41, Stephen Russell wrote:
My company won't get rid of transactional data and the size of the 4 GL tables that are in my way is roughly 600 gigs. Finding specific data in them that is outside the scope of my indexes takes way too long. It also takes additional time to do a restore as well. In 2018 we are porting to an upgrade on a new data server so it will take each test more time to restore as well.
To me, IRS data demands past 7 years. I'll keep 8 and remove 3 years of older transactions now because we already have them in the DW as well.
Welcome to my monthly fight. :)
Didn't you guys say you're moving things to "The Cloud" ?
[excessive quoting removed by server]