Sage 100

Hi All,

   I have a client on premium that will be moving to the cloud.  I have done this before using @Carmen Cruz  way of doing the move.  Their IT asked me a question that I am unsure of.  They wanted to know if for the go live data move (after the initial more for testing, the client has 17 mods and worldwide users so testing is critical) a incremental restore of the SQL databases could be done.  It doesn't seem to me like this would work as I am sure there will be backups between the time of the initial move and the final move.  I full backup / restore seems like the only option to me..

Hi Bob - You're right they cannot do an incremental restore of the SQL DBs. 

Incremental backups are a great way to preserve more up-to-the-minute SQL data without repeatedly backing everything up.  Basically, you take a full backup, then each incremental backup after that only has the "changes" made after the last backup (either full or incremental).  After you do another full backup, all the old incremental backups become obsolete.  To restore, you start with the full, then apply the incrementals (in order, up to the point you want), then say "I'm done restoring files" so the restored database can be used.

It depends on the situation here as to whether incremental backups can be used.  If anything has been done on the "target" system after the original restore, or another full backup has been done at the "source", it would not work at a technical level (in SQL). 

If you are doing a move and upgrade at the same time, Alnoor's response is 100% accurate.  As soon as anything is done on the target system (i.e. system file conversion) you break the incremental restore chain.

Original Message:
Sent: 07-05-2023 09:37
From: Carmen Cruz
Subject: Sage Premium move

Hi Alnoor,

You can in fact do incremental's. You'll end up with a file that has a TRN extension and then it has a bunch of little backups in a list with the time that would be restored as well to prior to time of issue that occurred that caused requirement to restore.  For example, we run our back ups every 15 minutes. I once, in fact, had to do a restore, I restored the main TRN and then it has each level of the backup for every 15 minutes. We determined what time the client crashed and then we restored prior to that restoration timeline. It was a pain because you have to do what appears to be multiple restores to get them all back in place.  They have to be done in order and as said before they need to know what they are doing. Should they attempt to do a restore this way.

	Carmen Cruz Sage Consultant carmen.cruz@compudata.com 215-969-1000 Ext. 279 www.compudata.com Work Smarter... Together
CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106

Original Message:
Sent: 6/30/2023 1:32:00 AM
From: Alnoor Cassim
Subject: RE: Sage Premium move

Hi Bob - You're right they cannot do an incremental restore of the SQL DBs. 

------------------------------
Alnoor Cassim
------------------------------