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
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?
Discussion Filed Under:
Comments 1 Comment • Jump to latest comment
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.
Would you like to reply?
Login or Register to post your comment.