Results 1 to 7 of 7
  1. #1
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40

    Unanswered: SQL db size will not decrease after deleting data

    Hi

    I installed " Web Wiz Forum ASP SQL 2000 DB "

    it work fine but
    when i added some data in the forum for example my db size is 1.45 MB

    after i delete those data the db size will not decrease

    is there any code that i must enter on the sql server setup file

    Excuse me i asked this question in the web wix forum site but they don`t
    answer me

    if know what i must to do plz tell me


    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You need to:
    1. Set the recovery mode of the database to simple (assuming you're not doing transaction log backups).
    2. Run DBCC SHRINKDB('dbname') on the database.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    OK

    The No 1 is OK I will do it

    but the No 2

    ( 2. Run DBCC SHRINKDB('dbname') on the database. )
    what is that and how and where can I use it

    Thanks

  4. #4
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    Run the script in Query Analyzer or use osql.. Another alternative is to use enterprise manager, right click on the database in question and select all tasks & shrink database.

  5. #5
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    oh no

    I told you I am using ASP programs
    and the DB is on the internet

    ==============


    Nothing happened to Database

    I installed The SQL server 2000 on my system

    and run my forum on a new database and ran this codes on that
    but when i open the Database Options window i saw that nothing changed and
    the recovery mode is set to " FULL"
    or the Auto shrink in unchecked


    I changed it manualy and ran the forum but i Still have that problem

    what happened?

    oh my god

    Help me please

  6. #6
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    Hey anybody Help me

    just tell me how can i use this code in ASP

    DBCC SHRINKDB('dbname')

    when i use it nothing happened and i still have the problem

    Please help me

  7. #7
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    Hey anybody help me

    Where are you?

    Hey "derrickleggett" where are you help me please

Posting Permissions

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