September 6, 2002 at 2:32 am
Hello
I have a problem on my buisness application software that is resume by some transactions make growing the Log of my database.
Because the application is based on MSDE i can´t shrink my Log by backup them, and when my database goes to 2 GB my account program don´t work.
I need a solution because all the time i must export all the tables in DBF format and open a new blanck database to import all theses tables and also rebuild all triggers and defaults.
for example of volume :
before rebuild : 1,95 GB
after rebuild : 495 MB
I don´t know if an SQL problem, because for example in ACCESS i have the same problem but compacting the database i resolve and get free some space by shrinking the database.
I hope someone could give me one solution for this problem
September 6, 2002 at 5:29 am
Which version of MSDE, most will work with DBCC SHRINKFILE if I remember correctly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 6, 2002 at 7:40 am
Hello again
The version of MSDE is 8.00.8194
just a little correction because my LOG volume is Ok, but is my MDF file that have a big volume.
Best regards
Luis Santos
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply