Posted by: UME$H July 20, 2010
Login in to Rate this Post:
0 
? 
?
I remember doing this long time ago. I have something to say about it.
1. Full back up and T LOG is fine for most of the case. Why are you doing Full backup and differential backup both? Full backup is good for small database but if you have large database and you are doing over network, differential backup is fine.
2. I noticed your backup time and it looks odd to me. Generally backups are done at night (after all jobs are committed during day work).
It is just my experience and may not match with you though.
Regards,
UM3$H
1. Full back up and T LOG is fine for most of the case. Why are you doing Full backup and differential backup both? Full backup is good for small database but if you have large database and you are doing over network, differential backup is fine.
2. I noticed your backup time and it looks odd to me. Generally backups are done at night (after all jobs are committed during day work).
It is just my experience and may not match with you though.
Regards,
UM3$H