d23f084e   
   From: esquel@sommarskog.se   
      
   Jimbo (james.goodwill@googlemail.com) writes:   
   > I'd like to move to a full/differential backup system on our SQL   
   > servers; we currently just take full backups to disk.   
   >   
   > Before I go ahead and implement the change, I'd like to quantify what   
   > the daily data changes are within a given database, so I can quantify   
   > how large each differential backup will be.   
   >   
   > Does anyone know how I can extract this information?   
      
   As David says, the absolutely easiest way is just to go ahead and do it.   
      
   But I'm wondering, any particular reason you are not taking log backups?   
      
   In case of a crash, what requirements do your organisation have in terms   
   of recovery?   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)