Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Unanswered: Database size shrunk

    I will like to request for understanding with regards to SQL data size.

    On Friday, 21 March, I checked from the SQL Server Enterpise Manager that my Data Size was 30 MB.

    I then had my database quota size increased.

    However, on Monday 24 March, I noted that the data size has shrunk to 24 MB even though my client has added about 7k+ of records to the database since.

    Today on 25 March, the database showed 15 MB instead. I checked my records and there was nothing lost in them. The number remains the same or slightly higher. This is because they have almost completed the porting of the data.

    I am confused as to the difference in the display of Data Size. It has lead me to a wrong decision earlier to upgrade to 45 MB when in actual fact, the data doesnt even take more than 16 MB.

    I have during the time truncated the transaction logs. Could this be the cause of the database size to shrink?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check whether AUTO_SHRINK option is used.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2002
    Posts
    3
    Originally posted by Satya
    Check whether AUTO_SHRINK option is used.
    Thanks for replying

    I just checked and AUTO_shrink is off

    Would there be anything else that could cause it to shrink?

Posting Permissions

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