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
Absolutely that is exactly what we do. Naomi
Steve -
We do pretty much the same thing. Use SQL Backup to do a full backup nightly and then transactional logs at increments during the day. We script a copy of those backups and log files to our test server so we constantly have at least luke warm data over there. We use Backup Exec nightly to get the full backup file and save it in another location as well.
I've successfully restored from this backup with no loss of data (but we were lucky, it died at night when there was little activity on the system).
Good luck!
Heather
Seattle Rep