Posted by: the_hareeb July 20, 2010
s1l server job scheduling question
Login in to Rate this Post:     0       ?        
Hi,
I am trying to schedule a maintainance plan for database backups. 
1. Do Full backup every day @9am
2. Do differential backup every 1 hour. So, my first differential would be @10am
3. Do transactional log backup every 15 mins. So, my first tlog backup would be @10:15am.

I know i scheduled the fullbackups correctly. I am not sure about differential and tlog backups

Diffrential: occurs every 1 hour,first  starting at: 10am, ending at 9am. (so does it stop tomorrow at 9am and starts a new one at 10am tomorrow and thus makes backups every 1 hour?)

Transactional: occurs every 15 mins, first starting at 10:15am, ending at 10am. (same thing here, when i say ending at 10am, does it end 10am tomorrow?. and then start again at 10:15am tomorrow and thus makes backup every 15 mins?)

I have attatched the screenshots of how i scheduled my backups of full,differential and tlogs. Your help appreciated.



Read Full Discussion Thread for this article