Darwin Hatheway


SQLServerCentral Article

Differential Backup Prediction

SQL Server 2000 has a rock solid backup scheme , but do you really need to run full backups every day? What if you could decide on the fly if it was more efficient for a full or a differential backup? Darwin Hatheway brings us the basis for a scheme that can predict the size of a differential backup by examining how much of the database has changed.

5 (3)

You rated this post out of 5. Change rating

2006-03-13

7,321 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

CXConsumer wait type issue

By saum70

hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...

How to speed up this?

By water490

Hi everyone One of my SSIS components seem to be very slow.  I am...

Managing some particular dimensions in a data warehouse based on medical records

By pmscorca

Hi, I need to design a data warehouse solution to manage medical records about...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers