SQL Agent Questions
We have recently started testing the NBU SQL DB agent with some very encouraging results so far. However, I still have a couple of questions that I was hoping some of you might be able to answer as I haven't been able to find a definitive answer elsewhere:
- Is it possible to redirect a SQL DB restore? Does the restore have to be to the original database, or can it be restored to an alternate database / location?
- What happens to a scheduled transaction log backup if it is initiated while a full database backup is still running? I'm guessing it is best practice to set up the start windows so that this is unlikely to happen, but if a full backup takes longer than expected I'm curious to know if NetBackup will queue the transaction log job or if this could potentially cause some issues on the SQL side of things. I have tried to test this myself, but the performance has been so good while the backup environment is quiet that I've struggled to get the jobs to clash by manually initiating them!