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,481 of 19,505    |
|    Anton Shepelev to All    |
|    Make a backup only if necessary    |
|    27 May 24 12:59:29    |
   
   From: anton.txt@g{oogle}mail.com   
      
   Hello, all   
      
   I am working on an in-house backup solution for our MSSQL   
   databases, and have found that a differential backup may   
   take considerable space (around 1 Mb) even if /no/ changes   
   have been made to the database since the previous full   
   backup. Is it possible somehow, before making another   
   differential backup, to check whether it makes sense, i.e.   
   whether the database has changed since the previous (full or   
   differential) backup? In fact, I do not need a criterium,   
   and a mere necessary condition will suffice.   
      
   I want to make sure that my differential backups are not   
   useless. One solution is to compare byte-for-byte each new   
   diff. backup with the previous one, and delete the copy if   
   it turn out redundant, but I wondered if there were a   
   simpler method.   
      
   --   
   () 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