April 5, 2006 at 9:22 pm
Can anyone give some advice on performing a database backup based on transactional activity.
Currently the databases are getting a full backup which at the moment is working well for us but with the growth rate of the databases this sort of backup could start to become a lengthy process.
We'd like to change our database backup to a weekly basis based on transaction activity. So only the data within the database that receives any changes would get backed up weekly and then on a monthly basis we would perform a full database backup.
What would be the best way to administer these changes?
April 6, 2006 at 3:34 am
Taking backups of transaction depends on how frequently database is modified.
According my Implementation.
1. Weekly Once take a full back.
2. Daily night take differential backups and
3. Every 4 hours schedule for transactional log backups . this reduces the time to restore the database in case of failure.
But this strategy depends upon the company policy and type operational data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply