01-23-2013 07:32 AM
Hello,
We have:
Separately, we backup the entire Windows 2008 R2 server where MS SQL 2008 R2 is installed (i.e. only has C: drive)
The database files reside on attached SAN and not on the C: drive.
Due to size, we want to only backup SQL and not everything on the C: drive and not everything on the SANs
When configuring BE 2012 for SQL backup, it sees MS SQL and the several databases and their correct sizes.
Questions when setting up configuration:
If the databases were smaller we would just try various options and see, but due to their size and the time required to backup, it would be a lengthy trial and error process.
Thank you in advanced for your help,
-- Bill --
Solved! Go to Solution.
01-23-2013 10:51 AM
The BE SQL agent in effect does a SQL backup straight to whatevere Device you choose as a target using the API provided by Microsoft (and VSS)
If you try to backup the SQL database files directly from the SAN volume instead of via the SQL selection for the database then it will not back them up as Automatic File Exclusion (AFE) blocks the backup of file types that should be protected by specific agents.
1) Only if you want to backup the file system data on the C: drive
2) No as the DB selection handles this for you although if there is non SQL data on the SAN drive then you may need to back this up
3) This will almost give a full DR of the server (System State would also be needed) but the DB info will only be backed up via the SQL selection as AFE will block the file system selection of the DB files so you will not get two copies of the SQL data by selecting both ways in way job - but will get all your C: drive and the non SQL data on the SAN drives
Note: if you ONLY back SQL then a DR recovery would be manually install a server with SQL on the restore the SQL data into it.
IMPORTANT: You have not mentioned if you have a SQL Agent license for Backup Exec - you will need this.
01-23-2013 10:51 AM
The BE SQL agent in effect does a SQL backup straight to whatevere Device you choose as a target using the API provided by Microsoft (and VSS)
If you try to backup the SQL database files directly from the SAN volume instead of via the SQL selection for the database then it will not back them up as Automatic File Exclusion (AFE) blocks the backup of file types that should be protected by specific agents.
1) Only if you want to backup the file system data on the C: drive
2) No as the DB selection handles this for you although if there is non SQL data on the SAN drive then you may need to back this up
3) This will almost give a full DR of the server (System State would also be needed) but the DB info will only be backed up via the SQL selection as AFE will block the file system selection of the DB files so you will not get two copies of the SQL data by selecting both ways in way job - but will get all your C: drive and the non SQL data on the SAN drives
Note: if you ONLY back SQL then a DR recovery would be manually install a server with SQL on the restore the SQL data into it.
IMPORTANT: You have not mentioned if you have a SQL Agent license for Backup Exec - you will need this.
01-25-2013 07:06 AM
Colin,
Thanks for the quick reply. Applied the changes and checked after last night's backup run - works as advertised :)
Thanks,
-- Bill --