Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2009
    Posts
    9

    Unanswered: SQL server database size

    Hi,

    I had delete some data from my sql server 2000 database, but after I deleted it, when i checked the properties of my database, the size did not change where it should decrease after i delete some of the data.

    Anyone can help me on this issue???

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The database size does not change, because SQL Server is not Access.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I never noticed access to shrink that much....
    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
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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.

  6. #6
    Join Date
    Dec 2009
    Posts
    8
    you have to use database shrinkfile (log files and data files)

    ------
    AKAROUCHE Mohamed

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    "It shrinks like a frightened Turtle"
    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
  •