JDE, MSSQL backup question?

[Scruby]

I have JDE OneWorld with MS SQL 2000. Does anyone know of a document that deals with backup strategies? Currently we are backing up using MS SQL 2000 backup (Complete backup once a week, Differential every 4 hours, and transaction log backups every 30 minutes). Because of the way that JDE writes to different tables that it created, my manager is wondering if we will be able to completely restore the backup if we need to, he said that since we are using JDE and SQL that just using the SQL backup might not be enough. Because JDE write the header to one table and the data to another table and so forth, when the SQL backup is being performed it will not backup uncommitted transaction instead it will wait till the next backup, during that time if we need to restore how do we know if all the header and data is backed up? Can someone point me to a document or something?

 

[karryd]

Scruby,

I have restored JDE from SQL Backups. It is important you backup your transaction logs. They will fill in the areas you are concerned about. Our backup regular schedule is this:

Full Backup weekly
Incremental nightly
Transaction logs are backed up every 2 hours.(and removed every two days.

To recover, restore everything from tape and then restore your transaction logs in the correct order.

You may want to go through the process with one of your test environments. I used PY prior to a scheduled data refresh for my practice restore excercise.

I hope this helps.

KD