Oversize table after backup and restore database RRS feed

  • Question

  • We transfer a database from SQL Server 9.00.5069.99 (2005 SP4) To new Sql Server 13.0.5830.85 (2016 SP2) With backup and Restore process

    Everything looked okay. But after about 20 days one of the tables oversized.

    the specific table used from a cube analysis (packet ssis)

    after check for fragmentation(with run dm_db_index_physical_stats) we see fragmentation percent 86% also on SP_spaceused this table is too BIG 18.GB (on SQL Server 2005 this table has 500MB) and index info is 40KB.

    Also this table don't have indexes on index file
    There is any way to restore table to normal size or shrink ?

    Friday, November 6, 2020 1:14 PM