First of all you to perform log backup of SQL on hourly basis you would have to do one full backup with Backup-Exec once done you can perform log backup ,but in that case there is no way by which you can restore this to file system you would have to restore this backup to database ,either to original one or by creating an new database called test

Also would recommend you to perrfom backup either from SQl side or only with backup exec

You would need to have an Agent for Applications and Databases for each server to backup the SQL databases on it.

As previously advised you need to do a full database backup using BE before you can do any log backups. Scheduling hourly backups is not so straight-forward in BE 2012. See my article below on how to do so.

If you need a copy of the full backup to keep off-site what you should do is to just do a full database backup to disk and add a stage to duplicate this disk backup to tape. This way you only have to deal with BE, not 2 backup software.

Create on-disk copies of SQL backups to be placed on the SQL Server where the database is located?

==

Creates an on-disk copy of the SQL database being backed up. This option lets you simultaneously back up a SQL database to storage media while also writing a copy of the database to a disk path you specify in the Save to path box.

This option gives IT administrators the ability to back up SQL databases while also providing database administrators with copies of the database on disk, which can be used for such things as tests and restores.

You can but what use is it to you. This option is for people who needs to ship the database to say a development server which is without BE.

You cannot use this copy when you do a restore with BE.

I think you should download a trial copy of BE from www.backtupexec.com and try it out. You have 60-days before the trial runs out. The trial copy will include the SQL option. Asking questions only gets you so far. You got to get hands-on before you know what can or cannot be done.

With the below option, if i duplicate a on disk copies of full database backup and transaction logs backup , i believe we should be able to make use of the disk copies to perform point in time recovery without using BE? i can just use to SQL Server restore point in time recovery option and select the full backup and the transaction logs backup.

Any idea on this?

Create on-disk copies of SQL backups to be placed on the SQL Server where the database is located?

==

Creates an on-disk copy of the SQL database being backed up. This option lets you simultaneously back up a SQL database to storage media while also writing a copy of the database to a disk path you specify in the Save to path box.

This option gives IT administrators the ability to back up SQL databases while also providing database administrators with copies of the database on disk, which can be used for such things as tests and restores.