Announcement

Collapse
No announcement yet.

Shrink database sql 2008

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Shrink database sql 2008

    Hi,
    We have a database that is very large. We have done some cleaning operations in this database and removed some old data that is not needed anymore. So i just wonder if it would be time to use the function shrink database to free up diskspace?
    Can this be done without to take the database offline? Has someone done this? Should i use the shrink database only, or also use the shrink files?
    /R

  • #2
    Re: Shrink database sql 2008

    Lots of information online (e.g. http://www.straightpathsql.com/archi...shrink-button/) but IMHO, unless you are running out of space on the drive, leave the db file and let natural growth use up the free space
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X