backup during peak hours
when the production hours are peak round the clock, how would you select the best time to do a good FULL backup, for the 24 hour period.?
what kind of transactions would cause you defer the backup.? and what kind of activity is better for the backup to be the least hinderance? (read or write, index usage etc)
thanks
what kind of transactions would cause you defer the backup.? and what kind of activity is better for the backup to be the least hinderance? (read or write, index usage etc)
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
lcohan. would to be able to compare HP tool you mentioned with the above?
ASKER
some times are busier than others- management does not want to consider adding servers at this time.. but wants to just tweak the best time for the backup, for starters..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
niaz/lcohan
the tape backup is taking random time each day for completion - some days 1 hours, and some tims 7-8 hours - so what I can see is that if there are a lot of transactions at that time, then it affects the backup.
the tape backup is taking random time each day for completion - some days 1 hours, and some tims 7-8 hours - so what I can see is that if there are a lot of transactions at that time, then it affects the backup.
ASKER
niaz, any reason you recommend incremental and not differential?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>Yes, you are right "acperkins"<<
Yes, I know, but thanks. Incidentally most people here call me by my name: Anthony.
Yes, I know, but thanks. Incidentally most people here call me by my name: Anthony.
ASKER
Thank you experts.
ASKER