How to set backup every 15 mintues in Sql Server.

[Cappino]

HI all,

is possible to implement a backup every 15 minutes in sql server for the transcation log? 
I have tested, but it always starts a transaction log for hour. 

My environment is NetBackup 7.5.0.6 on Linux Red Hat OS.

Thanks.

Regards

[Marianne]

You can change the schedule from cmd:
bpplschedrep <POLICY_NAME>  <SCHEDULENAME> -freq 900

Ensure the schedule type is Frequency.

PLEASE do not open the schedule again in the GUI as this may change the schedule backup to every 1 hour, as this is the minimum that the GUI can do.

Once the schedule is changed, refresh the scheduler with:
nbpemreq -updatepolicies 
(I was personally unsuccessful trying above command to reread policy config, and had to wait for nbpem to automatically reread policy config as per the global config (default is every 10 minutes).)

[Luv2Learn]

It seems this has been discussed in one of the earlier post . 

https://www-secure.symantec.com/connect/forums/sql-agent-transaction-log-backups

[Walker_Yang1]

From NBU admin console, you can configure the mimimal interval for schedule to 1 hour, if you want the interval of 15mins, you could edit info file of schedule. Here is an Windows example for your reference, Linux is simliar:

Edit "C:\Program Files\Veritas\NetBackup\db\class\test\schedule\full\info" file, and modify the following entry(by default it's 604800, indicates one week),

FREQUENCY 900

hope helps.