Thread: Growth of a database!!??
09-17-07, 09:36 #1Registered User
- Join Date
- Apr 2002
Unanswered: Growth of a database!!??
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!?
09-17-07, 09:47 #29th inning DBA
- 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 --