BE2010R3 - GFS Template for SQL Backup Jobs?

[Nuri_Inuki]

So according to what I've been advised, when backing up a SQL server, I need to do:

1. A backup job of the SQL Server's file system with AOFO
2. A backup job of the SQL Server w/o AOFO
3. A backup job of the SQL Server's transaction logs

So...how does one do this in a GFS template?  From what I can tell, I can only specify one selection list per template...so...I'm lost. I don't know how I would set up the jobs.  Am I over thinking it?
 

[pkh · Accepted solution]

The file backup job (job 1) should have its own GFS policy.

The SQL database backup (job 2) can have its own GFS policy.  This is independent of job 1.

The log backup job (job 3) do not need to have a GFS policy.  A simple job will do.  A log backup is only good until the next SQL database backup, so there is no need for long retention.