[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 4153 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
श्राद्द
TPS Re-registration
सेक्सी कविता - पार्ट २
What are your first memories of when Nepal Television Began?
पाप न साप घोप्टो पारि थाप !!
पुलिसनी संग - आज शनिवार - अन्तिम भाग
निगुरो थाहा छ ??
ChatSansar.com Naya Nepal Chat
Lets play Antakshari...........
What Happened to Dual Citizenship Bill
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
मेरो अम्रिका यात्रा -२
Do nepalese really need TPS?
कता जादै छ नेपाली समाज ??
susta manasthiti lai ke bhanchan english ma?
कृष्ण नै अन्तिम सत्य
पुलिसनी संग - आज शुक्रवार - भाग २
Will MAGA really start shooting people?
Nas and The Bokas: Coming to a Night Club near you
राजदरबार हत्या काण्ड बारे....
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year.
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks
TPS Update : Jajarkot earthquake
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