[Show all top banners]

the_hareeb
Replies to this thread:

More by the_hareeb
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 s1l server job scheduling question
[VIEWED 3489 TIMES]
SAVE! for ease of future access.
Posted on 07-20-10 9:18 AM     Reply [Subscribe]
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.




 
Posted on 07-20-10 9:20 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 
Posted on 07-20-10 9:20 AM     [Snapshot: 2]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 
Posted on 07-20-10 10:00 AM     [Snapshot: 24]     Reply [Subscribe]
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

 
Posted on 07-20-10 12:04 PM     [Snapshot: 75]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

umesh this was just for testing purposes. you can ignore the times. I just want to check if i am getting the correct results as i expect as per my test plan(look above for my test plan). So my scheduling is ok for my test plan right? thanks for help
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 365 days
Recommended Popular Threads Controvertial Threads
For sajha photographers
🙏 दलाल स्ट्रिट 🙏
Conservative discussions
सालीको चाक
is Rato Bangala school cheating?
##केटा हो ,*Monthly* कती *SAVE* हुन्छ ? ##
Must See Interview . हरेक नेपालीले हेर्नै पर्ने अन्तर्वार्ता तपाई संग समय छ भने यो अन्तर्वार्ता हेर्न नछुटाउनु होला
Intellect of Sajhaites and Nepali in general
साझाका लेखाईले आतंकित बनाउछ
Returning back to Nepal was a good decision
We live in precarious times
Parents' Birth Certificate - Secondary Supplementary Documents
"अन्डा " is way too expensive .
श्रीमान प्रति घट्दो आकर्षण :(
जोईटिङ्रे को उदय
सेक्सी कविता - पार्ट २
पाप न साप घोप्टो पारि थाप !!
In-laws
anyone received 221g in Nepal?
के नेपाल टाट पल्टी सकेको हो ?
is Rato Bangala school cheating?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters