Home Forums SQL Server 2008 SQL Server 2008 High Availability Delete massive records and still can't shrink db RE: Delete massive records and still can't shrink db

  • October 27, 2016 at 6:17 pm

    #1909273

    Thanks for the reply . Much appreciated .

    Only 1 filegroup which is primary and 1 data file

    The result of your query is as below ( I cut some information but I feel below are the info that you need)

    TypeSizeMBSizeUsedMBFreeMB FilesystemPath

    10ROWS213198.250000213197.6250000.625000

    10LOG29620.000000951.68750028668.312500