Video Screencast Help

BE2010R3 - GFS Template for SQL Backup Jobs?

Created: 09 Oct 2012 • Updated: 16 Oct 2012 | 1 comment
This issue has been solved. See solution.

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 does one do this in a GFS template?  From what I can tell, I can only specify one selection list per'm lost. I don't know how I would set up the jobs.  Am I over thinking it?

Comments 1 CommentJump to latest comment

pkh's picture

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.