> > This is going to become a bigger problem for us as the database will > > only get bigger so any advice welcomed.
Perhaps, rather than backing up the live data, you create an append only log of each and every query you send to the database. Should you need to restore, you replay the log of statements. Or at the appointed backup time, you replay the day's log of statements into another database. No need to ever take the live database offline at the cost of slightly longer running commands during the day to handle the append operation.
