Back when our site was first installed (before my time), our production SQL Server was setup to be backed up using Symantec Backup Exec. We run a weekly full backup, and nightly incremental backups. The database was also configured to use the simple recovery model.
I'd like to change part of this - I want to move to the full recovery model and start doing SQL Server backups (and obviously transaction log backups). I don't want to stop the Backup Exec backups (if it's not broken, don't fix it!).
Can I run both Backup Exec and SQL Server backups at the same time (with the database set to full recovery) without messing up the transaction log backups?
The research I've done implies I can, however I thought I'd ask the experts here.
Thanks in advance.
-steve carlock
Santa Barbara Center for the Performing Arts/The Granada
We also use a SQL Backup to actually backup the database to disk, then use Backup Exec to sweep the SQL backups to tape. We do that for all SQL servers here. Saves purchasing Backup Exec SQL agents for each SQL machine.
This is what we do as well, although we use some simple scripts to copy the SQL backup generated files off the Live server to our Test server, then run our Backup Exec routines on the Test server to get the data to tape.