Backup approach prior to system go-live

[Former Member]

hi,

my project team will be performing conversion and uploading to production client prior to go-live. in case half way hit by error, and to avoid from redoing the whole conversion again, we will perform client copy at stages.

other than client copy approach, what are the other options we have ?

comment and advice will be highly appreciated.

regards,

kent

[JPReyes · Accepted solution]

Why a client copy????

A full DB backup at each stage will do.

Regards

Juan

[Former Member · Accepted solution]

hi Juan,

a.) correct me if i'm wrong, full db backup and restore takes longer time as compare to client copy

b.) when restoring from full db backup, we can't select just one particular client to restore.

currently in the PRD system there are 5 productive clients

PRD100

PRD200

PRD300

PRD400

PRD500

PRD100 - 400 already gone live and operating ... PRD500 still in conversion stage ...if we restore from full db backup, other productive clients will be impacted.

regards,

kent

[Former Member · Accepted solution]

Hi,

You just found out why it is recommended to have a single productive client in a productive system....

Regards,

Olivier

[JPReyes · Accepted solution]

hehehe.... very true...

In that specific case it might be quicker a client copy.... but its not the best practice.

You question was "Backup approach prior to system go-live" and the best advice i can give you is that you take a full backup at every milestone to avoid problems.

Best regards

Juan