Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    Red face Unanswered: Growth of a database!!??

    Hi everyone,

    I'm a beginner in SQL Server databases, my problem is this:

    i'm making a database witch the frontend is an access project, the database has several stored procedures views and user functions (the normal..), but a few data, (only the experimental), last night i've noticed that the file grow from 22 MB to 89 MB, the objects are the same and also the data, the only diference was that i forgot to put in an event procedure code, the ADO method, "MoveNext", to update various records, and the loop was infinit.
    Is it possible that SQL statments generated by ADO make the file grow so rapidly!?
    If so how can i shrink it, because i've tried and and the results was 4%.

    Can you help me!?


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    1. Ensure database is in simple recovery mode.
    2. Backup database
    3. Run dbcc shrinkdatabase against the database.

    You can find each of these topics in Books Online.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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