home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,485 of 19,505   
   Anton Shepelev to All   
   Re: Make a backup only if necessary   
   29 May 24 00:52:33   
   
   From: anton.txt@gmail.moc   
      
   Erland Sommarskog to Anton Shepelev:   
      
   > > I still fail, however, to understand why `first_lsn'   
   > > changes for each subsequent diff. backup.  It is   
   > > described as the "log sequence number of the first or   
   > > oldest log record in the backup set." Since the last   
   > > five diff. backups were generated with respect to the   
   > > same full backup, I expected them to have the same   
   > > first_lsn.  Why do they not?   
   >   
   > Because the backup itself is logged.   
      
   Thank you.  Now my system uses LSNs to avoid storing   
   redundant differential backups, and I like the result.  When   
   I look at a "batch" of my backup files (one full and   
   sequence of differential ones), instead of the typically   
   reguarly spaced files I see only backups taken when the   
   database was in flux, which is great.   
      
   --   
   ()  ascii ribbon campaign -- against html e-mail   
   /\  www.asciiribbon.org   -- against proprietary attachments   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca