Post reply

Number of pages

  • August 10, 2012 at 3:00 am

    #279451

    Hi,

    I run a backup of a database. I get a result:

    BACKUP DATABASE successfully processed 179777 pages in 8.564 seconds (164.001 MB/sec)

    Where does SQL Server get the number of pages from? If I look in sys.master_files, it says 186040, so I presume the difference is free space or something. Is this value stored in another system table somewhere? Thanks

  • August 10, 2012 at 2:42 pm

    #1524674

    You can find the backup size in msdb.dbo.backupset.

  • August 10, 2012 at 3:06 pm

    #1524683

    sestell1 (8/10/2012)

    You can find the backup size in msdb.dbo.backupset.

    how does that answer my question?

  • August 10, 2012 at 3:18 pm

    #1524686

    sys.master_files reports the size of the data file in 8k pages. The backup consists of only the data pages that have been used.

  • August 10, 2012 at 5:37 pm

    #1524718

    That # differs type of backup. if you use compression it dispalys diffrent number of pages. So actually it is teh number of pages in the backup made but not the actual number of pages that database is.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply