full Backup without interfering with log shipping

• BradleyB

  Say Hey Kid

  Points: 674

  More actions

  March 27, 2003 at 4:44 pm

  #159644

  Is it possible to do a full database backup on a database that is currently replicating using log shipping, without breaking the chain of logs? Can I do a full database backup without truncating the log and still pick up the data in the log on the next tlog backup?

  Here is a sample of what I am using for full backups

  --full backup

  BACKUP LOG ADVFP WITH TRUNCATE_ONLY

  BACKUP DATABASE [ADVFP] TO DISK = N'G:\CurrentBackups\ADVFP20030327172527.bkp' WITH INIT

  --tlog backups subsequent to full backup

  BACKUP LOG ADVFP TO DISK = N'G:\TLogBackups\ADVFP20030327172745.trn' WITH INIT, NO_TRUNCATE

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 27, 2003 at 6:22 pm

  #452409

  Performing full database backup does not truncated the transaction log so you are still able to continue the log backup as usual.