Post reply

Shrink Database

  • April 10, 2003 at 3:05 am

    #58617

    I have a SQL6.5 Database and only have about 6% Disk space left on my server. Is there a way that I can shrink the database. I have identified some data that can be deleted, but once done , what next?

    Peter

  • April 10, 2003 at 3:27 am

    #453672

    Use DBCC SHRINKFILE(<file_name>,<size in MB>)

    Jeremy

  • April 10, 2003 at 4:04 am

    #453682

    Thanks Jeremy, but I don't think Shrinkfile can be used in 6.5, I have seen an option called ShrinkDB, maybe this is what I need?

  • April 10, 2003 at 4:08 am

    #453683

    ShrinkDB will shrink the whole database, shrinkfile (where available) shrinks a single file within a database.

    ShrinkDB is probably what you need.

    Jeremy

Viewing 4 posts - 1 through 3 (of 3 total)

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