Post reply

Different Database file size for Principle and Mirror Database

  • December 16, 2015 at 3:20 pm

    #323393

    I was trying to determine file sizes for my Principle and Mirror databases using sys.sysaltfiles and sys.master_files. The actual (Primary) database size is around 1.8 TB which showed correctly when I executed the queries

    select * from sys.sysaltfiles

    select * from sys.master_files

    But the same set of queries showing around 700 GB size for my Mirrored database.

    Can anyone explain why it showing different sizes

  • December 21, 2015 at 8:51 am

    #1847168

    Do you have a read-only filegroup living on an NTFS compression enabled folder?

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

  • December 21, 2015 at 11:35 am

    #1847222

    The Partition is not NTFS Compressed. I am not able to see the file groups as the database is in restoring state.

Viewing 3 posts - 1 through 2 (of 2 total)

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