Activity overview
Latest activity by A_J_A
petey wrote:
Since the snapshot backups are logged as full backups, it will only affect any subsequent differential backups. Your transaction log restore chain is still unbroken, as long as you have a full backup, and all subsequent log backups made after that full backup, available.
To make sure I understand you - If I took a full backup a month ago, and have had a hundred full backups and transaction log backups since then, I could still restore by restoring the initial backup, and all transaction logs after that (without needing any fulll backups in between)? (I do not use differential backups) / comments
petey wrote:
Since the snapshot backups are logged as full backups, it will only affect any subsequent differential backups. Your transaction log restore chain is still unbroken, as long as you...
petey wrote:
I see backup records interspersed with my native SQL Backups.
In the msdb..backupset table, what type of backups are recorded as performed by NetBackup?
I have the following backup sequence, with the {59CC1199…. record being a Netbackup VMDK snapshot full backup, and the VNBU0…. record being a NetBackup SQL Server-level full backup. Other items are native SQL Server backups I am able to successfully restore from the initial native SQL backup (last item) up to any other transaction logs without a problem. There are no transaction log files that have an LSN matching the native FULL backup at the bottom, but I can use that FULL backup for some reason. This makes me nervous, but maybe this is normal. You can see that the transaction log chain bypasses the NetBackup full backups.
FileName /BackupFinishTime /first_lsn /last_lsn
Test__20150223203000.TRN / Feb 23 2015 8:30PM / 32000001083100001 / 32000001089400001
Test__20150223193000.TRN /Feb 23 2015 7:30PM /32000001074900001 /32000001083100001
{59CC1199… [VMDK Full] /Feb 23 2015 6:34PM /32000001075600038 /32000001077500001
Test__20150223183000.TRN /Feb 23 2015 6:30PM /32000001065600001 /32000001074900001
VNBU0-677… [NetBackup Full] /Feb 23 2015 6:04PM /32000001069600042 /32000001071400001
Test__20150223173000.TRN /Feb 23 2015 5:30PM /32000001056100001 /32000001065600001
Test__20150223170000.bak /Feb 23 2015 5:00PM /32000001060000042 /32000001061800001 / comments
petey wrote:
I see backup records interspersed with my native SQL Backups.
In the msdb..backupset table, what type of backups are recorded as performed by NetBackup?
I have the following b...
SQL Backup in conjunction with other backup software
I'll refer to SQL Backup pro as SBP so as not to confuse with native SQL Server backups.
We currently use Symantec NetBackup for server-level backup. How does SBP Backup work in conjunction with se...