Home Forums SQL Server 2005 Backups Create a policy to avoid backups withou copy_only option RE: Create a policy to avoid backups withou copy_only option

  • December 12, 2012 at 1:45 am

    #1567745

    Hemant.R (12/12/2012)

    hi ,

    you can used copy_only option to take full backup. when transaction log backup job created for same database .

    bcoz it will not break lsn squence of database .

    A FULL backup will not break the log chain LSN if you dont specify the COPY_ONLY option. The only time a log backup is dependent on the FULL backup is when it is the first ever FULL and log backup for the database, or if the database has been changed from Full to Simple to Full.

    The only base a FULL backup resets is the differential base