Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-05-08 : 01:19:14
|
| Does backup exec maintain a separate sequence of tran log backups?eg consider this scenario1. Sun - full Backup Exec/Avamar to tape2. Mon - tran log Backup Exec/Avamar to tape3. Tue - full Backup using SQL Server4. Wed - tran log backup using SQL Server5. Thu - tran log Backup Exec/Avamar to tape6. Fri - tran log backup using SQL ServerTo restore to Thu from Sun, do we only need to restore 1,2,5 or do we need 1,2,4,5And to restore to Fri from Tue do we only need 3,4,6 or do we need 3,4,5,6Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-05-08 : 14:13:06
|
| There is no separate sequence for Backup Exec. If you perform a transaction log backup with it and also are using BACKUP LOG, then you'd have to grab the tape file plus the disk files. Do not mix packages with transaction log backups. Use or the other, but never both. I highly recommend using SQL Server to do the backups and then using NetBackup (or whatever your tape solution is) to sweep those SQL backup files to tape.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-05-10 : 17:22:04
|
| Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Mix of Backup-exec & SQL Server backups