Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: 28+ hours to shrink?????

    My database is current 135GB. I have been running the following:

    DBCC SHRINKFILE([database_data],2)
    DBCC SHRINKDATABASE ( [Database],20,TRUNCATEONLY)

    It's been running for 28 hours. Should it be taking this long? If I stop the shrink, will it need to rollback?

    Thanks!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    First, you shouldn't have executed those 2 commands together. Second, you only need to shrink a database file if it underwent an unusual and substantial growth. Never do it in an automated fashion, because you may unnecessarily fragment your data pages on a continuous basis.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How big is the actual data file

    How big is the transaction log?

    And wouldn't you shrink the database first, then the file?

    have you truncated the log?
    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.

Posting Permissions

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