Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    20

    Unanswered: SQL Server 2005, Task->Shrink

    Hi
    I wanna ask something again in sql server 2005

    Whats is the meaning of task shrink in a database??? Why it have 2 options for database and options????
    Can i use it in all databases or its meanless to small databases

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    This also applies to SQL Server 2005:

    How do I reclaim space in SQL Server?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Not something you want or should need to do on a regular basis. Shrinking the log file because a one-off process created a huge log might be fine. Beware shrinking the data file. It will fragment your indexes, neccesitating an index rebuild, which will in-turn increase the size of your data file. Also, it will eventually lead to physical fragmentation, which will create performance issues. If this is something you're thinking of doing, please answer one simple question - Why?

  4. #4
    Join Date
    Mar 2009
    Posts
    20
    I dont wanna do something i am just asking to learn somethings...
    thank you very much

Posting Permissions

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