Copy only backups

• Ry-SQL

  SSChasing Mays

  Points: 601

  More actions

  November 22, 2011 at 9:02 am

  #390923

  i am trying to restore a database which was taken using "copy_only". regular log backups were running for the next 3 hours during the backup process.

  coincidentally, a 3rd party tool took a full backup and a copy

  only LOG backup just before my copy only full back.

  when trying to restoring the full copy only backup, it doesnt like my sequence of copy only full to the first regular log backup.

  what is the right way to read the first_lsn, last_lsn, checkpoint_lsn and backup_lsn numbers in the backupset table?

  thank you!

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  November 22, 2011 at 9:08 am

  #1411619

  COPY ONLY backups don't disturb backup chain. If you are trying to match LSN with other backups, it won't.