Hello
We have installed EPDM at our US site.
I wonder about the configuration of backups.
Currently we have a total backup of the sql database (from the production vault and conisio master db) every night with a 30-day guard time. It takes up a lot of space : 30x500mb = 15GB and it only allows you to reassemble one backup per day.
The settings of the archive server are also backed up every day
Being in an EMC virtualized environment, the archive servers are backed up via the dedicated system so you have to be able to upload more or less what you want to these servers.
I saw on http://files.goengineer.com/BestPractices/Enterprise%20Backup%20and%20Restore_2.pdf P18 that they had an example with a full backup of sql once a week and then an incremental one per day and a backup of the transaction log every hour.
It seems smarter on paper but backups during working hours are not likely to create more problems than bring an advantage (slowdown of the SQL server, increased risk of crashing during the log backup time..)
What do you think?
How did you set up your different backups ?
Thank you in advance for your feedback