Hi,

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?

Thank you.

J.

"Jimbo" <james.goodwill (AT) googlemail (DOT) com> wrote

Why not just do a differential backup and see how big it is?

--
David Portas

Jimbo (james.goodwill (AT) googlemail (DOT) com) writes:
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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx