Hello,

IF no DB updates are being made between 5:00pm and 9:00am then a Full DB backup during this period would be appropriate. Probably start after EOD to ensure it is well finished by the next day.

You also need to schedule regular Transaction Log backups during the working day - may be every 5 or 10 minutes. It depends on the maximum data loss that is acceptable and how big the Transaction Log can be allowed to grow to.

You could also consider Differential Backups during the working day - may be every one, or two or four hours. The benefit here is it reduces the number of Transaction Log backups that need to be restored in the event of Disaster Recovery.

Regards,

John Marsh