Backup SQL server
We are testing BE2012 and running full backup on our existing SQL server for enjoy SDR.
As our old practice we would like to keep a bak files for each database to restore a database when needed.
But now we found that the differential backup will be fail if we still using SQL to backup the databse file.
I had search the internet and found that we can also copy the database file to disk through Backup Exec.
But it only generate the differential of the database for each days. If we need to restore our database need manually restore from the full bak then restore the differential bak file one by one.
May we know is there any other solution for keep using BE2012 to backup all the data on our SQL server for enjoy SDR but also using the SQL database server to backup the full bak files everyday?
Thank you very much