Results 1 to 6 of 6

Thread: Compression

  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Compression

    Hello,

    I have been wanting to compress my database. I am not really sure how this is done. I was looking on Enterprise Mangr. and if you right click on the db and go to all tasks, there is an option to shrink database. Is this the way you would compress your database, or are there other ways of doing this?

    Thanks for all the help.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    DUMP


    DBCC SHRINKFILE
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Originally posted by Brett Kaiser
    DUMP


    DBCC SHRINKFILE
    How would you do a shrink file?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you have access to Books Online?

    Go to the U=Index and look it up

    Code:
    Examples
    This example shrinks the size of a file named DataFil1 in the UserDB user database to 7 MB.
    
    USE UserDB
    GO
    DBCC SHRINKFILE (DataFil1, 7)
    GO
    Look up DBBC SHRINKDATABASE as well
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2004
    Posts
    164
    Originally posted by Brett Kaiser
    Do you have access to Books Online?

    Go to the U=Index and look it up

    Code:
    Examples
    This example shrinks the size of a file named DataFil1 in the UserDB user database to 7 MB.
    
    USE UserDB
    GO
    DBCC SHRINKFILE (DataFil1, 7)
    GO
    Look up DBBC SHRINKDATABASE as well

    Thanks again for all your help.

  6. #6
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Hi

    Shrinkdatabase May not work All the time . Try using Shrinkfiles too.

    Also, it is not a good practice to leave Shrink_db option checked ..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •