[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 3099 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 90 days
Recommended Popular Threads Controvertial Threads
🙏 दलाल स्ट्रिट 🙏
Moving California with gross annual income under 200k
सालीको चाक
ChatSansar.com Naya Nepal Chat
शक्तिसाली राष्ट्रको ताण्डबि क्रियाकलाप : नेपालको पालो पनि आउने हो कि ?
is Rato Bangala school cheating?
TPS Holder with travel document
राम्रो गर्छु भन्दा कहिले काही नराम्रो पो हुदो रहेछ...
What is your "pir" about Nepal after watching "pir?"
Abortion should be illegal in US
Understanding Dharma
Democrat wants to run election like in India. Chaos and Confusing to voters.
Bloom Nepal School, Lalitpur Opportunities
के नेपाल टाट पल्टी सकेको हो ?
TPS Nepal travel on Advance Parole
Cool Nepali TShirts,Check out the artwork people
शुभयात्रा बिश्वभ्रमण अभियान 2022
"दर्जनौ" र "धेरै" नेपाली गीत गाएकी लता प्रति यस्तो श्रद्धान्जली
Returning back to Nepal was a good decision
TIA -- Travel Related Covid Infomation
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