0

I have restored my database on to another drive and renamed it. I have noticed that my actual database size is 500GB where as the restored (New) went to 600GB. Any theory behind this how it happened.

user9192401
  • 168
  • 8
  • 1
    Is 500GB the size of the original database or the backup? The backup doesn't contain empty data pages. As for the size difference, a cluster size difference could account for it. Apart from that one would have to guess about your hardware, server, database configuration – Panagiotis Kanavos Jan 18 '19 at 11:34
  • The size of database was 500GB mate. – user9192401 Jan 18 '19 at 12:15
  • Is it the same version of SQL Server? Have you got all the same fill factors on indexes, or have they changed to new defaults somewhere - maybe there is some other type of default setting difference on what I presume is a different SQL Server installation. – Cato Jan 18 '19 at 14:49
  • @Cato: Yes mate. Restored on same version of Sql server (2008R2 Standard). No changes have been made. – user9192401 Jan 21 '19 at 14:59

0 Answers0