none
Differential backup ,showing file processed without change in database RRS feed

  • Question

  • Hi Experts,

      After taking full backup of mydatabase its showing following message :

    Processed 20640 pages for database 'adventureworks', file 'AdventureWorks_Data' on file 7.

    Processed 1 pages for database 'adventureworks', file 'AdventureWorks_Log' on file 7.

    BACKUP DATABASE successfully processed 20641 pages in 4.891 seconds (34.571 MB/sec).

    Now agin I am taking differential backup of same database without done any chnage in my database , Then I am getting following message

    Processed 40 pages for database 'adventureworks', file 'AdventureWorks_Data' on file 5.

    Processed 1 pages for database 'adventureworks', file 'AdventureWorks_Log' on file 5.

    BACKUP DATABASE WITH DIFFERENTIAL successfully processed 41 pages in 0.292 seconds (1.148 MB/sec).

    Here I am bit confuse to understand that why this is showing "Processed 40 pages for database " even I have not done any modification in the databse after taken full backup.


    Regards Vikas Pathak


    Monday, December 3, 2012 2:30 PM

Answers

  • A certain amount of overhead is always expected. Think of it as system data, which is always needed. You will never see a valid backup file which is 0 byte in size.

    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, December 3, 2012 3:07 PM
    Moderator
  • I think out of 41 pages 1 page is from Tlog file (I think it is default) and 40 pages from data file.

    Dump the DCM page and identify the extents which got modified. Number changed extents * 8 will tell you how we got 41 Pages.

    Example: DBCC PAGE('AdventureWorks',1,6,3)

      


    Thank you,

    Karthick P.K |My Site|My Scribbles |Blog Space |Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Monday, December 3, 2012 3:10 PM
    Moderator

All replies

  • A certain amount of overhead is always expected. Think of it as system data, which is always needed. You will never see a valid backup file which is 0 byte in size.

    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, December 3, 2012 3:07 PM
    Moderator
  • I think out of 41 pages 1 page is from Tlog file (I think it is default) and 40 pages from data file.

    Dump the DCM page and identify the extents which got modified. Number changed extents * 8 will tell you how we got 41 Pages.

    Example: DBCC PAGE('AdventureWorks',1,6,3)

      


    Thank you,

    Karthick P.K |My Site|My Scribbles |Blog Space |Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Monday, December 3, 2012 3:10 PM
    Moderator