CirquedeSQLeil (8/24/2010)
How long does it take you to perform the full backups currently?What is your allowable data loss in the event of a server down?
How many backups do you intend to keep?
If you elect to do a differential backup, you would need to keep your most recent full backup and most recent differential.
Correct, in simple recovery you do not need to perform transaction log backups. If the data loss potential is acceptable for that, then you are fine. However, if data loss of a day is not acceptable, you should consider changing to full recovery model and backup your tran logs.
At the moment it takes about 2 hours and 30 minutes and growing.
It is a live Database so the less loss Data, the better but I would say few hours.
I would like to keep all the Database Backups.
I am looking for a Backup that would take less space, meaning I would like to recover the data easily if disaster occurs but at the same time I would like the backup to perform quickly and take minimal space, if that would be possible.