Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Quantify database data changes

0 views
Skip to first unread message

Jimbo

unread,
Dec 2, 2009, 3:30:45 PM12/2/09
to
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.

David Portas

unread,
Dec 2, 2009, 5:27:39 PM12/2/09
to
"Jimbo" <james.g...@googlemail.com> wrote in message
news:0e8616ee-f63d-459d...@s20g2000yqd.googlegroups.com...

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

--
David Portas


Erland Sommarskog

unread,
Dec 2, 2009, 5:41:42 PM12/2/09
to
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, esq...@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

0 new messages