Post reply

Shrink Db problem

  • August 3, 2005 at 6:38 pm

    #165111

    Hi All,

    I have an 8GB db.  After deleting half of the data in that db and shrinking it, I expected my db would be down to 4GB; however, in the EM, I still saw my db as an 8GB of db.  Please advise.  How can I make it down to 4GB.

    Thanks,

    Minh Vu

  • August 3, 2005 at 8:50 pm

    #579413

    check out dbcc shrinkdatabase in bols (not totally sure of the syntax).

  • August 3, 2005 at 9:43 pm

    #579425

    I did shrink the db by using dbcc, but the problem was my db did not got shrunk at all.

    Minh

  • August 3, 2005 at 9:56 pm

    #579429

    What type of data did you delete?

  • August 3, 2005 at 11:52 pm

    #579436

    text data

  • August 4, 2005 at 6:30 am

    #579525

    That's you problem... The only solution I know to that problem is to recreate the table (without the text columns, but EVERYTHING else), reship the data to the new table and drop the old table. Then the shrink will work.

  • August 4, 2005 at 8:18 am

    #579590

    After I shrink a database or file, I always run DBCC UPDATEUSAGE. EM tends to give wrong information until that is run.

    -SQLBill

  • August 8, 2005 at 1:51 pm

    #580517

    yup ... another vestige of the original Sybase code base ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 8 posts - 1 through 7 (of 7 total)

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