Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Point in time recovery for SQL

Created: 17 Feb 2013 • Updated: 20 Apr 2013 | 3 comments
captain jack sparrow's picture
This issue has been solved. See solution.

hi folks

Is Point in time recovery possible with SQL in NBU 7504?

we are looking for 15 mins Trx. Log backup on disk using NBU (frequency based schedule)

is it possible to customize pre-defined time interval to 15 mins instead of default 1 hr

or any other method possible?

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

RLeon's picture

bpplschedrep <policy> <schedule> -freq 900

It will show up as 0 hours in the GUI (refresh needed), but you can see it is in effect with bppllist <policy> -U

SOLUTION
captain jack sparrow's picture

rleon

will it be good to use synthetic method for frequent transaction log backups

any possibilities of replicating/duplicating cumulatative backups to tape media after certain hours (e.g. 10 hrs)

 Cheers !!!

CJS

RLeon's picture

Synthetic will not work with DB Transaction logs. At the application level / db level, the T.logs are always fresh new, you cannot combine old ones to make a new one.

Because of the way DB T.logs works (not just MS SQL, but all DBs), for as long as you have a T.log backup, you could always use point in time restore.
You could even restore pass the point the backup was created, by utilizing Tail-log backups and restores, which is also supported by Netbackup.

Because of how flexible PIT + Tail-log restores are, the need to make extremely frequent backups is somewhat mitigated. Hourly T.log backups should do in most environments, unless your's has particularly strict requirements.
Sometimes even hourly T.log backups would be overkill, depending on how frequently the DBs are updated. Best to discuss with DBA.

I would recommend something like a weekly full, daily cumulative ("differential" in MS SQL terms), and hourly differential (T.logs in MS SQL terms).
You will need 3 different policies because of 3 different .bch scripts.

The best Nbu document that explains the SQL T.log restore concept is actually not the Nbu SQL or Oracle guide, but the Enterprise Vault guide, under the section "About backup image restore sets".

The only way you could time the duplication hours would be to use Nbu Vault.
If not then you could always try the OS scheduler jobs to trigger SLP active/inactive scripts.