Home Forums SQL Server 2005 SQL Server 2005 General Discussion Question about shrinking data files on a read only database RE: Question about shrinking data files on a read only database

  • April 1, 2013 at 11:17 am

    #1602541

    ErikMN (4/1/2013)

    There are a handful of tables in the database but one of them is about 80% of the data and another is about 15% so those two tables hold most of the data.

    thats the root of your problem

    try reorganise only on these tables after shrink.

    ---------------------------------------------------------------------