November 20, 2001 07:20 PM

Shrinking a Bloated Database and Log File

Rating: (0)
SQL Server Magazine
InstantDoc ID #22961

One of my company's applications is running on Informix. I'm in the process of migrating the Informix data to SQL Server 2000. For testing purposes, I created a package that reads records from Informix and writes them into a SQL Server table. Before I copy the original records, I delete them. Here's my problem: I find that although the actual database size is only about 400MB, after 2 weeks, the database size grows into gigabytes and the log file size is huge. And after several day...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here