Video Screencast Help

? Configure Begin Time and End time of Reoccuring Job

Created: 25 Jan 2013 | 2 comments

 

Hello,

We have:

  • BE 2012 running on Windows 2008 R2
  • BE 2012 RAWS + Enterprise Option
  • MS SQL 2008 R2 (standard) running on Windows Server 2008 R2
  • SANs used for master, temp, and db (size 200 GB)
  • FULL Backups each night - takes about 30 minutes - during 2hr time period when DB is quiet, but online.

 

During 22 hrs of normal business (online and global customers) we would like to take Transaction Log backups during the day. The other 2 hrs are for DB maintenance and FULL backup. 

 

We have MS SQL STANDARD so limited in how many tasks it can do at the same time.

 

BE 2012 allows job schedule START time (e.g. 6:00 am) and how often job will run (e.g. every 30 minutes) but we do not see a job schedule END time. 

We would like the Transaction Log backup to run during 22 hrs each day, but obviously NOT at the same time we run the FULL backup. 

 

Questions:

How can we schedule hourly Log File backups and not run when the FULL backup is running? (or is this not really a problem)

 

Thank you in advance for your help.

 

-- Bill --

Comments 2 CommentsJump to latest comment

Colin Weaver's picture

Symantec is looking to re-introduce a console based configurationt to implement this

 

Also note you can sort of do it in the console right now by doing something like this:

In a single job defiintion create the following stages

1) Full job at 22:00 daily repeat

2) 1 st Incremental/log job at 06:00 daily repeat

3) 2nd Incremental/log job at 08:00 daily repeat

4) 3rd Incremental/log job at 10:00 daily repeat

... n) last Incremental/log job stage at 20:00 daily repeat

 

Note1:  to create the extra jobs do not use the Add Stage button, click the Edit button next to Add Stage and then use the "Add Backup Jobs by Method" button in the schedule section.

Note2: after added the jobs by method mcke sure you check the SQL options for each job to set the log vs full methods etc.

Obviously this is a little clunky as you have to create a large number of jobs in each overall job defintion but it should achieve the same thing